Spreadsheet: 551925d1513222662-vlookup-isnt-helping-me-with-zip-codes-microsoft-excel-2013-workbook-shell-part-a
Sheet: Tax Chart

State and Local Sales Tax Rates as of January 1, 2015 |  |  | http://taxfoundation.org/article/state-and-local-sales-tax-rates-2015
State | State Tax Rate | Rank | Avg. Local Tax Rate (a) | Combined Tax Rate | Rank | Maximum Local Rate
Alabama | 0.04 | 38 | 0.0491 | 0.0891 | 3 | 0.07
Alaska | 0 | 46 | 0.0176 | 0.0176 | 46 | 0.075
Arizona | 0.056 | 28 | 0.0257 | 0.0817 | 11 | 0.053
Arkansas | 0.065 | 9 | 0.0276 | 0.0926 | 2 | 0.055
California (b) | 0.075 | 1 | 0.0094 | 0.0844 | 8 | 0.025
Colorado | 0.029 | 45 | 0.0454 | 0.0744 | 15 | 0.071
Connecticut | 0.0635 | 11 | 0 | 0.0635 | 31
Delaware | 0 | 46 | 0 | 0 | 47
Florida | 0.06 | 16 | 0.0065 | 0.0665 | 29 | 0.015
Georgia | 0.04 | 38 | 0.0296 | 0.0696 | 24 | 0.04
Hawaii (c) | 0.04 | 38 | 0.0035 | 0.0435 | 45 | 0.005
Idaho | 0.06 | 16 | 0.0001 | 0.0601 | 36 | 0.03
Illinois | 0.0625 | 12 | 0.0194 | 0.0819 | 10 | 0.0375
Indiana | 0.07 | 2 | 0 | 0.07 | 21
Iowa | 0.06 | 16 | 0.0078 | 0.0678 | 27 | 0.01
Kansas | 0.0615 | 15 | 0.0205 | 0.082 | 9 | 0.035
Kentucky | 0.06 | 16 | 0 | 0.06 | 37
Louisiana | 0.04 | 38 | 0.0491 | 0.0891 | 4 | 0.07
Maine | 0.055 | 29 | 0 | 0.055 | 42
Maryland | 0.06 | 16 | 0 | 0.06 | 37
Massachusetts | 0.0625 | 12 | 0 | 0.0625 | 33
Michigan | 0.06 | 16 | 0 | 0.06 | 37
Minnesota | 0.06875 | 7 | 0.0033 | 0.072 | 17 | 0.01
Mississippi | 0.07 | 2 | 0.0007 | 0.0707 | 20 | 0.01
Missouri | 0.04225 | 37 | 0.0358 | 0.0781 | 14 | 0.05
Montana (d) | 0 | 46 | 0 | 0 | 47
Nebraska | 0.055 | 29 | 0.013 | 0.068 | 26 | 0.02
Nevada | 0.0685 | 8 | 0.0109 | 0.0794 | 13 | 0.0125
New Hampshire | 0 | 46 | 0 | 0 | 47
New Jersey (e) | 0.07 | 2 | -0.0003 | 0.0697 | 23 | 0.035
New Mexico (c) | 0.05125 | 32 | 0.0222 | 0.0735 | 16 | 0.035625
New York | 0.04 | 38 | 0.0448 | 0.0848 | 7 | 0.04875
North Carolina | 0.0475 | 35 | 0.0215 | 0.069 | 25 | 0.0275
North Dakota | 0.05 | 33 | 0.0156 | 0.0656 | 30 | 0.03
Ohio | 0.0575 | 27 | 0.0135 | 0.071 | 19 | 0.0225
Oklahoma | 0.045 | 36 | 0.0427 | 0.0877 | 6 | 0.065
Oregon | 0 | 46 | 0 | 0 | 47
Pennsylvania | 0.06 | 16 | 0.0034 | 0.0634 | 32 | 0.02
Rhode Island | 0.07 | 2 | 0 | 0.07 | 21
South Carolina | 0.06 | 16 | 0.0113 | 0.0713 | 18 | 0.025
South Dakota (c) | 0.04 | 38 | 0.0183 | 0.0583 | 40 | 0.02
Tennessee | 0.07 | 2 | 0.0245 | 0.0945 | 1 | 0.05
Texas | 0.0625 | 12 | 0.018 | 0.0805 | 12 | 0.02
Utah (b) | 0.0595 | 26 | 0.0073 | 0.0668 | 28 | 0.021
Vermont | 0.06 | 16 | 0.0014 | 0.0614 | 34 | 0.01
Virginia (b) | 0.053 | 31 | 0.0033 | 0.0563 | 41 | 0.007
Washington | 0.065 | 9 | 0.0239 | 0.0889 | 5 | 0.031
West Virginia | 0.06 | 16 | 0.0007 | 0.0607 | 35 | 0.01
Wisconsin | 0.05 | 33 | 0.0043 | 0.0543 | 44 | 0.0175
Wyoming | 0.04 | 38 | 0.0147 | 0.0547 | 43 | 0.02
D.C. | 0.0575 | -27 | 0 | 0.0575 | -41
(a) City, county, and municipal rates vary. These rates are weighted by population to compute an average local tax rate.
(b) Three states [NAME] mandatory, statewide, local add-on sales taxes: California (1%), Utah (1.25%), Virginia (1%). We include these in their state sales taxes.
(c) The sales taxes in Hawaii, New Mexico, and South Dakota have broad bases that include many services.
(d) Due to data limitations, this table does not include sales taxes in local resort areas in Montana.
(e) Salem County is not subject to the statewide sales tax rate and collects a total rate of 3.5%. New Jersey's average local rate is represented as a negative.
Sources: Sales Tax Clearinghouse, Tax Foundation calculations, State Revenue Department websites.