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
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