Think we could try instead in D2:

= IF(AND(ISNUMBER(FIND("USDA",C2)),ISNUMBER(FIND("GR ADE",C2))),1,"")

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"brantty" wrote in message
...
that worked. Now not to complicate it, but can I also search for two words
in
the same cell but not in any order, just "USDA" and "GRADE" anywhere in
the
sentence?