VLOOKUP Help
 

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 You


--
carmelcorn45
------------------------------------------------------------------------
carmelcorn45's Profile: http://www.officehelp.in/member.php?userid=4837
View this thread: http://www.officehelp.in/showthread.php?t=1258820

Posted from - http://www.officehelp.in

VLOOKUP Help
 

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



"carmelcorn45" wrote in message
...

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 You


--
carmelcorn45
------------------------------------------------------------------------
carmelcorn45's Profile: http://www.officehelp.in/member.php?userid=4837
View this thread: http://www.officehelp.in/showthread.php?t=1258820

Posted from - http://www.officehelp.in