Performing a multiple column lookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top