Are column B cells hidden somewhere anywhere in column C? Give results in column A. (true/false or yes/no) I'm unable to post the simple Excel image I've created as I'm a guest, but it shows simply what's needed.
Col A has formula =not(isna(match(b2,$c$1:$c$1000,FALSE))) Obviously this does show a TRUE result if abc is in both column B and columns C, but I need it to find abc in column C if abc is mixed in with others, such as xxxabcxxx.
Column B cells coming down are simply abc def efg Column C show xxxxabcxxx xxdefffxxx xxxxxxefgxxx and so on.