On 11 Feb, 19:00, "Don Guillett" wrote:
Pls post in ONE group only

--
Don Guillett
SalesAid Software
wrote in message

ups.com...



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!- Hide quoted text -

- Show quoted text -

Sorry I was becoming inpatient, as this problem has been bugging me
for days. I'm sure you'll understand my frustration.