Hello
I am building a royalty report for merchandise and making up excel as I’m going along 😊. If anyone can help, that would be awesome!
I basically want column O to be filled in with the corresponding postage cost charged to the customer with the information pulled from column D, M & tab 2,3.
Some Example below how field 0 should look
Test 1 = £11.00
Test 2 = £0.00
Test 3 = £6.00
Test 4 = £7.50
Any help would be hugely appreciated! xlsx file attached to give you an idea
Regards
Your data's up the creak.
There's no Europe Flat Rate SweatShirt in your table, it's Sweatshirts
You have "Shirt " not "Shirt" in your lookup table
There's no Free Shipping code but once yuou've fixed some or all of those this works
in D3
=IFERROR(LOOKUP(2,1/(N3='Postage Charged'!B$1:B$150)/(D3='Postage Charged'!C$1:C$150),('Postage Charged'!D$1:D$150)),0)
and copy down
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hi...I am still not clear. How do you determined between UK Flat Rate and UK Tracked, based on column D, M and tab 2,3?
As for other countries that are not UK, can we not use the description on column N, and then just do lookup on tab 3?
row 3 is PEDALS, shipping from US
COUNTRY CODE: US, results in Rate= International 1
Postage Charged sheet HAS NO 'International 1' rate,
it does have:
International 1 Flat Rate
International 1 Tracked
country AU , does not exist, thus error
It took a lot of work, and i might have messed up some of the original prices, but here is your fixed sheet.
BTW, this had little to nothing to do with an if statement.
If this solved you problem, please click add reputation at the bottom left of this comment, and mark this tread solved
(Thread tools, at the top, Mark as solved)
:: BatNoob
' BatNoob
/* BatNoob*/
This is awesome Batnoob, thank you! Just a quick one, what is the shortcut to autofill column O? Ultimatley I have 76 lines of data to input but the lookup and postage match all elements change when I autofill
If I understand what you are asking, paste the following into O3 then drag the fill handle down to O20:Formula:
Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks