Postage Calculator using Vlookup on a Table Array

Hi guys,

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.

Please assist.

Re: Postage Calculator using Vlookup on a Table Array

Seems like I have not attached the sheet

Re: Postage Calculator using Vlookup on a Table Array

Yes perfect except that I need your help again. Thought I could edit the code myself but Indirect seems to complex for me to comprehend.

Could the Zone 4 be changed to just Number .... Like a 4

And also .. Instead of just 2 zones I have a new excel spreadsheet with 4 zones.

Thank you once again for the help

Here is the new attachment

http://www.flashgamecafe.com/Singpost%20Postal%20Rates.xls