Nesting 3 OR statements

[Groovicles]

Hi guys,

I have the following forumula:

=IF(ISNUMBER(FIND("XXX",'CORE Data Quarter'!H2)),OR(ISNUMBER(FIND("YYY",'CORE Data Quarter'!H2)),OR(ISNUMBER(FIND("ZZZ",'CORE Data Quarter'!H2))),'CORE Data Quarter'!A2,""))

What I'm trying to do is that if H2 equals XXX or YYY or ZZZ, then the current cell (current B8) should equal A2. For some reason, I think the formula is only look for XXX and if it does find it its only giving a #VALUE error. I've check the sheet where the results are pulling from and there's defintely a value in A2 which should be the proper result. I had this working with two OR statements, but can't seem to work it with 3.

Thanks guys!!

[AlKey]

You may try this formula

=IF(OR('CORE Data Quarter'!H2={"XXX","YYY","ZZZ"}),A2,"")

[Groovicles]

Hi AlKey,

Thanks for your reply. I tried something similar to that as well, however I need to have the FIND function in the formula as well since XXX YYY and ZZZ are part of a larger text string and I don't believe wildcards work in IF statements. Any other ideas?

Thanks,

[AlKey]

It is the way you described it " if H2 equals XXX or YYY or ZZZ". If it is part for the string than it can't be equal.

Then this


=IF(OR(ISNUMBER(SEARCH("XXX",'CORE Data Quarter'!H2)),ISNUMBER(SEARCH("YYY",'CORE Data Quarter'!H2)),ISNUMBER(SEARCH("ZZZ",'CORE Data Quarter'!H2))),A2,"")

[Groovicles]

AlKey,

That worked, thanks very much! Hmm, your formula is very close the the original one I was using with two OR statements. I really only used FIND instead of SEARCH. Thanks very much for your help!

[Izandol]

You may also use:
=IF(COUNT(SEARCH({"XXX","YYY","ZZZ"},'CORE Data Quarter'!H2)),A2,"")

[AlKey]

You're welcome and thank you for your feedback!