I need to find a way to calculate the performance of a student doing a curl
up challenge based upon the number of curl ups they do and the age of the
student.

Because the pass/fail rate changes with age, I think I need to use another
worksheet to reference the standards. For example age 8 needs 18 curl ups
and age 10 needs 20. And Girls is another story.

I want to do a IF statement that will state a pass or fail, but the varying
age of students in a class cause a problem. Can I lookup a table using Age
to reference a age related standard to determine the IF statement that will
show if the student passes or fails.

Any help would be great. I would give more excel related information, but I
am not sure how to do this.
Example Marc D age 8 does 18 curl ups which equals the 8 year old standard
of 18 but David age 10 does 1 curl ups which does not meet the 10 year old
standard of 22.