Andrew Skibbz
New Member
- Joined
- Mar 29, 2017
- Messages
- 28
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
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