I'm trying to make a sheet which calculates my profits on the work I offer for sale on Etsy but I'm stuck on working out the postage. I want to be able to choose which postage service I want to use and the packaging size, and have Excel tell me how much it will cost. I have a table of different postage costs and services on a separate sheet, and drop down menus with postage service and size on my main sheet. Can anyone help please?
Attach your file. We need to see the table of postage costs and services. See yellow banner at the top of the page.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Sorry, I missed that... It's very basic atm, I figured I'd start with the hardest bit lol! The idea is to select shipping destination, then shipping type, and have the price appear in the actual shipping costs cell.
You have not done this bit:
... and some manually calculated results.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I want to be able to select eg EU on the destination, small parcel 2nd class 2kg tracked on the shipping type and have the £15.25 that is in the c10 cell on the postage sheet populate the actual shipping costs cell on the costs sheet.
Add a few examples to the currently EMPTY table and then post the workbook again, please.
Try
=IF(ISNUMBER(SEARCH("tracked",$G2)),INDEX(Postage!$B$3:$E$16,MATCH($G2,Postage!$A$3:$A$16,0),MATCH($F2,Postage!$B$1:$E$1,0)),INDEX(Postage!$H$3:$K$16,MATCH($G2,Postage!$G$3:$G$16,0),MATCH($F2,Postage!$H$1:$K$1,0)))
Last edited by JohnTopley; 04-10-2021 at 12:07 PM.
I've added some information in the cells, but what I want to do is to be able to populate cell H1, H2 etc with the data in the postage sheet that corresponds with the shipping destination and the shipping type I select from the drop down list in the Costs sheet.
That works prefectly, thank you so much!!Originally Posted by JohnTopley
See #7
Added Data Validation for all shipping types
You're welcome.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
I added it in the wrong post.. d'oh! It's a long time since I used forums!!! I'll mark this thread as solved now. Once again, thank you. I'm now off to deconstruct how the formula works so I can use it elsewhere too lol
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks