Function that searches for words in any number of cells

[jako000]

screen attached.

i need a function that searches for the words in D1:D4 in A1:A4.

if a word is found in this case ba is found in a4 the function needs to tell me "found" else "".

thanks!

[#2]

@jako000 

Try this one to find words in D within text in A:

=IF(SUMPRODUCT(IFERROR(FIND(D1,A:A,1),""))<>0,"Found","Not found")

... and copy it down.

[#3]

@jako000 

If full word to find

=IF(COUNTIF($A$1:$A$4,D1),"found","")