Thank you. It works perfectly now. I still don't quite understand why the
first version didn't work.
Stuart
"swatsp0p" wrote:
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
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=393921