Variable values dependant on values in a cell
Hi all,
I am not the best with Excel but can normally get it to do basic things for me like vat, profit/loss and that kind of thing.
What I am trying to get it to do now is postage cost depending on the weight of the item, so if the item is 100g it adds 1.50 postage, if 200g 1.90 and so on.
Any help would be appreciated.
Marc
Hi and welcome to the forum
I think, that best way to do this, is to create two list in 2 columns with Items & postages and then to use VLOOKUP or INDEX&MATCH functions.
If you can not handle it, then, pls, upload a small sample workbook.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
help.xlsx
I am afraid that went right over my head.
Have attached a workbook.
Any help would be appreciated
Marc
Hi, here is a solution with lookup.
Re: Variable values dependant on values in a cell
That is great, thank you, I owe you a pint or twoOriginally Posted by estige
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks