You don't say what "it" is that you're looking for, but this will tell
you whether any of the symbols show up in the sentence (array-entered:
CTRL-SHIFT-ENTER or CMD-RETURN):

=IF(OR(ISNUMBER(FIND(A1:A4,D1))),"Match","No Match")



In article .com,
wrote:

Hi, I have been trying for DAYS to get this problem solved. I have a
list of stock symbols and a cell which may contain a value from the
list.

For example


Stock Symbols

ADNC
SEDG
EDSW
TFDE

And a cell that could contain a value from the list.
Eg.

"I think SEDG is a very popular stock."

I have seen on the net "code", but I'm sure there must be a formula
for this! I would be interested to see what it is.

PLEASE HELP!