VLOOKUP Help

[carmelcorn45]

Hi
I need a VLOOK up to put in grades in the range C6:G11. In E7:E11 is
49
69
79
89
100
In F7:F11 is
F
D
C
B
A
The scores are in B6:B55
80
67
74 ect.
The scores should be
F 0-49
D 50-69
C 70-79
B 80-89
A 90-100
Thank Yo

 

[CLR]

Change your values in E7:E11 to be
0
50
70
80
90
Then put this in B6 and copy down...........
=VLOOKUP(B6,E7:F11,2,TRUE)

Vaya con Dios,
Chuck, CABGx3