Value containing - not Value = or Value <>

[cjh1984]

instead of using Value = "whatever" or Value <> "whatever"

is there a way of using Value containing "whateva" and "whateva2"

what do i need inplace of containing???

Any help will greatly be appreciated

Thank

 

[jeff]

Hi,

I'm sure the VIPs have a much better solution than this,
but the formula =IF(ISERROR(MID(A4,MAX(FIND
("cf",A4,1)),2)),"",MID(A4,MAX(FIND("cf",A4,1)),2))

looks for the letters cf in cell A4 - shows cf is there or
blank if not present. Enter as an array formula (with
Ctrl+Shift+Enter) and drag down to copy.

jeff

 

[Peo Sjoblom]

One way assuming you are talking about functions

=IF(AND(ISNUMBER(SEARCH({"whateva";"whateva2"},B1))),"Yes","No")

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom