Hello all!
I have a project with a client and I would like a slick solution instead of what I usually come up with, which is bulky and slow.
I am calculating a shipping price, where i have the zone and weight of the container. This held together with destination country should give me the final price.
Every destination country has a zone in a zone map, And i have made a VLOOKUP to a cell where i have the zone number. So I always have the zone number when they choose a destination country in the drop down menu I have created.
My problem is now that i need to search a matrix on both the zone and the weight (which is also inputted).
For the sake of the example my Zone number is in cell A1 and weight is input in A2. The matrix for the price is on Sheet2.
How do i do that?
I have a project with a client and I would like a slick solution instead of what I usually come up with, which is bulky and slow.
I am calculating a shipping price, where i have the zone and weight of the container. This held together with destination country should give me the final price.
Every destination country has a zone in a zone map, And i have made a VLOOKUP to a cell where i have the zone number. So I always have the zone number when they choose a destination country in the drop down menu I have created.
My problem is now that i need to search a matrix on both the zone and the weight (which is also inputted).
For the sake of the example my Zone number is in cell A1 and weight is input in A2. The matrix for the price is on Sheet2.
How do i do that?