One way to do this...

(all in one line)
=IF(MIN(SEARCH({"dll","key","Blind Discount"},A3&{"dll","key","Blind
Discount"}))LEN(A3),"","Blind Discount")

If this post helps click Yes
---------------
Jacob Skaria


"Dinesh" wrote:

I have a following formula to extact text string.

=IF(ISERROR(SEARCH("Blind Discount",A3)),"","Blind Discount")

I want to add one more criteria. If the text string has "DLL" or "KEY" word
in it, then I want result to be null otherwise "Blind Discount".

thanks,
Dinesh