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!
|