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

SKU | Price
1 | 555.99
2 | 556.99
3 | 557.99
4 | 558.99
5 | 559.99
6 | 560.99
7 | 561.99
8 | 562.99
9 | 563.99
10 | 564.99
11 | 565.99
12 | 566.99
13 | 567.99
14 | 568.99
15 | 569.99
16 | 570.99
17 | 571.99
18 | 572.99
19 | 573.99
20 | 574.99
21 | 575.99
22 | 576.99
23 | 577.99
24 | 578.99
25 | 579.99
26 | 580.99
27 | 581.99
28 | 582.99
29 | 583.99
30 | 584.99
31 | 585.99
32 | 586.99
33 | 587.99
34 | 588.99
35 | 589.99
36 | 590.99
37 | 591.99
38 | 592.99
39 | 593.99
40 | 594.99
41 | 595.99
42 | 596.99
43 | 597.99
44 | 598.99
45 | 599.99
46 | 600.99
47 | 601.99
48 | 602.99
49 | 603.99
50 | 604.99
51 | 605.99
52 | 606.99
53 | 607.99
54 | 608.99
55 | 609.99
56 | 610.99
57 | 611.99
58 | 612.99
59 | 613.99
60 | 614.99
61 | 615.99
62 | 616.99
63 | 617.99
64 | 618.99
65 | 619.99
66 | 620.99
67 | 621.99
68 | 622.99
69 | 623.99
70 | 624.99
71 | 625.99
72 | 626.99
73 | 627.99
74 | 628.99
75 | 629.99
76 | 630.99
77 | 631.99
78 | 632.99
79 | 633.99
80 | 634.99
81 | 635.99
82 | 636.99
83 | 637.99
84 | 638.99
85 | 639.99
86 | 640.99
87 | 641.99
88 | 642.99
89 | 643.99
90 | 644.99
91 | 645.99
92 | 646.99
93 | 647.99
94 | 648.99
95 | 649.99
96 | 650.99
97 | 651.99
98 | 652.99
99 | 653.99
100 | 654.99
101 | 655.99
102 | 656.99
103 | 657.99
104 | 658.99
105 | 659.99
106 | 660.99
107 | 661.99
108 | 662.99
109 | 663.99
110 | 664.99
111 | 665.99
112 | 666.99
113 | 667.99
114 | 668.99
115 | 669.99
116 | 670.99
117 | 671.99
118 | 672.99
119 | 673.99
120 | 674.99
121 | 675.99
122 | 676.99
123 | 677.99
124 | 678.99
125 | 679.99
126 | 680.99
127 | 681.99
128 | 682.99
129 | 683.99
130 | 684.99
131 | 685.99
132 | 686.99
133 | 687.99
134 | 688.99
135 | 689.99
136 | 690.99
137 | 691.99
138 | 692.99
139 | 693.99
140 | 694.99
141 | 695.99
142 | 696.99
143 | 697.99
144 | 698.99
145 | 699.99
146 | 700.99
147 | 701.99
148 | 702.99
149 | 703.99
150 | 704.99
151 | 705.99
152 | 706.99
153 | 707.99
154 | 708.99
155 | 709.99
156 | 710.99
157 | 711.99
158 | 712.99
159 | 713.99
160 | 714.99
161 | 715.99
162 | 716.99
163 | 717.99
164 | 718.99
165 | 719.99
166 | 720.99
167 | 721.99
168 | 722.99
169 | 723.99
170 | 724.99
171 | 725.99
172 | 726.99
173 | 727.99
174 | 728.99
175 | 729.99
176 | 730.99
177 | 731.99
178 | 732.99
179 | 733.99
180 | 734.99
181 | 735.99
182 | 736.99
183 | 737.99
184 | 738.99
185 | 739.99
186 | 740.99
187 | 741.99
188 | 742.99
189 | 743.99
190 | 744.99
191 | 745.99
192 | 746.99
193 | 747.99
194 | 748.99
195 | 749.99
196 | 750.99
197 | 751.99
198 | 752.99
199 | 753.99
200 | 754.99
201 | 755.99
202 | 756.99
203 | 757.99
204 | 758.99
205 | 759.99
206 | 760.99
207 | 761.99
208 | 762.99
209 | 763.99
210 | 764.99
211 | 765.99
212 | 766.99
213 | 767.99
214 | 768.99
215 | 769.99
216 | 770.99
217 | 771.99
218 | 772.99
219 | 773.99
220 | 774.99
221 | 775.99
222 | 776.99
223 | 777.99
224 | 778.99
225 | 779.99
226 | 780.99
227 | 781.99
228 | 782.99
229 | 783.99
230 | 784.99
231 | 785.99
232 | 786.99
233 | 787.99
234 | 788.99
235 | 789.99
236 | 790.99
237 | 791.99
238 | 792.99
239 | 793.99
240 | 794.99
241 | 795.99
242 | 796.99
243 | 797.99
244 | 798.99
245 | 799.99
246 | 800.99
247 | 801.99
248 | 802.99
249 | 803.99
250 | 804.99
251 | 805.99
252 | 806.99
253 | 807.99
254 | 808.99
255 | 809.99
256 | 810.99
257 | 811.99
258 | 812.99
259 | 813.99
260 | 814.99
261 | 815.99
262 | 816.99
263 | 817.99
264 | 818.99
265 | 819.99
266 | 820.99
267 | 821.99
268 | 822.99
269 | 823.99
270 | 824.99
271 | 825.99
272 | 826.99
273 | 827.99
274 | 828.99
275 | 829.99
276 | 830.99
277 | 831.99
278 | 832.99
279 | 833.99
280 | 834.99
281 | 835.99
282 | 836.99
283 | 837.99
284 | 838.99
285 | 839.99
286 | 840.99
287 | 841.99
288 | 842.99
289 | 843.99
290 | 844.99
291 | 845.99
292 | 846.99
293 | 847.99
294 | 848.99
295 | 849.99
296 | 850.99
297 | 851.99
298 | 852.99
299 | 853.99
300 | 854.99
301 | 855.99
302 | 856.99
303 | 857.99
304 | 858.99
305 | 859.99
306 | 860.99
307 | 861.99
308 | 862.99
309 | 863.99
310 | 864.99
311 | 865.99
312 | 866.99
313 | 867.99
314 | 868.99
315 | 869.99
316 | 870.99
317 | 871.99
318 | 872.99
319 | 873.99
320 | 874.99
321 | 875.99
322 | 876.99
323 | 877.99
324 | 878.99
325 | 879.99
326 | 880.99
327 | 881.99
328 | 882.99
329 | 883.99
330 | 884.99
331 | 885.99
332 | 886.99
333 | 887.99
334 | 888.99
335 | 889.99
336 | 890.99
337 | 891.99
338 | 892.99
339 | 893.99
340 | 894.99
341 | 895.99
342 | 896.99
343 | 897.99
344 | 898.99
345 | 899.99
346 | 900.99
347 | 901.99
348 | 902.99
349 | 903.99
350 | 904.99
351 | 905.99
352 | 906.99
353 | 907.99
354 | 908.99
355 | 909.99
356 | 910.99
357 | 911.99
358 | 912.99
359 | 913.99
360 | 914.99
361 | 915.99
362 | 916.99
363 | 917.99
364 | 918.99
365 | 919.99
366 | 920.99
367 | 921.99
368 | 922.99
369 | 923.99
370 | 924.99
371 | 925.99
372 | 926.99
373 | 927.99
374 | 928.99
375 | 929.99
376 | 930.99
377 | 931.99
378 | 932.99
379 | 933.99
380 | 934.99
381 | 935.99
382 | 936.99
383 | 937.99
384 | 938.99
385 | 939.99
386 | 940.99
387 | 941.99
388 | 942.99
389 | 943.99
390 | 944.99
391 | 945.99
392 | 946.99
393 | 947.99
394 | 948.99
395 | 949.99
396 | 950.99
397 | 951.99
398 | 952.99
399 | 953.99
400 | 954.99
401 | 955.99
402 | 956.99
403 | 957.99
404 | 958.99
405 | 959.99
406 | 960.99
407 | 961.99
408 | 962.99
409 | 963.99
410 | 964.99
411 | 965.99
412 | 966.99
413 | 967.99
414 | 968.99
415 | 969.99
416 | 970.99
417 | 971.99
418 | 972.99
419 | 973.99
420 | 974.99
421 | 975.99
422 | 976.99
423 | 977.99
424 | 978.99
425 | 979.99
426 | 980.99
427 | 981.99
428 | 982.99
429 | 983.99
430 | 984.99
431 | 985.99
432 | 986.99
433 | 987.99
434 | 988.99
435 | 989.99
436 | 990.99
437 | 991.99
438 | 992.99
439 | 993.99
440 | 994.99
441 | 995.99
442 | 996.99
443 | 997.99
444 | 998.99
445 | 999.99
446 | 1000.99
447 | 1001.99
448 | 1002.99
449 | 1003.99
450 | 1004.99
451 | 1005.99
452 | 1006.99
453 | 1007.99
454 | 1008.99
455 | 1009.99
456 | 1010.99
457 | 1011.99
458 | 1012.99
459 | 1013.99
460 | 1014.99
461 | 1015.99
462 | 1016.99
463 | 1017.99
464 | 1018.99
465 | 1019.99
466 | 1020.99
467 | 1021.99
468 | 1022.99
469 | 1023.99
470 | 1024.99
471 | 1025.99
472 | 1026.99
473 | 1027.99
474 | 1028.99
475 | 1029.99
476 | 1030.99
477 | 1031.99
478 | 1032.99
479 | 1033.99
480 | 1034.99
481 | 1035.99
482 | 1036.99
483 | 1037.99
484 | 1038.99
485 | 1039.99
486 | 1040.99
487 | 1041.99
488 | 1042.99
489 | 1043.99
490 | 1044.99
491 | 1045.99
492 | 1046.99
493 | 1047.99
494 | 1048.99
495 | 1049.99
496 | 1050.99
497 | 1051.99
498 | 1052.99
499 | 1053.99
500 | 1054.99
501 | 1055.99
502 | 1056.99
503 | 1057.99
504 | 1058.99
505 | 1059.99
506 | 1060.99
507 | 1061.99
508 | 1062.99
509 | 1063.99
510 | 1064.99
511 | 1065.99
512 | 1066.99
513 | 1067.99
514 | 1068.99
515 | 1069.99
516 | 1070.99
517 | 1071.99
518 | 1072.99
519 | 1073.99
520 | 1074.99
521 | 1075.99
522 | 1076.99
523 | 1077.99
524 | 1078.99
525 | 1079.99
526 | 1080.99
527 | 1081.99
528 | 1082.99
529 | 1083.99
530 | 1084.99
531 | 1085.99
532 | 1086.99
533 | 1087.99
534 | 1088.99
535 | 1089.99
536 | 1090.99
537 | 1091.99
538 | 1092.99
539 | 1093.99
540 | 1094.99
541 | 1095.99
542 | 1096.99
543 | 1097.99
544 | 1098.99
545 | 1099.99
546 | 1100.99
547 | 1101.99
548 | 1102.99
549 | 1103.99
550 | 1104.99
551 | 1105.99
552 | 1106.99
553 | 1107.99
554 | 1108.99
555 | 1109.99
556 | 1110.99
557 | 1111.99
558 | 1112.99
559 | 1113.99
560 | 1114.99
561 | 1115.99
562 | 1116.99
563 | 1117.99
564 | 1118.99
565 | 1119.99
566 | 1120.99
567 | 1121.99
568 | 1122.99
569 | 1123.99
570 | 1124.99
571 | 1125.99
572 | 1126.99
573 | 1127.99
574 | 1128.99
575 | 1129.99
576 | 1130.99
577 | 1131.99
578 | 1132.99
579 | 1133.99
580 | 1134.99
581 | 1135.99
582 | 1136.99
583 | 1137.99
584 | 1138.99
585 | 1139.99
586 | 1140.99
587 | 1141.99
588 | 1142.99
589 | 1143.99
590 | 1144.99
591 | 1145.99
592 | 1146.99
593 | 1147.99
594 | 1148.99
595 | 1149.99
596 | 1150.99
597 | 1151.99
598 | 1152.99
599 | 1153.99
600 | 1154.99
601 | 1155.99
602 | 1156.99
603 | 1157.99
604 | 1158.99
605 | 1159.99
606 | 1160.99
607 | 1161.99
608 | 1162.99
609 | 1163.99
610 | 1164.99
611 | 1165.99
612 | 1166.99
613 | 1167.99
614 | 1168.99
615 | 1169.99
616 | 1170.99
617 | 1171.99
618 | 1172.99
619 | 1173.99
620 | 1174.99
621 | 1175.99
622 | 1176.99
623 | 1177.99
624 | 1178.99
625 | 1179.99
626 | 1180.99
627 | 1181.99
628 | 1182.99
629 | 1183.99
630 | 1184.99
631 | 1185.99
632 | 1186.99
633 | 1187.99
634 | 1188.99
635 | 1189.99
636 | 1190.99
637 | 1191.99
638 | 1192.99
639 | 1193.99
640 | 1194.99
641 | 1195.99
642 | 1196.99
643 | 1197.99
644 | 1198.99
645 | 1199.99
646 | 1200.99
647 | 1201.99
648 | 1202.99
649 | 1203.99
650 | 1204.99
651 | 1205.99
652 | 1206.99
653 | 1207.99
654 | 1208.99
655 | 1209.99
656 | 1210.99
657 | 1211.99
658 | 1212.99
659 | 1213.99
660 | 1214.99
661 | 1215.99
662 | 1216.99
663 | 1217.99
664 | 1218.99
665 | 1219.99
666 | 1220.99
667 | 1221.99
668 | 1222.99
669 | 1223.99
670 | 1224.99
671 | 1225.99
672 | 1226.99
673 | 1227.99
674 | 1228.99
675 | 1229.99
676 | 1230.99
677 | 1231.99
678 | 1232.99
679 | 1233.99
680 | 1234.99
681 | 1235.99
682 | 1236.99
683 | 1237.99
684 | 1238.99
685 | 1239.99
686 | 1240.99
687 | 1241.99
688 | 1242.99
689 | 1243.99
690 | 1244.99
691 | 1245.99
692 | 1246.99
693 | 1247.99
694 | 1248.99
695 | 1249.99
696 | 1250.99
697 | 1251.99
698 | 1252.99
699 | 1253.99
700 | 1254.99
701 | 1255.99
702 | 1256.99