Also, if you wish to return the result in one cell...

=IF(SUMPRODUCT(--(ISNUMBER(SEARCH(B1:B5,A1)))),"Found","Not Found")

OR

=IF(SUMPRODUCT(COUNTIF(A1,"*"&B1:B5&"*")),"Found", "Not Found")

Hope this helps!

In article .com,
wrote:

Is there an Excel function that can determine if any value in a range
is contained in a given cell.

Ex

Range - CC, DD, EE, FF, QQ
Cell - Yabbadee

Desired function would indicate that EE was found in cell (last 2 chars
of Yabbadee).

VLOOKUP would not indicate that EE was found in the cell (exact match
required). If the cell value however was CC, DD, EE, FF, or QQ it
would find a match.

TIA