Forum Discussion

Copper Contributor

Dec 09, 2019

Solved

Help with Complex Lookup using Lenght x Width x Height and Weight to Find Costs.

Help Excel Wizards! I am trying to find a formula that can pull fulfillment costs/fees from two tables for a product based on dimensions in inches (LxWxH) and weight. One table is fees for Hazmat...

FulfillmentFeeCalculator.xlsx31 KB

excel

Formulas and Functions

JKPieterse
Dec 09, 2019
Brian175 See attached, cells L3:Q3. I assumed each column is looked up independently and that subsequently the highest row is needed to take the price from.
Copy of FulfillmentFeeCalculator.xlsx33 KB

JKPieterse

Silver Contributor

Dec 09, 2019

Brian175 See attached, cells L3:Q3. I assumed each column is looked up independently and that subsequently the highest row is needed to take the price from.

Copy of FulfillmentFeeCalculator.xlsx33 KB

Brian175
Copper Contributor
Dec 11, 2019
JKPieterse Figured it out with your help. Thank you!

For anyone who sells online particularly amazon, this spreadsheet helps calculate your fulfillment fees for private label products.
FulfillmentFeeCalculator.xlsx42 KB
Brian175
Copper Contributor
Dec 09, 2019
JKPieterse This helps a ton! I'm going to play around with your method and see what I can come up with. That method seems like it will work but the way my table is set up is causing some issues. I will get back to you if I figure it out. Thank you!