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