Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP, correct funtion?
I'm suppose to use the VLookup to do the following: but can't figure out the correct way to put it in the dialog box. This is a student grading chart. B2 & C2 are exam grades (worth 25% of grade) D2 is the final grade (worth 50%) I need a function to get the overall score. =(B2*0.25)+(C2*0.25)+(D2*0.5) this works, but its not the way our instructor wants us to do it. Any suggestions would be greatly appreciated........ Thanks in advance. -- dee student ------------------------------------------------------------------------ dee student's Profile: http://www.excelforum.com/member.php...o&userid=34806 View this thread: http://www.excelforum.com/showthread...hreadid=548140 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP, correct funtion?
With the information that you have given, there is nothing to lookup. What
is wrong with your method, or what other data do you have? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "dee student" wrote in message ... I'm suppose to use the VLookup to do the following: but can't figure out the correct way to put it in the dialog box. This is a student grading chart. B2 & C2 are exam grades (worth 25% of grade) D2 is the final grade (worth 50%) I need a function to get the overall score. =(B2*0.25)+(C2*0.25)+(D2*0.5) this works, but its not the way our instructor wants us to do it. Any suggestions would be greatly appreciated........ Thanks in advance. -- dee student ------------------------------------------------------------------------ dee student's Profile: http://www.excelforum.com/member.php...o&userid=34806 View this thread: http://www.excelforum.com/showthread...hreadid=548140 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP, correct funtion?
Oops, my mistake....there is a table on the grading criteria page. Cells: A9 to B12 Exam Type Weight Exam 1 25% Exam 2 25% Final 50% But I'm still confused about what goes where when using VLOOKUP btw..thanks for your quick response. I hope this additional info helps. -- dee student ------------------------------------------------------------------------ dee student's Profile: http://www.excelforum.com/member.php...o&userid=34806 View this thread: http://www.excelforum.com/showthread...hreadid=548140 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP, correct funtion?
Assuming that B1 says Exam 1 (i.e the value to lookup), C1 says Exam 2, and
D1 probably says Exam 3 (although the last defaults), you can use =(B2*VLOOKUP(B1,'Grading Criteria'!A9:B12,2,FALSE))+ (C2*VLOOKUP(C1,'Grading Criteria'!A9:B12,2,FALSE))+ (D2*(1-VLOOKUP(B1,'Grading Criteria'!A9:B12,2,FALSE)-VLOOKUP(C1,'Grading Criteria'!A9:B12,2,FALSE))) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "dee student" wrote in message ... Oops, my mistake....there is a table on the grading criteria page. Cells: A9 to B12 Exam Type Weight Exam 1 25% Exam 2 25% Final 50% But I'm still confused about what goes where when using VLOOKUP btw..thanks for your quick response. I hope this additional info helps. -- dee student ------------------------------------------------------------------------ dee student's Profile: http://www.excelforum.com/member.php...o&userid=34806 View this thread: http://www.excelforum.com/showthread...hreadid=548140 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup Function Arguments are correct but nothing in cell | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
Running auto correct on startup? | Excel Discussion (Misc queries) | |||
vlookup problem, possibly due to "noise" | Excel Worksheet Functions | |||
Array Function with VLOOKUP | Excel Worksheet Functions |