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

Written by PromoMagic on 23 February 2016. Posted in Code and Formulas

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.