Hello,

Is there a different way of expressing the following formula?

=VLOOKUP(B6,Pipes,4)*E6 + VLOOKUP(B7,Pipes,4)*E7 + VLOOKUP(B8,Pipes,4)*E8

I would like to be able to express B6, B7 and B8 as a range (or named range) and the same for E6, E7 and E8


Thank you very much.

Kind regards