Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |