I have a Statement that Shawn Devonshire helped me setup.

Suppose you set up a table like this starting in cell A1

A B C
Age Male Female
8 18 12
10 20 14
12 22 16
14 24 18
16 26 20

In this example I will keep the table on the same sheet as the student scores.

Suppose the students are listed like this starting in cell E1:

E F G H I
Gender Age Left Curls Right Curls Pass/Fail
Female 10 18 18 Pass
Male 12 17 17 Fail


Shawn assisted me in determining that the formula in cell I2 for Pass/Fail
Left curls is. This is the one I am using for a single arm curl match.

=IF(G2=VLOOKUP(F2,$A$2:$C$6,MATCH(E2,$A$1:$C$1,0) ,TRUE),"Pass","Fail")

I need help taking this statement to determine if I can use a "and" or "or"
statement to do a Pass/Fail test on both left and right arm curls. I am not
sure which statement will work best. Only if both left and right arm curls
meet the standard in A1 table will a pass be given otherwise a fail will be
given for the test, if either arm fails to meet the standard.

Thanks
Ken Quick