hello every body
i want your help to be this Equation shot than this one
to take Results from Data Sheet
thanks very much
i want your help to be this Equation shot than this one
Code:
=B3*(VLOOKUP($B$1&B$2,Data!$A$1:$D$12,4,0))+C3*(VLOOKUP($B$1&C$2,Data!$A$1:$D$12,4,0))+D3*(VLOOKUP($B$1&D$2,Data!$A$1:$D$12,4,0))+E3*(VLOOKUP($B$1&E$2,Data!$A$1:$D$12,4,0))+F3*(VLOOKUP($F$1&F$2,Data!$A$1:$D$12,4,0))+G3*(VLOOKUP($F$1&G$2,Data!$A$1:$D$12,4,0))+H3*(VLOOKUP($F$1&H$2,Data!$A$1:$D$12,4,0))+I3*(VLOOKUP($F$1&I$2,Data!$A$1:$D$12,4,0))+J3*(VLOOKUP($J$1&J$2,Data!$A$1:$D$12,4,0))+K3*(VLOOKUP($J$1&K$2,Data!$A$1:$D$12,4,0))+L3*(VLOOKUP($J$1&L$2,Data!$A$1:$D$12,4,0))+M3*(VLOOKUP($J$1&M$2,Data!$A$1:$D$12,4,0))
thanks very much