You likely will need to clearly define "occurs somewhere in column B". Suppose you have a value for A of "apple". Does that "occur" in B if B has a value of "Apple" (case difference)? If B is "apple  pear" (not equal to but is part of the string? If B is "APPLE pear" case and part of string? If B is "applesauce" part of the string but not a whole word? If B is "Applesauce Pear juice" case difference and part of a string but not a whole word?   If A is a more complex value such as "apple banana grape" then you get even more complex elements to consider such as all the components of A are in B but the order is different, in addition to the not word sub-string possibilities. ... View more