"Search" Function with answer prepared by Biff for Brantty on 01/0

[Guest]

Dear All,

I found the following beautiful formula from one question raised by Mr
Brantty on 01/08/2005 and the answer is prepared by Mr Biff.

=IF(OR(ISNUMBER(SEARCH({"USDA","GRADE"},C1))),1,"")

I would like to apply the search by data field instead of specified data
like "USDA". My search data involve more than 2 criteria and they change
every time that it would be very troublesome to modify the formula every time.

I tried =IF(OR(ISNUMBER(SEARCH({$A$1,$A$2},C1))),1,"") , but it does not work.

In my case I prefer not to use vlookup or VBA or macro in order to ease the
users.

Thanks

Frances

 

[Domenic]

Try...

=IF(OR(ISNUMBER(SEARCH($A$1:$A$2,C1))),1,"")

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

 

[Guest]

Domenic:

Thank you very very for your help.

Frances

 

[Guest]

Dear Domenic,

Thanks very much for your help with the formula below.

How can I apply this formula to the conditional formatting as I want to
highlight the data found?

Frances