Excel Forum

Lookup

cgray

Member

Members

Forum Posts: 16

Member Since:
August 14, 2019

Offline

May 4, 2021 - 12:18 pm

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!

Mynda Treacy

Admin

Forum Posts: 4446

Member Since:
July 16, 2010

Offline

May 5, 2021 - 9:41 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

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online:

Guest(s) 11

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 870

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

A.Maurizio: 202

Jessica Stewart: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

John Chisholm

vexokeb sdfg

John Jack

Malcolm Toy

Ray-Yu Yang

George Shihadeh

Naomi Rumble

Uwe von Gostomski

Jonathan Jones

drsven

Forum Stats:

Groups: 3

Forums: 24

Topics: 6212

Posts: 27236

Member Stats:

Guest Posters: 49

Members: 31888

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen