VLOOKUP WITH RANGES

[LOTLITA64]

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?

 

[excelgrrl]

Try this formula:
[=IF(C9="","",LOOKUP(C9,$M$25:$Y$26))]

This would assume your grade chart is in the range of M25:Y26.

PLace the number grade in the top row and the letter grade in the bottom row. For example letter grade B is 80%-89%, so in the top row you would have 80 and the next row you would have B.

Let me know if you need more info.

 

[Marcelo]

=LOOKUP(H6;{0;0,1;0,2;0,3;0,4;0,05;0,6;0,7;0,8;0,9;1};{"A";"B";"C";"D";"E";"F";"G";"H";"I";"J";"K"})

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"LOTLITA64" escreveu:

 

[Marcelo]

sorry on ; use comma ,

language mistake, my excle is in Brazilian Portuguese


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Marcelo" escreveu:

 

[Gord Dibben]

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