Hi I've got close to solving this issue but cant quite get it working.
I need to search a cell containing several words to see if contains any words from a long list I have and return a true/false response
I found some great formulas on this site which come really close using vlook up/if/search/index/match/find combinations and I can only seem to compare one word to the cell I am searching, not the full list.
Attached is an example of the challenge
Cell content examples:
300g organic minced beef
6x lincolnshire pork sausages
12 oranges
Search key words list example:
Cheese
Pork
Beef
Challenge:
I want to check each cell to see if any words in the cell match any words in the list.
So the responses I would expect in this example would be
300g organic minced beef - True
6x lincolnshire pork sausages - True
12 oranges - false
Im getting close with this
=IF(ISNUMBER(SEARCH($F$3:$F$5,B5,1)),(TRUE),(FALSE))
But it doesn't recognize the range F3:F5 and is only looking one of the items in the range.
I have about 5000 cells to check against a list of 400 items, I've got as far as I can so any help greatly appreciated.
Thanks
Andy
Ingredients example.xlsx
Bookmarks