Mac Forum / Applications / Excel / September 2007

How to I create a lookup table (in the worksheet) and use the =lookup
function for a letter grade based on the quiz average with these rules.  I
have one sheet with a list of names and 3 test scores and a blank cell for
the average according to the rules below:

An average below 60, the grade is a F.  
An average of 60 or more but below 65, the grade is a D.  
An average of 65 or more but below 70, the grade is a D+
An average of 70 or more but below 75, the grade is a C.

I have a 2nd sheet that has the score and grade in column A and B,  score
(i.e. 70); grade (i.e. D), how do I create a lookup list for all the
conditions above and then how do I go back to sheet one where the actual data
is and place the lookup formula in the cell to automatically calculated the
"letter" grades in the blank column based on the average.  

Help!