Check this badboy out

=(ALLOCATE!G302*VLOOKUP(ALLOCATE!H302,in!$BE$12:$B H$442,3))+(ALLOCATE!I302*VLOOKUP(ALLOCATE!J302,in! $BE$12:$BH$442,3))+(ALLOCATE!K302*VLOOKUP(ALLOCATE !L302,in!$BE$12:$BH$442,3))+(ALLOCATE!M302*VLOOKUP (ALLOCATE!N302,in!$BE$12:$BH$442,3))+(ALLOCATE!O30 2*VLOOKUP(ALLOCATE!P302,in!$BE$12:$BH$442,3))+(ALL OCATE!Q302*VLOOKUP(ALLOCATE!R302,in!$BE$12:$BH$442 ,3))

Tracing problems is, errrr, interesting