Compare data - one cell to multiple cells
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?
|