Solved: Searching for multiple values within cell

[unmarkedhelicopter]

You could try using mdmackillop suggestion.

Example:

=IF(ISERROR(SEARCH("Chicken",A2)),"No meat","Meat present")

Or for multiple searches.


=IF(COUNT(SEARCH({"Chicken","Beef","Fish"},A2)),"Meat present","No meat")

I'll buy one of these please