• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help abbreviate this equation

Hany ali

Active Member
hello every body
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))
to take Results from Data Sheet
thanks very much
 

Attachments

  • Transport.xlsm
    18 KB · Views: 8
In O3, array formula (Ctrl+Shift+Enter) copied down :

=SUM(IFERROR(VLOOKUP(T(IF(1,IF(B3:M3>0,LOOKUP(COLUMN(B$1:M$1),COLUMN(B$1:M$1)/(B$1:M$1>0),B$1:M$1)&B$2:M$2,0))),Data!$A$1:$D$12,4,0)*B3:M3,0))

66007

Regards
Bosco
 
Back
Top