Forum Discussion
Jenspa
Nov 09, 2024Copper Contributor
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 whe...
HansVogelaar
Nov 09, 2024MVP
Why are there duplicate values in the Maximum Weight (Maksimipaino) column?
Jenspa
Nov 09, 2024Copper Contributor
There’s a mistake, last ones should be 1000g, 1500g and 2000g. I have fixed it on the list after the ss.
- HansVogelaarNov 09, 2024MVP
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.