zip code to certain sale tax rate

[fidifl]

I'm very new to this forum and to Excel also. Forgive me and move this thread to proper location if it is misplaced.
My goal is prepare the invoice to be determining tax rate in cell B35 on basis of zip code which is in cell A13 ;3rd line of address with zip code (City, ST 00000)
Example:
If A13 (City, ST 00000) contain number from column G (list of zip codes for County XXX (28 zip codes G1-G28)) tax rate in cell B35 is 6.5%.
AND
If A13 (City, ST 00000) contain number from column H (list of zip codes for County YYY (29 zip codes H1-H29)) tax rate in cell B35 is 7%

I'll be thankful for any answer or help.

 

[p45cal]

I'm not from the states so know little of zip codes.
Does a zip code contain county information (the first 2 characters?)
Is the tax rate county based, therefore all zip codes in a county have the same tax rate?
Just trying to simplify by only looking for the county aspect of the zip code, if such exists.

 

[gnrboyd]

I'm from the Midwest (US) and our tax rates are not the same for every city in a given county. Perhaps your state is different. Anyway, rather than having a different table for each county, I would just put all of your tax rate data into one table and use the vlookup formula.

From your post, it seems that the zip code is in the same cell as the city and state. I used the RIGHT formula to extract just the zip code to look it up in the tax table. (I assume your data does not also include the zip plus four format. .. i.e. #####-####.) If it does, then my approach would need to be modified.

Obviously, you will need to modify your tax table range within the formula. If you get a zip code not in the table, it will return an #N/A. If that happens, simply just look up the rate for that zip code and add it to the table. In the Midwest, our tax rates can change quarterly so updating the table might be a pain. Perhaps your state's web site has a downloadable table that you can copy/paste into your invoice program when the rates change.

Hope this helps...

Book1
	A	B	C	D	E	F	G
7	Invoice				TaxTable
8					11111	CountyA	6.5%
9					11112	CountyA	6.5%
10					11113	CountyA	6.5%
11	JohnDoe				11114	CountyA	6.5%
12	1234ElmStreet				11115	CountyA	6.5%
13	City,ST11118				11116	CountyA	6.5%
14					11117	CountyB	7.0%
15	TaxRate	7.0%			11118	CountyB	7.0%
16					11119	CountyB	7.0%
17					11120	CountyB	7.0%
18					11121	CountyB	7.0%
Sheet1