# =IF(AND(ISNUMBER(SEARCH not getting the desired result

1. ## =IF(AND(ISNUMBER(SEARCH not getting the desired result

Hi,

both cells C7 and C8 contain the correct "Y" yet I'm still getting "N" as a result. Any ideas why this is?

You're help is most appreciated.

=IF(AND(ISNUMBER(SEARCH("Y",C7,)))*ISNUMBER(SEARCH("Y",C8)),"Y","N")  Register To Reply

2. ## Re: =IF(AND(ISNUMBER(SEARCH not getting the desired result

=IF(AND(ISNUMBER(SEARCH("Y",C7,))*ISNUMBER(SEARCH("Y",C8))),"Y","N")

but also you can remove AND
=IF(ISNUMBER(SEARCH("Y",C7,))*ISNUMBER(SEARCH("Y",C8)),"Y","N")  Register To Reply

3. ## Re: =IF(AND(ISNUMBER(SEARCH not getting the desired result

Another way..

=LOOKUP(ISNUMBER(SEARCH("Y",C7))*ISNUMBER(SEARCH("Y",C8)),{0,1},{"N","Y"})
or shorter
=IF(ISNUMBER(SEARCH("Y",C7))*ISNUMBER(SEARCH("Y",C8))=1,"Y","N")  Register To Reply

4. ## Re: =IF(AND(ISNUMBER(SEARCH not getting the desired result

Fantastic,

=IF(ISNUMBER(SEARCH("Y",C7))*ISNUMBER(SEARCH("Y",C8))=1,"Y","N") Did the trick.

Ace / Zbor thank you very much for your time and help.

Zackie  Register To Reply