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
>
>