Compare data - one cell to multiple cells

S

srs710

Hello wise Excel users,

I need to compare a word in a single cell to a group of words. If that word
matches any one of the group then I'd like it to return "true". The group of
words are currently in a comma delimited text file so I can arrange them
however I need to.

How can I go about doing this?
 
A

aristotle

Hi,

Assume the word you want to find is in cell A1, and the string of text you
want to search within is in cell B1:

=IF(ISERROR(FIND(A1,B1,1)),"Not found","Found")

Regards,
A
 
Top