# 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.

• 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

see if the attached file helps

## Files

• 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

• Re: Postage Calculator using Vlookup on a Table Array

=INDEX(INDIRECT([COLOR="Lime"]"'Zone "[/COLOR]&A6&"'"&"!"&"B"&3&":"&"B"&34),MATCH(B6,INDIRECT([COLOR="lime"]"'Zone "[/COLOR]&A6&"'"&"!"&"A"&3&":"&"A"&34),1)+1)

The change above (to the formula in the yellow box of pangolin's attachment) should allow you to simply use a number for your Zone. Didn't look at the new attachment though.

Hope this helps,

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!