Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem searching cell text | Excel Discussion (Misc queries) | |||
Format a text cell for searching | Excel Discussion (Misc queries) | |||
Searching cell for value from list | Excel Discussion (Misc queries) | |||
Searching cell for text value from list | Excel Programming | |||
Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) |