Looking at your original post ..
In Sheet1,
Col E = Overall
Put in E2:
=SUM(B2*VLOOKUP(B$1,Sheet2!A:B,2,0),C2*VLOOKUP(C$1 ,Sheet2!A:B,2,0),D2*VLOOKUP(D$1,Sheet2!A:B,2,0))
Copy E2 down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---