Spreadsheet: 551925d1513222662-vlookup-isnt-helping-me-with-zip-codes-microsoft-excel-2013-workbook-shell-part-a
Sheet: UPS Ground (2)

 |  |  |  |  |  |  |  |  |  |  | 2016 Rates
 | Domestic
 | [NAME]
 | Zones | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 44 | 45 | 46
 | 1 Lbs. | 6.94 | 7.58 | 7.79 | 8.13 | 8.42 | 8.53 | 8.66 | 26.5 | 26.6 | 34.92
 | 2 | 7.66 | 8.25 | 8.91 | 9.1 | 9.49 | 9.69 | 9.96 | 29.47 | 29.01 | 37.88
 | 3 | 7.78 | 8.6 | 9.4 | 9.68 | 10.08 | 10.42 | 11.01 | 32.04 | 33.05 | 40.35
 | 4 | 8.03 | 8.81 | 9.85 | 10.29 | 10.59 | 11.09 | 11.8 | 35.18 | 35.25 | 43.75
 | 5 | 8.07 | 8.88 | 10.21 | 10.68 | 10.93 | 11.5 | 12.38 | 38.14 | 38.27 | 46.56
 | 6 | 8.35 | 9.13 | 10.34 | 10.89 | 11.19 | 11.79 | 12.48 | 41.15 | 40.72 | 48.33
 | 7 | 8.81 | 9.36 | 10.52 | 11.13 | 11.39 | 12.1 | 12.96 | 43.92 | 43.86 | 50.79
 | 8 | 8.97 | 9.59 | 10.69 | 11.34 | 11.74 | 12.47 | 13.4 | 44.58 | 46.14 | 52.33
 | 9 | 9.23 | 9.82 | 10.83 | 11.43 | 11.99 | 12.99 | 14.24 | 47.72 | 49.37 | 55.45
 | 10 | 9.44 | 9.86 | 11 | 11.75 | 12.36 | 13.75 | 15.19 | 50.7 | 53.53 | 58.43
 | 11 | 9.85 | 10.25 | 11.11 | 11.94 | 12.9 | 14.91 | 16.19 | 53.39 | 56.75 | 61.05
 | 12 | 10.01 | 10.57 | 11.2 | 12.11 | 13.11 | 15.5 | 17.11 | 55.69 | 58.79 | 63.31
 | 13 | 10.25 | 10.82 | 11.35 | 12.34 | 13.78 | 16.61 | 18.22 | 57.99 | 60.91 | 65.58
 | 14 | 10.51 | 11.12 | 11.46 | 12.52 | 14.43 | 17.64 | 19.27 | 60.39 | 63.28 | 67.94
 | 15 | 10.57 | 11.36 | 11.62 | 13.1 | 15.09 | 18.18 | 20.25 | 62.61 | 66.14 | 70.13
 | 16 | 10.69 | 11.47 | 11.72 | 13.18 | 15.58 | 18.95 | 20.86 | 65.41 | 68.91 | 72.92
 | 17 | 10.88 | 11.93 | 11.98 | 13.68 | 16.38 | 20.11 | 21.86 | 68.21 | 72.18 | 75.22
 | 18 | 10.9 | 12.09 | 12.33 | 14.35 | 17.05 | 20.53 | 22.92 | 71.03 | 76.1 | 78.02
 | 19 | 10.95 | 12.3 | 12.36 | 14.58 | 17.4 | 21.1 | 23.7 | 73.83 | 78.99 | 80.79
 | 20 | 11.1 | 12.52 | 12.78 | 15.3 | 18.16 | 21.89 | 24.8 | 76.3 | 81.85 | 83.22
 | 21 | 11.44 | 13.02 | 13.34 | 15.62 | 18.9 | 22.72 | 25.79 | 78.04 | 83.86 | 84.96
 | 22 | 11.69 | 13.26 | 13.84 | 16.34 | 19.68 | 23.55 | 26.92 | 80.49 | 86.47 | 87.39
 | 23 | 11.82 | 13.62 | 14.27 | 16.82 | 20.42 | 24.34 | 28 | 82.92 | 89.09 | 89.81
 | 24 | 12.05 | 13.93 | 14.73 | 17.36 | 21.4 | 25.17 | 29.1 | 85.63 | 92.01 | 92.5
 | 25 | 12.18 | 14.22 | 14.91 | 17.86 | 21.92 | 25.96 | 30.18 | 88.29 | 94.87 | 95.19
 | 26 | 12.65 | 14.57 | 15.54 | 18.41 | 22.73 | 27.08 | 31.19 | 91.08 | 97.87 | 98.17
 | 27 | 12.95 | 14.92 | 15.7 | 18.71 | 23.47 | 27.57 | 32.26 | 93.6 | 100.56 | 100.72
 | 28 | 13.18 | 15.42 | 16.58 | 19.75 | 24.8 | 29.02 | 33.38 | 96.12 | 103.28 | 103.25
 | 29 | 13.46 | 15.71 | 17.06 | 20.2 | 25.51 | 29.74 | 34.38 | 98.49 | 105.82 | 105.34
 | 30 | 13.6 | 15.95 | 17.57 | 20.8 | 25.92 | 30.1 | 35.48 | 100.84 | 108.34 | 107.74
 | 31 | 13.8 | 16.18 | 17.63 | 20.94 | 26.46 | 30.75 | 36.3 | 102.35 | 110.81 | 109.4
 | 32 | 13.9 | 16.22 | 17.93 | 21.32 | 26.96 | 31.29 | 37.4 | 104.55 | 113.19 | 111.61
 | 33 | 14.03 | 16.74 | 18.73 | 22.31 | 27.94 | 32.41 | 38.41 | 106.74 | 115.56 | 113.84
 | 34 | 14.12 | 16.95 | 19.14 | 22.66 | 28.46 | 32.96 | 39.49 | 109.13 | 118.15 | 116.17
 | 35 | 14.37 | 17.68 | 19.59 | 23.21 | 29.16 | 33.8 | 40.54 | 111.83 | 121.07 | 118.86
 | DAILY RATES
 | Domestic
 | [NAME]
 | Zones | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 44 | 45 | 46
 | 36 Lbs. | 14.58 | 17.69 | 19.94 | 24.01 | 29.89 | 34.96 | 41.34 | 114.23 | 123.69 | 121.49
 | 37 | 14.96 | 18.09 | 20.33 | 24.54 | 30.52 | 35.73 | 42.14 | 116.84 | 126.5 | 124.13
 | 38 | 15.17 | 18.37 | 20.78 | 25.13 | 31.21 | 36.57 | 42.92 | 119.63 | 129.53 | 126.94
 | 39 | 15.39 | 18.73 | 21.26 | 25.41 | 32.01 | 37.57 | 43.8 | 122.21 | 132.32 | 129.31
 | 40 | 15.41 | 18.98 | 21.32 | 25.7 | 32.66 | 38.01 | 44.53 | 124.83 | 135.16 | 131.85
 | 41 | 15.61 | 19.43 | 21.89 | 26.33 | 33.39 | 38.82 | 45.04 | 126.99 | 137.5 | 134.25
 | 42 | 15.85 | 19.86 | 22.52 | 26.92 | 34.18 | 39.85 | 45.71 | 129.38 | 140.1 | 136.63
 | 43 | 16.06 | 19.96 | 22.78 | 27.76 | 35.35 | 41.3 | 46.5 | 132.01 | 142.94 | 139.27
 | 44 | 16.43 | 20.35 | 23.38 | 28.26 | 35.66 | 41.78 | 46.99 | 133.9 | 144.97 | 141.93
 | 45 | 16.44 | 20.66 | 23.8 | 28.82 | 36.25 | 43.01 | 47.78 | 136.49 | 147.78 | 144.55
 | 46 | 16.66 | 20.67 | 24.12 | 29.07 | 36.86 | 43.46 | 48.57 | 139.12 | 150.63 | 147.19
 | 47 | 16.77 | 20.94 | 24.5 | 29.56 | 37.35 | 44.31 | 49.36 | 141.79 | 153.51 | 149.85
 | 48 | 16.78 | 21.04 | 24.81 | 30.06 | 37.92 | 45.15 | 50.14 | 144.21 | 156.13 | 152.3
 | 49 | 16.82 | 21.05 | 24.85 | 30.28 | 38.39 | 45.95 | 50.91 | 146.68 | 158.81 | 154.81
 | 50 | 16.9 | 21.16 | 24.93 | 30.39 | 38.52 | 46.06 | 51.69 | 149.15 | 161.48 | 157.29
 | 51 | 16.93 | 21.2 | 25.11 | 30.42 | 38.56 | 46.07 | 51.79 | 150.15 | 162.66 | 159.7
 | 52 | 16.95 | 21.24 | 25.28 | 30.49 | 38.6 | 46.08 | 51.9 | 150.45 | 165.25 | 159.98
 | 53 | 16.97 | 21.28 | 25.3 | 30.69 | 38.64 | 46.09 | 52 | 152.73 | 167.76 | 162.27
 | 54 | 16.99 | 21.32 | 25.32 | 30.89 | 38.68 | 46.1 | 52.66 | 154.88 | 170.13 | 164.71
 | 55 | 17 | 21.36 | 25.34 | 31.34 | 38.72 | 46.11 | 53.27 | 156.97 | 172.42 | 167.19
 | 56 | 17.02 | 21.56 | 25.38 | 31.77 | 38.76 | 46.13 | 53.93 | 159.09 | 174.75 | 169.64
 | 57 | 17.41 | 21.71 | 25.44 | 32.23 | 38.8 | 46.3 | 54.49 | 161.28 | 177.15 | 172.24
 | 58 | 17.42 | 21.72 | 25.67 | 32.89 | 38.92 | 46.41 | 54.94 | 163.4 | 179.48 | 174.7
 | 59 | 17.56 | 21.94 | 26.04 | 32.9 | 39.27 | 46.66 | 55.34 | 165.89 | 182.23 | 177.3
 | 60 | 17.74 | 22.15 | 26.44 | 33.13 | 39.63 | 46.91 | 55.69 | 168.47 | 185.06 | 179.9
 | 61 | 18.09 | 22.84 | 26.45 | 33.82 | 39.98 | 47.18 | 56.02 | 170.54 | 187.33 | 182.04
 | 62 | 18.4 | 23.56 | 26.66 | 34.13 | 40.25 | 47.91 | 56.37 | 173.35 | 190.42 | 184.91
 | 63 | 18.47 | 23.79 | 26.67 | 34.35 | 40.52 | 48 | 56.71 | 176.17 | 193.51 | 187.79
 | 64 | 18.8 | 24.25 | 27.36 | 34.8 | 41.19 | 48.32 | 57.58 | 179.12 | 196.76 | 190.82
 | 65 | 19.19 | 24.71 | 27.37 | 34.81 | 41.55 | 48.42 | 57.68 | 182.04 | 199.96 | 193.85
 | 66 | 19.47 | 25.15 | 27.42 | 34.84 | 41.58 | 48.57 | 57.8 | 184.85 | 203.06 | 196.7
 | 67 | 19.72 | 25.17 | 27.69 | 34.88 | 41.9 | 48.81 | 57.94 | 187.65 | 206.13 | 199.59
 | 68 | 19.88 | 25.87 | 29.03 | 35.03 | 42.13 | 49.09 | 58.07 | 190.36 | 209.1 | 202.37
 | 69 | 20.1 | 25.88 | 29.04 | 35.93 | 42.35 | 49.33 | 58.24 | 193.14 | 212.15 | 205.2
 | 70 | 20.2 | 25.93 | 29.68 | 36.38 | 43.19 | 49.5 | 58.75 | 197.21 | 216.63 | 207.74
 | 71 | 20.3 | 26.19 | 30.14 | 36.46 | 43.87 | 50.36 | 58.86 | 200.22 | 219.93 | 210.79
 | 72 | 20.58 | 26.23 | 30.55 | 37.3 | 44.2 | 52.02 | 59.16 | 203.21 | 223.22 | 213.8
 | 73 | 21.3 | 26.25 | 30.67 | 37.42 | 44.68 | 52.31 | 59.28 | 206.18 | 226.47 | 216.82
 | 74 | 22.28 | 26.27 | 31.07 | 37.91 | 45.37 | 53.12 | 59.4 | 208.16 | 228.66 | 217.51
 | 75 | 23.1 | 27.01 | 31.17 | 38.54 | 46.23 | 53.65 | 59.52 | 210.53 | 231.25 | 219.07
 | DAILY RATES
 | Domestic
 | [NAME]
 | Zones | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 44 | 45 | 46
 | 76 Lbs. | 23.98 | 28 | 31.27 | 39.17 | 46.81 | 54.53 | 59.83 | 213.12 | 234.11 | 221.68
 | 77 | 24.9 | 28.64 | 32.2 | 39.67 | 47.09 | 55.57 | 59.94 | 214.88 | 236.03 | 222.97
 | 78 | 25.67 | 29.19 | 32.57 | 40.11 | 47.37 | 56.5 | 59.99 | 216.03 | 237.28 | 224.59
 | 79 | 26.57 | 30.41 | 33.39 | 40.73 | 48.36 | 56.83 | 60.42 | 216.07 | 237.33 | 225.22
 | 80 | 27.29 | 31.27 | 34.18 | 41.3 | 49.17 | 57.63 | 60.87 | 218.33 | 239.82 | 226.38
 | 81 | 28.19 | 32.12 | 35.3 | 41.6 | 49.82 | 58.51 | 61.64 | 220.15 | 241.84 | 227.54
 | 82 | 28.86 | 32.55 | 35.77 | 42.36 | 49.93 | 59.78 | 61.93 | 221.26 | 243.04 | 228.61
 | 83 | 29.68 | 33.53 | 36.9 | 42.67 | 50.56 | 60.02 | 62.04 | 223.68 | 245.71 | 229.48
 | 84 | 30.57 | 34.01 | 37.29 | 43.48 | 51.32 | 60.76 | 62.74 | 226.25 | 248.53 | 232.04
 | 85 | 31.39 | 34.86 | 38.01 | 44.18 | 52.11 | 61.41 | 63.42 | 228.88 | 251.41 | 234.64
 | 86 | 32.26 | 35.99 | 38.78 | 44.89 | 52.73 | 61.96 | 64.14 | 231.29 | 254.06 | 237.07
 | 87 | 33.2 | 36.46 | 39.65 | 45 | 53.42 | 62.6 | 64.84 | 233.89 | 256.91 | 239.63
 | 88 | 34.25 | 37.29 | 40.39 | 46.03 | 54.12 | 63.25 | 65.56 | 236.47 | 259.74 | 242.22
 | 89 | 35.44 | 38.33 | 41.55 | 46.62 | 54.79 | 63.9 | 66.92 | 238.94 | 262.46 | 244.66
 | 90 | 36.6 | 38.58 | 41.76 | 46.65 | 55.05 | 64.01 | 66.97 | 241.36 | 265.12 | 248.05
 | 91 | 37.19 | 39.24 | 42.58 | 47.1 | 55.63 | 64.17 | 67.69 | 243.95 | 267.96 | 249.65
 | 92 | 38.09 | 39.98 | 43.2 | 47.81 | 56.35 | 64.45 | 68.42 | 246.27 | 270.52 | 251.96
 | 93 | 39 | 40.75 | 44.03 | 48.47 | 56.79 | 64.69 | 69.12 | 248.67 | 273.15 | 254.37
 | 94 | 39.91 | 41.49 | 44.65 | 49.1 | 57.45 | 64.81 | 69.84 | 251.02 | 275.74 | 256.7
 | 95 | 40.84 | 42.19 | 45.34 | 49.75 | 57.84 | 65.03 | 70.58 | 253.44 | 278.38 | 259.11
 | 96 | 41.75 | 42.9 | 46.54 | 50.31 | 58.17 | 65.39 | 71.26 | 255.77 | 280.94 | 261.41
 | 97 | 42.71 | 44.14 | 46.81 | 51.11 | 58.87 | 65.49 | 71.99 | 258.21 | 283.64 | 263.84
 | 98 | 43.69 | 44.43 | 47.7 | 51.72 | 59.53 | 65.98 | 72.71 | 260.5 | 286.15 | 266.14
 | 99 | 44.65 | 45.14 | 48.61 | 52.36 | 60.22 | 66.64 | 73.43 | 262.94 | 288.84 | 268.57
 | 100 | 45.48 | 45.87 | 49.51 | 53.15 | 60.88 | 67.32 | 74.15 | 265.39 | 291.51 | 271
 | 101 | 45.85 | 46.2 | 49.98 | 53.43 | 61 | 67.38 | 74.2 | 266.2 | 294.18 | 271.77
 | 102 | 46.33 | 46.9 | 50.56 | 54.12 | 61.63 | 67.99 | 74.92 | 267.69 | 296.9 | 273.24
 | 103 | 47.59 | 47.62 | 51.18 | 54.66 | 62.79 | 69.17 | 75.58 | 270.1 | 299.57 | 275.64
 | 104 | 47.88 | 48.31 | 51.79 | 55.24 | 63 | 69.37 | 76.29 | 272.65 | 302.41 | 278.18
 | 105 | 48.67 | 49.04 | 52.38 | 56.36 | 63.39 | 69.78 | 76.95 | 275.08 | 305.1 | 280.59
 | 106 | 49.47 | 49.77 | 52.98 | 56.39 | 63.97 | 70.4 | 77.66 | 277.63 | 307.91 | 283.13
 | 107 | 50.19 | 50.52 | 54.11 | 56.96 | 64.55 | 71.02 | 78.35 | 280.19 | 310.77 | 285.69
 | 108 | 50.92 | 51.24 | 54.2 | 57.53 | 65.14 | 71.64 | 79.04 | 282.75 | 313.59 | 288.22
 | 109 | 51.65 | 51.94 | 54.79 | 58.1 | 65.72 | 72.25 | 79.75 | 285.16 | 316.28 | 290.63
 | 110 | 52.28 | 52.71 | 55.41 | 58.66 | 66.36 | 72.9 | 80.44 | 287.58 | 318.95 | 293.03
 | 111 | 52.86 | 53.29 | 56.58 | 59.23 | 66.92 | 73.5 | 81.31 | 290.84 | 322.59 | 297.04
 | 112 | 53.94 | 54.39 | 57.19 | 59.81 | 67.49 | 74.14 | 82.19 | 294.13 | 326.22 | 301.07
 | 113 | 54 | 54.44 | 57.82 | 60.36 | 68.09 | 74.75 | 83.68 | 296.68 | 329.06 | 303.62
 | 114 | 54.57 | 55.58 | 58.46 | 61.53 | 68.68 | 75.35 | 83.88 | 299.27 | 331.92 | 306.21
 | 115 | 55.15 | 55.67 | 58.54 | 61.7 | 69.24 | 76 | 84.23 | 301.81 | 334.75 | 308.76
 | DAILY RATES
 | Domestic
 | [NAME]
 | Zones | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 44 | 45 | 46
 | 116 Lbs. | 55.73 | 56.42 | 59.73 | 61.98 | 69.71 | 76.46 | 84.76 | 303.69 | 336.83 | 311.22
 | 117 | 56.29 | 57.01 | 60.34 | 63.12 | 70.28 | 77.07 | 86.12 | 306.12 | 339.52 | 313.64
 | 118 | 56.88 | 58.18 | 60.4 | 63.3 | 70.86 | 77.69 | 86.89 | 308.53 | 342.2 | 316.08
 | 119 | 57.48 | 58.24 | 61.01 | 63.67 | 71.45 | 78.3 | 87.92 | 312.99 | 347.16 | 322.16
 | 120 | 58.47 | 59.33 | 61.65 | 64.27 | 72.03 | 78.92 | 88.03 | 315.56 | 350.01 | 324.75
 | 121 | 59.11 | 59.66 | 62.28 | 64.72 | 72.49 | 79.35 | 88.43 | 317.66 | 352.34 | 327.49
 | 122 | 59.52 | 60.22 | 62.9 | 65.29 | 73.06 | 80.6 | 89.15 | 320.36 | 355.33 | 330.22
 | 123 | 60.13 | 60.29 | 64.17 | 65.85 | 73.64 | 80.8 | 89.86 | 323.09 | 358.35 | 332.95
 | 124 | 60.7 | 61.46 | 64.21 | 66.45 | 74.24 | 81.19 | 90.53 | 325.78 | 361.35 | 335.69
 | 125 | 61.31 | 61.47 | 64.86 | 67.03 | 74.81 | 81.81 | 91.21 | 328.5 | 364.35 | 338.42
 | 126 | 62.49 | 62.67 | 66.13 | 67.47 | 75.24 | 82.25 | 92.66 | 330.54 | 366.61 | 341.14
 | 127 | 62.54 | 62.7 | 66.78 | 68.04 | 75.82 | 82.86 | 93.33 | 333.24 | 369.6 | 343.87
 | 128 | 63.13 | 63.15 | 67.44 | 68.63 | 76.38 | 84.05 | 94.05 | 335.94 | 372.61 | 346.6
 | 129 | 64.33 | 64.37 | 68.08 | 69.23 | 76.97 | 84.35 | 94.75 | 338.64 | 375.6 | 349.33
 | 130 | 64.35 | 64.57 | 68.71 | 69.76 | 77.53 | 84.66 | 95.46 | 341.35 | 378.61 | 352.06
 | 131 | 64.94 | 64.99 | 69.37 | 70.24 | 77.96 | 85.11 | 95.49 | 345.03 | 382.68 | 358.24
 | 132 | 65.56 | 66.25 | 69.57 | 70.81 | 78.54 | 85.69 | 96.88 | 347.73 | 385.69 | 361.01
 | 133 | 66.17 | 66.35 | 70.03 | 71.37 | 79.09 | 86.3 | 97.2 | 350.45 | 388.69 | 363.76
 | 134 | 66.77 | 66.86 | 70.72 | 71.98 | 79.7 | 86.89 | 97.61 | 353.18 | 391.71 | 366.53
 | 135 | 67.28 | 68.18 | 71.35 | 72.58 | 80.35 | 87.53 | 99.01 | 355.85 | 394.7 | 369.27
 | 136 | 67.84 | 68.79 | 72.73 | 73.19 | 80.99 | 88.17 | 99.04 | 358.56 | 397.7 | 372.01
 | 137 | 68.43 | 68.99 | 73.41 | 73.72 | 81.46 | 88.72 | 99.7 | 361.3 | 400.73 | 374.79
 | 138 | 69.06 | 69.43 | 74.09 | 74.41 | 82.9 | 89.45 | 101.1 | 363.99 | 403.72 | 377.56
 | 139 | 69.68 | 70.8 | 74.39 | 75.03 | 83.15 | 90.06 | 101.5 | 366.71 | 406.74 | 380.31
 | 140 | 70.3 | 71 | 74.79 | 75.65 | 83.56 | 90.69 | 101.8 | 369.26 | 409.56 | 382.93
 | 141 | 70.92 | 71.46 | 75.51 | 76.24 | 84.04 | 91.15 | 102.31 | 371.1 | 411.61 | 385.53
 | 142 | 71.2 | 72.13 | 76.2 | 76.86 | 84.66 | 91.78 | 102.99 | 373.73 | 414.52 | 388.2
 | 143 | 71.84 | 72.79 | 76.9 | 77.48 | 85.31 | 92.43 | 103.69 | 376.26 | 417.32 | 390.79
 | 144 | 72.47 | 73.46 | 77.62 | 78.1 | 85.95 | 93.05 | 104.39 | 378.84 | 420.18 | 393.4
 | 145 | 72.72 | 74.89 | 78.72 | 78.74 | 86.6 | 93.67 | 105.09 | 381.52 | 423.15 | 396.17
 | 146 | 73.35 | 75.51 | 79.03 | 79.33 | 87.24 | 94.29 | 105.76 | 384.24 | 426.17 | 398.95
 | 147 | 74.44 | 75.65 | 79.78 | 79.97 | 87.86 | 94.94 | 106.48 | 386.93 | 429.16 | 401.69
 | 148 | 74.64 | 76.19 | 80.61 | 80.63 | 89.16 | 95.57 | 107.19 | 389.64 | 432.16 | 404.46
 | 149 | 74.85 | 76.87 | 81.2 | 81.21 | 89.36 | 96.18 | 108.39 | 394.23 | 437.25 | 411.15
 | 150 | 75.49 | 77.56 | 82.54 | 83.94 | 89.84 | 96.84 | 109.1 | 396.94 | 440.26 | 417.9
 | Dimensional Weight of More Than 150 Lbs.
 | Price Per Pound | 0.51 | 0.52 | 0.56 | 0.5700000000000001 | 0.6 | 0.65 | 0.73 | 2.65 | 2.94 | 2.79
 | DAILY RATES