You can use the same syntax for an OR situation:
=IF(OR(ISNUMBER(SEARCH({"USDA","GRADE"},C1))),1,"" )
Biff
"Max" wrote in message
...
Thanks for refinement, Biff !
Much neater ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Biff" wrote in message
...
=IF(AND(ISNUMBER(SEARCH({"USDA","GRADE"},C1))),1," ")
Biff
|