maybe im misunderstanding what your saying, but reentering the student
numbers is going to require more work than i want if at all avoidable. Also i
need the information to be able to be absolute so if the data changes in teh
look up sheet it can be adjusted across all 5 sheets by just adjusting the
list data.

"D." wrote:

On Apr 28, 6:14 pm, Eelinla wrote:
Hi, I need to generate a formula that will look at the data on sheet
one..reference a list on sheet 2 ..do some arithmatic then add the total of 3
cells together placing that total in its own cell.

sheet 1

Student ID Exam 1 Exam 2 Final Overall Grade
318-84-6039 100 93 79 87.40 B
332-03-6854 99 90 74 F
341-38-6902 63 51 43 F
362-80-6830 65 91 81 F
351-25-6606 74 65 58 F
303-86-6698 74 63 63 F
360-99-6115 63 50 43 F
342-45-6149 84 72 65 F
360-49-6615 78 65 58 F
331-38-6683 88 78 77 F
337-55-6535 72 64 62 F
300-60-6949 100 89 85 F
373-46-6412 99 88 84 F
397-44-6180 98 84 84 F
398-56-6736 100 92 86 F

sheet 2

Exam Type Weight
Exam 1 25%
Exam 2 25%
Final 50%

using these charts, i need to generate the data that would populate under
the overall column. What i need to do is reference the type, multiply the
value in the cell that corresponds to it by the appropriate weight which is
found on sheet 2 in the list. add the 3 cells together after multiplying them
by their weights and put that total in the column under overall.

ex 100*20%+93*30%+79*50% 87.40 would go under overall.

anyhelp on this would be appreciated
~Eelinla

Hi there,
Place this formula inB1 sheet 2 and type in the student # in A1

See if it works for you

=(VLOOKUP(A1,Sheet1!$A$2:$F$16,2,0)*0.2)+(VLOOKUP( A1,Sheet1!$A$2:$F
$16,3,0)*0.3)+(VLOOKUP(A1,Sheet1!$A$2:$F$16,4,0)*0 .5)