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
Bookmarks