Check A,B,C,D,E,F to see if the values 1401,1402,1403,1404,1409,1410,1426,1427,2422,2423

[taylorpeugh]

Good Afternoon,

I'm trying to check A,B,C,D,E,F to see if the values 1401,1402,1403,1404,1409,1410,1426,1427,2422,2423

I think something like =IF(A2:F2=OR(1401,1402,1403,1404,1409,1410,1419,1426,1427,2422,2423),"YES","NO") should work

I also did something with alot more work here (linked below) What would be a clean way to do this so if I wanted to make changes in the future. Thanks for the help.

=IF(OR(
INPUT!$X$5:$X$2995=1401,INPUT!$X$5:$X$2995=1402,INPUT!$X$5:$X$2995=1403,INPUT!$X$5:$X$2995=1404,INPUT!$X$5:$X$2995=1409,INPUT!$X$5:$X$2995=1410,INPUT!$X$5:$X$2995=1426,INPUT!$X$5:$X$2995=1427,INPUT!$X$5:$X$2995=2422,INPUT!$X$5:$X$2995=2423,

INPUT!$Y$5:$Y$2995=1401,INPUT!$Y$5:$Y$2995=1402,INPUT!$Y$5:$Y$2995=1403,INPUT!$Y$5:$Y$2995=1404,INPUT!$Y$5:$Y$2995=1409,INPUT!$Y$5:$Y$2995=1410,INPUT!$Y$5:$Y$2995=1426,INPUT!$Y$5:$Y$2995=1427,INPUT!$Y$5:$Y$2995=2422,INPUT!$Y$5:$Y$2995=2423,

INPUT!$Z$5:$Z$2995=1401,INPUT!$Z$5:$Z$2995=1402,INPUT!$Z$5:$Z$2995=1403,INPUT!$Z$5:$Z$2995=1404,INPUT!$Z$5:$Z$2995=1409,INPUT!$Z$5:$Z$2995=1410,INPUT!$Z$5:$Z$2995=1426, INPUT!$Z$5:$Z$2995=1427,INPUT!$Z$5:$Z$2995=2422,INPUT!$Z$5:$Z$2995=2423,

INPUT!$AA$5:$AA$2995=1401,INPUT!$AA$5:$AA$2995=1402,INPUT!$AA$5:$AA$2995=1403,INPUT!$AA$5:$AA$2995=1404,INPUT!$AA$5:$AA$2995=1409,INPUT!$AA$5:$AA$2995=1410,INPUT!$AA$5:$AA$2995=1426,INPUT!$AA$5:$AA$2995=1427,INPUT!$AA$5:$AA$2995=2422,INPUT!$AA$5:$AA$2995=2423,

INPUT!$AB$5:$AB$2995=1401,INPUT!$AB$5:$AB$2995=1402,INPUT!$AB$5:$AB$2995=1403,INPUT!$AB$5:$AB$2995=1404,INPUT!$AB$5:$AB$2995=1409,INPUT!$AB$5:$AB$2995=1410,INPUT!$AB$5:$AB$2995=1426,INPUT!$AB$5:$AB$2995=1427,INPUT!$AB$5:$AB$2995=2422,INPUT!$AB$5:$AB$2995=2423,

INPUT!$AC$5:$AC$2995=1401,INPUT!$AC$5:$AC$2995=1402,INPUT!$AC$5:$AC$2995=1403,INPUT!$AC$5:$AC$2995=1404,INPUT!$AC$5:$AC$2995=1409,INPUT!$AC$5:$AC$2995=1410,INPUT!$AC$5:$AC$2995=1426,INPUT!$AC$5:$AC$2995=1427,INPUT!$AC$5:$AC$2995=2422,INPUT!$AC$5:$AC$2995=2423),"YES","NO")

What would be a clean way to do this so if i wanted to make changes in the future I could. Thanks for the help.

[Pauleyb]

I think you were close:
=IF(OR(A2:F2={1401;1402;1403;1404;1409;1410;1419;1426;1427;2422;2423}),"YES","NO")
Be sure to enter it with control-shift-enter

[Pauleyb]

Oh, and as for making it easier, that manual array can be typed into a column, and then you could call out that range to compare. So, if those numbers were in S2:S12, then:
=IF(OR(A2:F2=S2:S12),"YES","NO")
Similarly, you could create a named range and use that for quick updates.

[Pauleyb]

Oh, and as for making it easier, that manual array can be typed into a column, and then you could call out that range to compare. So, if those numbers were in S2:S12, then:
=IF(OR(A2:F2=S2:S12),"YES","NO")
Similarly, you could create a named range and use that for quick updates.

[taylorpeugh]

Worked, Thanks.

[FDibbins]

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.