Sorry, guess I didn't test my formula well enough... try this:
=IF(ISNUMBER(FIND("Food Sales",A1)),"Found","Not Found")
Blank cells or numeric cells or text cells not containing the FIND text will return "Not Found" (adjust this response as desired)
Let me reiterate that FIND is CasE SenSitiVe. "Sales" <> "sales"
Good luck
Bruce
Bookmarks