Matching similar (not duplicate) terms in 2 columns

[fstone33]

Hi eveyrone,

Haven't been able to find an answer about this after scouring the web, so hopefully you can help me out!

I have two columns E.g.

A
Product
Apple Juice
Orange Juice
Grape Juice
Grapefruit Juice
Melon Juice
Watermelon Juice

B
Product
Apple
Orange
Cherries
Plum
Pear
Banana

I am trying to match the terms in column B to column A to see if any of the first words are repeated. E.g. in the example above, Apple and Orange would be highlighted in column B (as the part of this cell content appears in A).

Is this do-able?

Thanks very much for any help you can offer- it's much appreciated!

-Fred

[brokenbiscuits]

You could highlight the range and use the following conditional formatting:

=COUNTIF(A:A,"*"&B2&"*")>0

or similarly add a helper column to flag up with an X:

=IF(COUNTIF(A:A,"*"&B2&"*")>0,"X","")

[fstone33]

Thank you so much! Just tried it and so far so good.

Thanks again...