Search multiple words and display result?

S

springs

Hi all,

I am looking for a formula that will search a cell for specific word
and display the results.

As an example i need to search for "S01 S02 S03" etc.. and have i
display what it finds.

Thank

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 
S

springs

Kevin@Radstock;1610419 said:
Hi springs

This is similar to another post that I have just answered. See th
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 no
working as it should for this.

Thanks again

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top