As a teacher, I would like to design a formula that will lookup data from
three separate column and return a grade as a result of the lookup.
If student "A" is a "female" and is in the "10th grade" and scored a "75"
on a test, what letter grade would that student recieve based on the results
of each of these columns??

Hi!

Isn't the only criteria that matters the score?

Is there a difference between:

student "A", female, 10th grade, score 75
student "G", male, 12th grade, score 75

Biff

"JDay" wrote in message
...
As a teacher, I would like to design a formula that will lookup data from
three separate column and return a grade as a result of the lookup.
If student "A" is a "female" and is in the "10th grade" and scored a "75"
on a test, what letter grade would that student recieve based on the
results
of each of these columns??