IF with OR Function using wildcard characters

[danb2000]

Hello

I can find thread explaining how to use wildcard characters with IF using COUNTIF but I am trying to find something that will search multiple columns to say "Y" or "N" if it is contained in either cell.

=IF((OR(A1="dealing", AB1="dealing")), "Y", "N")

The above formula would do this if I specified the whole word or the cell only contain the word "dealing" but I need it to do the same but with wildcard characters and I know they don't work with straight IF functions.

So.... I want it to say "Y" if the word 'dealing' anywhere in either cell and "N" if it does not.

Hope this is clear. Any ideas? Thanks in advance.

 

[Rick Rothstein]

This formula should do what you want...

=IF(ISNUMBER(SEARCH("dealing",A1&" "&AB1)),"Y","N")

 

[bbott]

Rick has a good, succinct formula that should work for you.

Here's an option that uses the COUNTIF function and wild cards...just so you can see how it works:

=IF(OR(COUNTIF(A1,"*dealing*"),COUNTIF( AB1,"*dealing*")), "Y", "N")

 

[danb2000]

Amazing.

Thanks so much Rick.

.... and thank you bbott. The more knowledge, the merrier!