Spreadsheet: 683166d1592528509-needing-vlookup-index-array-help-managing-customer-pricing-copy-of-example-file
Sheet: Accessories Price Zones

Zone | SKU | PRICE
X | 40 | 50.11
X | 41 | 51.11
X | 42 | 52.11
X | 43 | 53.11
X | 44 | 54.11
X | 45 | 55.11
X | 46 | 56.11
X | 47 | 57.11
X | 48 | 58.11
X | 49 | 59.11
X | 50 | 60.11
X | 51 | 61.11
X | 52 | 62.11
X | 53 | 63.11
X | 54 | 64.11
X | 55 | 65.11
X | 56 | 66.11
X | 57 | 67.11
X | 58 | 68.11
X | 59 | 69.11
X | 60 | 70.11
X | 61 | 71.11
X | 62 | 72.11
X | 63 | 73.11
X | 64 | 74.11
X | 65 | 75.11
X | 66 | 76.11
X | 67 | 77.11
X | 68 | 78.11
X | 69 | 79.11
X | 70 | 80.11
X | 71 | 81.11
X | 72 | 82.11
X | 73 | 83.11
X | 74 | 84.11
X | 75 | 85.11
X | 76 | 86.11
X | 77 | 87.11
X | 78 | 88.11
X | 79 | 89.11
X | 80 | 90.11
X | 81 | 91.11
X | 82 | 92.11
X | 83 | 93.11
X | 84 | 94.11
X | 85 | 95.11
X | 86 | 96.11
X | 87 | 97.11
X | 88 | 98.11
X | 89 | 99.11
X | 90 | 100.11
X | 91 | 101.11
X | 92 | 102.11
X | 93 | 103.11
X | 94 | 104.11
X | 95 | 105.11
X | 96 | 106.11
X | 97 | 107.11
X | 98 | 108.11
X | 99 | 109.11
X | 100 | 110.11
X | 101 | 111.11
X | 102 | 112.11
X | 103 | 113.11
X | 104 | 114.11
X | 105 | 115.11
X | 106 | 116.11
X | 107 | 117.11
X | 108 | 118.11
X | 109 | 119.11
X | 110 | 120.11
X | 111 | 121.11
X | 112 | 122.11
X | 113 | 123.11
X | 114 | 124.11
X | 115 | 125.11
X | 116 | 126.11
X | 117 | 127.11
X | 118 | 128.11
X | 119 | 129.11
X | 120 | 130.11
X | 121 | 131.11
X | 122 | 132.11
X | 123 | 133.11
X | 124 | 134.11
X | 125 | 135.11
X | 126 | 136.11
X | 127 | 137.11
X | 128 | 138.11
X | 129 | 139.11
X | 130 | 140.11
X | 131 | 141.11
X | 132 | 142.11
X | 133 | 143.11
X | 134 | 144.11
X | 135 | 145.11
X | 136 | 146.11
X | 137 | 147.11
X | 138 | 148.11
X | 139 | 149.11
X | 140 | 150.11
X | 141 | 151.11
X | 142 | 152.11
X | 143 | 153.11
X | 144 | 154.11
X | 145 | 155.11
X | 146 | 156.11
X | 147 | 157.11
X | 148 | 158.11
X | 149 | 159.11
X | 150 | 160.11
X | 151 | 161.11
X | 152 | 162.11
X | 153 | 163.11
X | 154 | 164.11
X | 155 | 165.11
X | 156 | 166.11
X | 157 | 167.11
X | 158 | 168.11
X | 159 | 169.11
X | 160 | 170.11
X | 161 | 171.11
X | 162 | 172.11
X | 163 | 173.11
X | 164 | 174.11
X | 165 | 175.11
X | 166 | 176.11
X | 167 | 177.11
X | 168 | 178.11
X | 169 | 179.11
X | 170 | 180.11
X | 171 | 181.11
X | 172 | 182.11
X | 173 | 183.11
X | 174 | 184.11
X | 175 | 185.11
X | 176 | 186.11
X | 177 | 187.11
X | 178 | 188.11
X | 179 | 189.11
X | 180 | 190.11
X | 181 | 191.11
X | 182 | 192.11
X | 183 | 193.11
X | 184 | 194.11
X | 185 | 195.11
X | 186 | 196.11
X | 187 | 197.11
X | 188 | 198.11
X | 189 | 199.11
X | 190 | 200.11
X | 191 | 201.11
X | 192 | 202.11
X | 193 | 203.11
X | 194 | 204.11
X | 195 | 205.11
X | 196 | 206.11
X | 197 | 207.11
X | 198 | 208.11
X | 199 | 209.11
X | 200 | 210.11
X | 201 | 211.11
X | 202 | 212.11
X | 203 | 213.11
X | 204 | 214.11
X | 205 | 215.11
X | 206 | 216.11
X | 207 | 217.11
X | 208 | 218.11
X | 209 | 219.11
X | 210 | 220.11
X | 211 | 221.11
X | 212 | 222.11
X | 213 | 223.11
X | 214 | 224.11
X | 215 | 225.11
X | 216 | 226.11
X | 217 | 227.11
X | 218 | 228.11
X | 219 | 229.11
X | 220 | 230.11
X | 221 | 231.11
X | 222 | 232.11
X | 223 | 233.11
X | 224 | 234.11
X | 225 | 235.11
X | 226 | 236.11
X | 227 | 237.11
X | 228 | 238.11
X | 229 | 239.11
X | 230 | 240.11
X | 231 | 241.11
X | 232 | 242.11
X | 233 | 243.11
X | 234 | 244.11
X | 235 | 245.11
X | 236 | 246.11
X | 237 | 247.11
X | 238 | 248.11
Y | 1 | 75.23
Y | 2 | 76.23
Y | 3 | 77.23
Y | 4 | 78.23
Y | 5 | 79.23
Y | 6 | 80.23
Y | 7 | 81.23
Y | 8 | 82.23
Y | 9 | 83.23
Y | 10 | 84.23
Y | 11 | 85.23
Y | 12 | 86.23
Y | 13 | 87.23
Y | 14 | 88.23
Y | 15 | 89.23
Y | 16 | 90.23
Y | 17 | 91.23
Y | 18 | 92.23
Y | 19 | 93.23
Y | 20 | 94.23
Y | 21 | 95.23
Y | 22 | 96.23
Y | 23 | 97.23
Y | 24 | 98.23
Y | 25 | 99.23
Y | 26 | 100.23
Y | 27 | 101.23
Y | 28 | 102.23
Y | 29 | 103.23
Y | 30 | 104.23
Y | 31 | 105.23
Y | 32 | 106.23
Y | 33 | 107.23
Y | 34 | 108.23
Y | 35 | 109.23
Y | 36 | 110.23
Y | 37 | 111.23
Y | 38 | 112.23
Y | 39 | 113.23
Y | 40 | 114.23
Y | 41 | 115.23
Y | 42 | 116.23
Y | 43 | 117.23
Y | 44 | 118.23
Y | 45 | 119.23
Y | 46 | 120.23
Y | 47 | 121.23
Y | 48 | 122.23
Y | 49 | 123.23
Y | 50 | 124.23
Y | 51 | 125.23
Y | 52 | 126.23
Y | 53 | 127.23
Y | 54 | 128.23
Y | 55 | 129.23
Y | 56 | 130.23
Y | 57 | 131.23
Y | 58 | 132.23
Y | 59 | 133.23
Y | 60 | 134.23
Y | 61 | 135.23
Y | 62 | 136.23
Y | 63 | 137.23
Y | 64 | 138.23
Y | 65 | 139.23
Y | 66 | 140.23
Y | 67 | 141.23
Y | 68 | 142.23
Y | 69 | 143.23
Y | 70 | 144.23
Y | 71 | 145.23
Y | 72 | 146.23
Y | 73 | 147.23
Y | 74 | 148.23
Y | 75 | 149.23
Y | 76 | 150.23
Y | 77 | 151.23
Y | 78 | 152.23
Y | 79 | 153.23
Y | 80 | 154.23
Y | 81 | 155.23
Y | 82 | 156.23
Y | 83 | 157.23
Y | 84 | 158.23
Y | 85 | 159.23
Y | 86 | 160.23
Y | 87 | 161.23
Y | 88 | 162.23
Y | 89 | 163.23
Y | 90 | 164.23
Y | 91 | 165.23
Y | 92 | 166.23
Y | 93 | 167.23
Y | 94 | 168.23
Y | 95 | 169.23
Y | 96 | 170.23
Y | 97 | 171.23
Y | 98 | 172.23
Y | 99 | 173.23
Y | 100 | 174.23
Y | 101 | 175.23
Y | 102 | 176.23
Y | 103 | 177.23
Y | 104 | 178.23
Y | 105 | 179.23
Y | 106 | 180.23
Y | 107 | 181.23
Y | 108 | 182.23
Y | 109 | 183.23
Y | 110 | 184.23
Y | 111 | 185.23
Y | 112 | 186.23
Y | 113 | 187.23
Y | 114 | 188.23
Y | 115 | 189.23
Y | 116 | 190.23
Y | 117 | 191.23
Y | 118 | 192.23
Y | 119 | 193.23
Y | 120 | 194.23
Y | 121 | 195.23
Y | 122 | 196.23
Y | 123 | 197.23
Y | 124 | 198.23
Y | 125 | 199.23
Y | 126 | 200.23
Y | 127 | 201.23
Y | 128 | 202.23
Y | 129 | 203.23
Y | 130 | 204.23
Y | 131 | 205.23
Y | 132 | 206.23
Y | 133 | 207.23
Y | 134 | 208.23
Y | 135 | 209.23
Y | 136 | 210.23
Y | 137 | 211.23
Y | 138 | 212.23
Y | 139 | 213.23
Y | 140 | 214.23
z | 1 | 37.75
z | 2 | 38.75
z | 3 | 39.75
z | 4 | 40.75
z | 5 | 41.75
z | 6 | 42.75
z | 7 | 43.75
z | 8 | 44.75
z | 9 | 45.75
z | 10 | 46.75
z | 11 | 47.75
z | 12 | 48.75
z | 13 | 49.75
z | 14 | 50.75
z | 15 | 51.75
z | 16 | 52.75
z | 17 | 53.75
z | 18 | 54.75
z | 19 | 55.75
z | 20 | 56.75
z | 21 | 57.75
z | 22 | 58.75
z | 23 | 59.75
z | 24 | 60.75
z | 25 | 61.75
z | 26 | 62.75
z | 27 | 63.75
z | 28 | 64.75
z | 29 | 65.75
z | 30 | 66.75
z | 31 | 67.75
z | 32 | 68.75
z | 33 | 69.75
z | 34 | 70.75
z | 35 | 71.75
z | 36 | 72.75
z | 37 | 73.75
z | 38 | 74.75
z | 39 | 75.75
z | 40 | 76.75
z | 41 | 77.75
z | 42 | 78.75
z | 43 | 79.75
z | 44 | 80.75
z | 45 | 81.75
z | 46 | 82.75
z | 47 | 83.75
z | 48 | 84.75
z | 49 | 85.75
z | 50 | 86.75
z | 51 | 87.75
z | 52 | 88.75
z | 53 | 89.75
z | 54 | 90.75
z | 55 | 91.75
z | 56 | 92.75
z | 57 | 93.75
z | 58 | 94.75
z | 59 | 95.75
z | 60 | 96.75
z | 61 | 97.75
z | 62 | 98.75
z | 63 | 99.75
z | 64 | 100.75
z | 65 | 101.75
z | 66 | 102.75
z | 67 | 103.75
z | 68 | 104.75
z | 69 | 105.75
z | 70 | 106.75
z | 71 | 107.75
z | 72 | 108.75
z | 73 | 109.75
z | 74 | 110.75
z | 75 | 111.75
z | 76 | 112.75
z | 77 | 113.75
z | 78 | 114.75
z | 79 | 115.75
z | 80 | 116.75
z | 81 | 117.75
z | 82 | 118.75
z | 83 | 119.75
z | 84 | 120.75
z | 85 | 121.75
z | 86 | 122.75
z | 87 | 123.75
z | 88 | 124.75
z | 89 | 125.75
z | 90 | 126.75
z | 91 | 127.75
z | 92 | 128.75
z | 93 | 129.75
z | 94 | 130.75
z | 95 | 131.75
z | 96 | 132.75
z | 97 | 133.75
z | 98 | 134.75
z | 99 | 135.75
z | 100 | 136.75
z | 101 | 137.75
z | 102 | 138.75
z | 103 | 139.75
z | 104 | 140.75
z | 105 | 141.75
z | 106 | 142.75
z | 107 | 143.75
z | 108 | 144.75
z | 109 | 145.75
z | 110 | 146.75
z | 111 | 147.75
z | 112 | 148.75
z | 113 | 149.75
z | 114 | 150.75
z | 115 | 151.75
z | 116 | 152.75
z | 117 | 153.75
z | 118 | 154.75
z | 119 | 155.75
z | 120 | 156.75
z | 121 | 157.75
z | 122 | 158.75
z | 123 | 159.75
z | 124 | 160.75
z | 125 | 161.75
z | 126 | 162.75
z | 127 | 163.75
z | 128 | 164.75
z | 129 | 165.75
z | 130 | 166.75
z | 131 | 167.75
z | 132 | 168.75
z | 133 | 169.75
z | 134 | 170.75
z | 135 | 171.75
z | 136 | 172.75
z | 137 | 173.75
z | 138 | 174.75
z | 139 | 175.75
z | 140 | 176.75
z | 141 | 177.75
z | 142 | 178.75
z | 143 | 179.75
z | 144 | 180.75
z | 145 | 181.75
z | 146 | 182.75
z | 147 | 183.75
z | 148 | 184.75
z | 149 | 185.75
z | 150 | 186.75
z | 151 | 187.75
z | 152 | 188.75
z | 153 | 189.75
z | 154 | 190.75
z | 155 | 191.75
z | 156 | 192.75
z | 157 | 193.75
z | 158 | 194.75
z | 159 | 195.75
z | 160 | 196.75
z | 161 | 197.75
z | 162 | 198.75
z | 163 | 199.75
z | 164 | 200.75
z | 165 | 201.75
z | 166 | 202.75
z | 167 | 203.75
z | 168 | 204.75
z | 169 | 205.75
z | 170 | 206.75
z | 171 | 207.75
z | 172 | 208.75
z | 173 | 209.75
z | 174 | 210.75
z | 175 | 211.75
z | 176 | 212.75
z | 177 | 213.75
z | 178 | 214.75
z | 179 | 215.75
z | 180 | 216.75
z | 181 | 217.75
z | 182 | 218.75
z | 183 | 219.75
z | 184 | 220.75
z | 185 | 221.75
z | 186 | 222.75
z | 187 | 223.75
z | 188 | 224.75
z | 189 | 225.75
z | 190 | 226.75
z | 191 | 227.75
z | 192 | 228.75
z | 193 | 229.75
z | 194 | 230.75
z | 195 | 231.75
z | 196 | 232.75
z | 197 | 233.75
z | 198 | 234.75
z | 199 | 235.75
z | 200 | 236.75
z | 201 | 237.75
z | 202 | 238.75
z | 203 | 239.75
z | 204 | 240.75
z | 205 | 241.75
z | 206 | 242.75
z | 207 | 243.75
z | 208 | 244.75
z | 209 | 245.75
z | 210 | 246.75
z | 211 | 247.75
z | 212 | 248.75
z | 213 | 249.75
z | 214 | 250.75
z | 215 | 251.75
z | 216 | 252.75
z | 217 | 253.75
z | 218 | 254.75
z | 219 | 255.75
z | 220 | 256.75
z | 221 | 257.75
z | 222 | 258.75
z | 223 | 259.75
z | 224 | 260.75
z | 225 | 261.75
z | 226 | 262.75
z | 227 | 263.75
z | 228 | 264.75
z | 229 | 265.75
z | 230 | 266.75
z | 231 | 267.75
z | 232 | 268.75
z | 233 | 269.75
z | 234 | 270.75
z | 235 | 271.75
z | 236 | 272.75
z | 237 | 273.75
z | 238 | 274.75
z | 239 | 275.75
z | 240 | 276.75
z | 241 | 277.75
z | 242 | 278.75
z | 243 | 279.75
z | 244 | 280.75
z | 245 | 281.75
z | 246 | 282.75
z | 247 | 283.75
z | 248 | 284.75
z | 249 | 285.75
z | 250 | 286.75
z | 251 | 287.75
z | 252 | 288.75
z | 253 | 289.75
z | 254 | 290.75
z | 255 | 291.75
z | 256 | 292.75
z | 257 | 293.75
z | 258 | 294.75
z | 259 | 295.75
z | 260 | 296.75
z | 261 | 297.75
z | 262 | 298.75
z | 263 | 299.75
z | 264 | 300.75
z | 265 | 301.75
z | 266 | 302.75
z | 267 | 303.75
z | 268 | 304.75
z | 269 | 305.75
z | 270 | 306.75
z | 271 | 307.75
z | 272 | 308.75
z | 273 | 309.75
z | 274 | 310.75
z | 275 | 311.75
z | 276 | 312.75
z | 277 | 313.75
z | 278 | 314.75
z | 279 | 315.75
z | 280 | 316.75
z | 281 | 317.75
z | 282 | 318.75
z | 283 | 319.75
z | 284 | 320.75
z | 285 | 321.75
z | 286 | 322.75
z | 287 | 323.75
z | 288 | 324.75
z | 289 | 325.75
z | 290 | 326.75
z | 291 | 327.75
z | 292 | 328.75
z | 293 | 329.75
z | 294 | 330.75
z | 295 | 331.75
z | 296 | 332.75
z | 297 | 333.75