Highlight the cells containing the 120 words you wish to search throug
and give the range a name (e.g. MyWords)
List the ten words you want to find in a separate column then, to th
right of each cell, type the following formula:
=COUNTIF(MyWords,B1)
Where MyWords is the name of the 120 word range and B1 is the cel
containing the word you wish to find. If the word is in the list th
formula will return 1, if not it will return 0
