springs

Junior Member

Posts: 3

Quote:

Originally Posted by Kevin@Radstock

Hi springs

This is similar to another post that I have just answered. See the attached file, see if that is something that you can work with.
In Cell B2 and copy down: =IFERROR(LOOKUP(20^20,SEARCH($D$2:$D$4,$A1),$D$2:$ D$4),"")

Replace the IFERROR if you have Excel 2003 < with IF & ISERROR.

Hi,

Thanks for this. This has solved my problems and everything is now working as it should for this.

Thanks again.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Using a vlookup to search multiple criteria for one result?	srm6	Excel Worksheet Functions	9	March 18th 13 05:00 PM
Search for multiple words	ogopogo5	Excel Programming	3	October 9th 08 02:33 PM
How do I do a multiple search using key words in a text string	patricia tipp	Excel Discussion (Misc queries)	1	February 28th 06 05:01 PM
display words in a formula result in Excel	dhollifield	Excel Worksheet Functions	2	November 18th 05 03:41 AM
Search for multiple words	Kassie	Excel Discussion (Misc queries)	0	March 25th 05 05:21 PM

All times are GMT +1. The time now is 08:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us