=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")

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")

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")

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1