Try...

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

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

Hope this helps!

In article ,
"Frances" wrote:

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