Using OR AND IF to solve equation

[richardthelionheart]

'=IF(AH1=AL1,OR,AH1=AM1,OR,AH1=AN1,"YES", " ")

So I'm trying to find a YES if any nunbers in AL1 or AM1 or AN1 match the number in cell AH1. The numbers found in AL1,AM1 and AN1 will always be different. I've researched "OR" but have found only examples that do not include "find any that match". Would really appreciate some help here. I'm happy to get a "TRUE" result instead of "YES" - that's of no consequence.

 

[Trebor76]

Here's two ways (I'm sure there's more ):

=IF(OR(AH1=AL1,AH1=AM1,AH1=AN1),"YES","")
=IF(COUNTIF(AL1:AN1,AH1)>=1,"YES","")

Regards,

Robert

 

[alansidman]

=if(or(AH1=AL1,AH1=AM1,AH1=AN1),"Yes","")

 

[Trebor76]

Just one more:

=IF(ISERROR(LOOKUP(AH1,AL1:AN1)),"","YES")

This and my COUNTIF suggestion are better for large ranges as you are limited to the number of OR arguments (30 I think) and as they get larger they are more cumbersome to maintain (in my humble opinion).

 

[Dave Patton]

Excel 2010
	C	D
1	TRUE
2	Yes
3
2b

Cell Formulas
Range	Formula
C1	=OR(AH1=AL1,AH1=AM1,AH1=AN1)
C2	=IF(OR(AH1=AL1,AH1=AM1,AH1=AN1),"Yes","No")

 

[richardthelionheart]

Thank you to the contributors. A simple solution in the long run which I will use from now on.