Reference 2 ranges in an If statement

[JustHooch]

I know how to reference 1 range of cells in an if statement. I had the below and it worked well.

=IF(ISNA(MATCH("Yes",'Ticket Offer Info'!B21:B24,0)),"No","Yes")

But I have having trouble figuring out how to add another range as an "OR" to the formula. I need to also reference any yes in range " 'Ticket Offer Info'!B26:B31 ". Basically if there is a "Yes" in either of the 2 ranges then return a "Yes" if not then "No"

I had the below but I know it is not quite right.
=IF(OR(ISNA(MATCH("Yes",'Ticket Offer Info'!B21:B24,0)),ISNA(MATCH("Yes",'Ticket Offer Info'!B26:B31,0))),"No","Yes")

Any ideas

 

[jproffer]

=IF(OR(ISNA(MATCH("Yes",'Ticket Offer Info'!B21:B24,0)),ISNA(MATCH("Yes",'Ticket Offer Info'!B26:B31,0))),"No","Yes")

I think that might do it. I didn't set up a workbook to test it, but it looks right. See what happens.

EDIT: That's exactly what you said wasn't quite right....did you try it, or do you just "think" it's not quite right, just like I "think" it is right?

 

[Marcelo Branco]

Try

=IF(OR(ISNUMBER(MATCH("Yes",'Ticket Offer Info'!B21:B24,0)),ISNUMBER(MATCH("Yes",'Ticket Offer Info'!B26:B31,0))),"Yes","No")

M.

 

[JustHooch]

I did try my OR formula it works for the second range but not the first.

 

[JustHooch]

The below worked. Thank you. Never thought to try ISNUMBER

=IF(OR(ISNUMBER(MATCH("Yes",'Ticket Offer Info'!B21:B24,0)),ISNUMBER(MATCH("Yes",'Ticket Offer Info'!B26:B31,0))),"Yes","No")

 

[jproffer]

......

 

[Marcelo Branco]

The below worked. Thank you. Never thought to try ISNUMBER

=IF(OR(ISNUMBER(MATCH("Yes",'Ticket Offer Info'!B21:B24,0)),ISNUMBER(MATCH("Yes",'Ticket Offer Info'!B26:B31,0))),"Yes","No")

You are welcome. Thanks for the feedback.

M.