Menu

Searching cell for text value from list

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.programming

Dave Peterson Dave Peterson is offline

Dave Peterson is offline

external usenet poster

Posts: 35,218

Default

Searching cell for text value from list

You have an active thread elsewhere.

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!

--

Dave Peterson

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem searching cell text	tommcbrny	Excel Discussion (Misc queries)	3	May 15th 08 05:00 PM
Format a text cell for searching	DavidM[_2_]	Excel Discussion (Misc queries)	1	March 28th 07 03:05 AM
Searching cell for value from list	[email protected]	Excel Discussion (Misc queries)	9	February 11th 07 11:08 PM
Searching, matching then searching another list based on the match	A.S.	Excel Discussion (Misc queries)	1	December 13th 06 05:08 AM
Searching text in a cell range	ShareerIslamabadiMunda	Excel Worksheet Functions	7	December 16th 04 09:55 PM

All times are GMT +1. The time now is 02:21 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement