search a word form a list, in a sentence

[danbitton]

Good morning !

I would like if one of the words, from a list of words, is in a sentence. Example :

Checklist:
I
Dan
Plate
Tomato

Cell to check:
A .B
you eat tomatoes false (because the word is tomato, single)
He eats a tomato. true
Dan eats. True
He likes carrots. False


Thanks very much

 

[DanteAmor]

Try this:

Dante Amor
	A	B	C	D
1	SENTENCE			CHECKLIST:
2	He eats a tomato.	TRUE		Dan
3	Dan eats.	TRUE		Plate
4	He likes carrots.	FALSE		Tomato
Hoja1

Cell Formulas
Range	Formula
B2:B4	B2	=IF(SUM(--ISNUMBER(SEARCH($D$2:$D$4,A2))),TRUE,FALSE)
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Tom.Jones]

Try

=SUM(--ISNUMBER(SEARCH($D$2:$D$4,A2)))>0