Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Search multiple words and display result?
Hi all,
I am looking for a formula that will search a cell for specific words and display the results. As an example i need to search for "S01 S02 S03" etc.. and have it display what it finds. Thanks |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
Quote:
Thanks for this. This has solved my problems and everything is now working as it should for this. Thanks again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a vlookup to search multiple criteria for one result? | Excel Worksheet Functions | |||
Search for multiple words | Excel Programming | |||
How do I do a multiple search using key words in a text string | Excel Discussion (Misc queries) | |||
display words in a formula result in Excel | Excel Worksheet Functions | |||
Search for multiple words | Excel Discussion (Misc queries) |