Need help in my excel spreadsheet.
I am doing a postage calculator to calculate postal rates for posting.
However, I am facing some problems
In the Main Sheet, Postal rates, I need to do something
1) We are divided into Zones - 1 to 4
Can I do a Variable that if I type Zone 1 and it will Vlookup on Zone 1 sheet and if I type Zone 4, it will Vlookup on Zone 4 sheet
2nd problem is that:
The postage needed: When I did a Vlookup, when I key in 55, it will select the wrong price table, if you take a look at the attached spreadsheet, 55g for Zone 4 it came out $2.05 but it should be the following rate which is $2.40.