text string

[Dinesh]

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

 

[Bob Phillips]

Do you mean


=IF(OR(NOT(ISERROR(SEARCH("DLL",A3))),NOT(ISERROR(SEARCH("KEY",A3)))),"",IF(ISERROR(SEARCH("Blind
Discount",A3)),"","Blind Discount"))

 

[Jacob Skaria]

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