Excel Formula to Calculate Delivery Costs From Total Weights Using INDEX & MATCH

This formula helps to calculate delivery costs when all you have is weights and a cost array to work with. You can't use VLOOKUP in this case as it won't find the correct value. This formula uses INDEX and MATCH together.

=INDEX($A$2:$B$22,MATCH(C2,$A$2:$A$22,-1),2)

I can't take the credit for this one as Dan Baker over at Pen Warehouse gave me a hand

Click Here for a demo sheet that contains the arrays and formulas so you can see how to apply this to one of your spreadhseets.


Copyright © 2020 PromoMagic Ltd | +44 (0)1795859639 | This email address is being protected from spambots. You need JavaScript enabled to view it.

Registered in England and Wales Company Number: 11970723 -