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

 

[mole999]

No need to post twice, this thread now locked

https://www.mrexcel.com/forum/excel-questions/1104788-index-match-multiple-lookups.html