Forum Discussion
Help me to solve my excel
I need to do letterprice calculator based on pricelist.
On calculator page I have options on dropdownlist: location (Europe or Another coutries) and delivery (Priority or Economy) and empty slot where you can put the weight. Last one is the total price where I need the right formula. If I change location, delivery and weight it should calculate the price, but I cant solve how to do it.
I have this list based on the prices and locations.
Why are there duplicate values in the Maximum Weight (Maksimipaino) column?
There’s a mistake, last ones should be 1000g, 1500g and 2000g. I have fixed it on the list after the ss.
I suspect that the second 100 is incorrect too, and the 2100 as well...
It should probably be something like this:
You can use a combination of INDEX and XMATCH:
See the attached workbook.
