View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JDay
 
Posts: n/a
Default Performing a multiple column lookup

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??