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
=OR(ISNUMBER(FIND(A1:A4,$D$2)))
entered with Ctrl+shift+Enter (since this is an array formula) will tell you if one of the items in the list in A1:A4 is contained in the string in D2. The test is case sensitive. If you want to know which one, then enter this with Ctrl+Shift+enter (since this is an array formula) rather than just enter =INDEX(A1:A4,SMALL(IF(ISNUMBER(MATCH("*"&A1:A4&"*" ,D2,0)),ROW(A1:A4),FALSE),1)) -- Regards, Tom Ogilvy wrote in message oups.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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 cell for text value from list | Excel Programming | |||
Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) |