View Single Post
  #8   Report Post  
Biff
 
Posts: n/a
Default

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