Experts,
I have a list of words in a column e.g. names of fruit in A2:A8
Fruits
Oranges
Apples
Pears
Bananas
Kiwi
Cherries
Strawberries
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
Comments
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!
However, I'm having trouble applying it to my actual data (which is not the sample data I provided).
Can you plug some pseudo code into the formula to document what data goes where from my sample? e.g.
=IFERROR(LOOKUP(really big number,SEARCH(wordstofind,