Hi, I'm trying to see if any keywords in column B match any of the keywords in column A. I need a formula that will return any value so that I can filter out and save the list of keywords in column A into another workbook. It can't be an exact match. I just need to see if any of the keywords in any way are present in column A.
Example:
Column A
womens shoes size 4
womens shoes size 6
blue shoes
red shoes
purple shoes
Column B
size 4
6
purple socks
In this case the formula should return a value for these keywords in column A:
womens shoes size 4
womens shoes size 6
purple shoes
Thanks,
Bookmarks