text string
 

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

text string
 

Do you mean


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




--
__________________________________
HTH

Bob

"Dinesh" wrote in message
...
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

text string
 

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