Complex Multi Tier Lookup in PQ to return Fee

daleholden

Board Regular
Joined
Sep 22, 2002
Messages
243
HI Guys

I have an experimental sheet with a shared link HERE.

My quest is i have a file from eBay with my listings also I have a file from my supplier. I have merged two tables so I have my selling price on eBay & my supplier'ss price.

I am trying to build a sheet that works out all the fees and profit vis PQ.

The very first headache is trying to work out eBay FVF (Final Value Fee) which is a percentage but they vary depending on what category it is.
I have a table colour coded with % values but the Categories are multi-level.

I have the Cats listed from the eBay download but i wanted to add a column% in PQ to work out the FVF by doing a lookup and grabbing the correct % based on the eBay Sale price.

Is it possible to do this?
I have been trying to do this for the past 3 days but struggling.

Any help would be welcomed
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,223,892
Messages
6,175,236
Members
452,621
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top