VLOOKUP, correct funtion?

[dee student]

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.

[Bob Phillips]

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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[dee student]

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.

[Bob Phillips]

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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>