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.
Quote:
Originally Posted by springs
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
|