VLOOKUP WITH RANGES
 

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?

VLOOKUP WITH RANGES
 

=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:

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?

VLOOKUP WITH RANGES
 

sorry on ; use comma ,

language mistake, my excle is in Brazilian Portuguese


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



"Marcelo" escreveu:

=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:

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?

VLOOKUP WITH RANGES
 

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?