Index Match with multiple lookups?

[Andrew Skibbz]

Dear MrExcel Users...

Please see attached spreadsheet link:

https://www.dropbox.com/s/jmuov911ggkwrw9/DeliveryCosts_Example.xlsx?dl=0

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}</style>The formula I'm looking for help with is as described in Column H6 of the 'Output' tab and as follows:

If the weight in Column F (Output) falls between Columns G&H (Pricing Lookup tables) and the text in Column G (Output) matches the text in Column A (Pricing Lookup tables), then bring back the £Cost in Column I (Pricing Lookup tables) in Column H (Output).
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Calibri; color: #dd0806}</style>

Any help much appreciated.

Thanks Again,

Andrew

 

[Fluff]

Your data is not consistent.
For row 7 on Output should it pull the price from row 6 or 13 on the lookup sheet?