Searching cell for text value from list
 

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!

Searching cell for text value from list
 

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!