Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
83
Views
Topic starter
Hello,
Amazon is changing their fulfillment charges beginning June 1st and I'm trying to create a lookup table that will pull the charges and Amazon size based upon the dimensions and weight of the items we sell.
Can anyone help me create this lookup?
Thanks!
Posted : 04/05/2021 10:18 pm
Hi,
Please see the attached file which contains INDEX & MATCH formulas that lookup the various criteria individually and then find the maximum cost, which I presume is how it works. You could consolidate these formulas into one cell, but I've left them separate so you can follow the logic.
You'll need to factor in the order handling fees and cost for every lb over 3lbs, but that should be fairly straight forward.
Hope that points you in the right direction.
Mynda
Posted : 06/05/2021 7:41 am
