Assuming the values are in column F

Enter one of these in G1

=LOOKUP(F1,{0,50,60,80,90},{"E","D","C","B","A"})

Adjust for score ranges or more letter grades like C+, B- etc.

=LOOKUP(F1,{0,31,41,51,61,71,81,91,101},{"E","D"," C-","C","C+","B","B+","A"*})


Gord Dibben MS Excel MVP




On Fri, 25 Jan 2008 11:41:00 -0800, LOTLITA64
wrote:

I would like to create a VLookup chart for a range. For example iin cell F5
is 85% and if you go to the VLOOKUP CHART if the amount is between 80% - 89%
than this is returns to F6 the letter B (for a grade B). Can someone help me
with creating this VLOOKUP chart and tell me how to write the formula as well
as set up the VLOOKUP chart?