text string

  • Thread starter Thread starter Dinesh
  • Start date Start date
D

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
 
Do you mean


=IF(OR(NOT(ISERROR(SEARCH("DLL",A3))),NOT(ISERROR(SEARCH("KEY",A3)))),"",IF(ISERROR(SEARCH("Blind
Discount",A3)),"","Blind Discount"))
 
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
 
Back
Top