Find words from a list in text of another column and return matching word if found
Posted on 2013-12-31
I have a list of words in a column e.g. names of fruit in A2:A8
And I have a column of rows of text that may or may not contain one of the words in the list. e.g. Comments in Col. C
My favorite fruit is apples.
Oranges are a good source of vitamin C.
Ripe pears taste good but so do bananas.
My favorite pet is a dog.
If one of the words in Fruits is found in the text, I want to enter the matching word in a cell in Col B, else leave it blank.
I'll take the first occurrence of a match.
What is a good way to do this?
Thanks in advance!