Spreadsheet: 84629d1284655711-excel-2007-lookup-vlookup-using-two-lookup-values-test-sheet
Sheet: SALES

Cust# | Business Line | Sales | Manager # | Territory # | Rep # | Charges
102000 | CIA | 966.21 | 72 | 1 | 1 | 0
102000 | DW | 240.69 | 27 | 1 | 1 | 12.72 |  |  |  | GO OVER TO THE PIVOT TABLE, LOOK AT THE CUST#, THEN THE BUSINESS LINE, AND RETURN
102000 | FW | 187.79 | 27 | 1 | 1 | 108.82 |  |  |  | THE AMOUNT THAT MATCHES BOTH.
102000 | GAD | 611.31 | 27 | 1 | 1 | 848.06
103058 | GAD | 30118.08 | 27 | 60 | 30
103060 | GAD | 1559.52 | 72 | 19 | 7
103081 | GAD | 762 | 27 | 55 | 12
103510 | GAD | 872.83 | 27 | 55 | 76
103555 | DW | 647.5 | 27 | 55 | 76
103555 | FW | 54488.79 | 27 | 55 | 76
103555 | GAD | 7774.5 | 27 | 55 | 76
103643 | GAD | 124.5 | 72 | 1 | 1
103652 | GAD | 345 | 72 | 19 | 66
103701 | GAD | 2016 | 27 | 55 | 55
103736 | FW | 18320 | 72 | 19 | 79
103736 | GAD | 78484.64 | 72 | 19 | 79
103737 | FW | 1980 | 72 | 19 | 79
103738 | GAD | 1106.94 | 72 | 19 | 19
104099 | GAD | 1350 | 27 | 60 | 60
104103 | GAD | 245 | 27 | 60 | 60
104137 | GAD | 611.2 | 72 | 61 | 48
104138 | GAD | 4500 | 72 | 19 | 19
104251 | GAD | 264 | 72 | 19 | 48
104282 | GAD | 116.4 | 27 | 55 | 76
104284 | GAD | 972 | 27 | 55 | 34
104352 | GAD | 879.45 | 72 | 59 | 65
104368 | GAD | 1514.4 | 72 | 19 | 19
104427 | GAD | 344.22 | 27 | 55 | 15
104500 | DW | 3162.8 | 27 | 55 | 76
104500 | GAD | 5394 | 27 | 55 | 76
104855 | GAD | 25185 | 27 | 55 | 76
105103 | GAD | 1812 | 72 | 61 | 61
105196 | GAD | 2314.84 | 72 | 73 | 77
105201 | GAD | 564.5 | 27 | 55 | 76
105209 | GAD | 1513.14 | 27 | 55 | 55
105275 | GAD | 633 | 72 | 55 | 12
105440 | GAD | 8117.4 | 72 | 61 | 61
105503 | CIA | 188.5 | 72 | 55 | 9C
105561 | GAD | 14631.04 | 72 | 61 | 48
105566 | GAD | 1269.25 | 27 | 60 | 60
105590 | FW | 681.12 | 27 | 27 | 60
106048 | GAD | 4552.8 | 72 | 61 | 61
106079 | GAD | 327983.76 | 72 | 72 | 3
106149 | GAD | 869.4 | 27 | 60 | 60
106304 | GAD | 126 | 72 | 19 | 19
106575 | FW | 19108.35 | 27 | 92 | 87
106953 | GAD | 2004 | 72 | 73 | 35
107251 | DW | 2216 | 72 | 61 | 61
107251 | GAD | 7288.18 | 72 | 61 | 61
107351 | GAD | 56926.8 | 72 | 61 | 15
107859 | GAD | 1697 | 72 | 61 | 48
207701 | GAD | 170 | 27 | 55 | 12
209499 | GAD | 1388.75 | 27 | 60 | 60
212501 | GAD | 78191.4 | 72 | 19 | 57
212502 | GAD | 1099.38 | 72 | 19 | 19
214151 | GAD | 165 | 27 | 55 | 9C
217891 | GAD | 2154.3 | 72 | 19 | 57
236233 | GAD | 2226 | 72 | 61 | 61
236234 | CIA | 813 | 72 | 72 | 10C
242010 | GAD | 232.5 | 72 | 61 | 48
244601 | GAD | 200 | 72 | 19 | 19
244806 | GAD | 250.26 | 72 | 73 | 59
244810 | GAD | 280.08 | 72 | 73 | 59
244811 | GAD | 529.2 | 72 | 73 | 59
244813 | GAD | 409.92 | 72 | 73 | 59
244830 | GAD | 451.56 | 72 | 73 | 59
244837 | GAD | 389.22 | 72 | 73 | 59
244869 | GAD | 252.9 | 72 | 73 | 59
244879 | GAD | 253.56 | 72 | 73 | 59
245602 | GAD | 6867.6 | 72 | 73 | 77
245650 | GAD | 2343.6 | 27 | 55 | 76
255549 | GAD | 8232 | 72 | 19 | 19
285700 | GAD | 2082.2 | 72 | 73 | 77
286499 | GAD | 1152 | 72 | 73 | 19
290700 | GAD | 6411.12 | 72 | 19 | 19
291815 | GAD | 324.3 | 27 | 60 | 60
292840 | GAD | 5500.14 | 72 | 73 | 59
301875 | GAD | 1462.8 | 72 | 73 | 77
305520 | GAD | 268.44 | 72 | 19 | 7
309703 | FW | 2958 | 72 | 19 | 79
309703 | GAD | 13422.4 | 72 | 19 | 79
309715 | GAD | 49126.2 | 72 | 73 | 35
309804 | GAD | 135 | 72 | 59 | 59
309807 | GAD | 262.08 | 72 | 59 | 59
309812 | GAD | 7.45 | 72 | 59 | 59
317650 | FW | 14850 | 27 | 92 | 30
319551 | GAD | 2609.2 | 72 | 19 | 57
322649 | GAD | 1745.16 | 72 | 61 | 48
322650 | GAD | 883.38 | 27 | 60 | 60
342287 | DW | 1782 | 72 | 19 | 79
342287 | FW | 8594 | 72 | 19 | 79
342287 | GAD | 4789.8 | 72 | 19 | 79
342300 | DW | 1746 | 72 | 19 | 79
342300 | FW | 7274 | 72 | 19 | 79
342300 | GAD | 4302.9 | 72 | 19 | 79
343001 | GAD | 658.32 | 72 | 61 | 48
346421 | GAD | 252 | 72 | 19 | 59
346991 | GAD | 78 | 27 | 55 | 12
347010 | GAD | 993.9 | 72 | 59 | 65
347204 | CIA | 269.4 | 72 | 19 | 79
347204 | GAD | 11794.9 | 72 | 19 | 79
351454 | FW | 26383 | 27 | 55 | 101
351454 | GAD | 459.8 | 27 | 55 | 101
351456 | GAD | 6830 | 72 | 59 | 59
351460 | GAD | 656.64 | 72 | 19 | 7
356100 | GAD | 31629.84 | 27 | 55 | 15
356900 | GAD | 959.76 | 72 | 73 | 77
356992 | GAD | 1655.1 | 72 | 73 | 77
367004 | GAD | 21182.4 | 72 | 19 | 62
372001 | GAD | 135 | 72 | 73 | 77
373801 | GAD | 18432 | 27 | 55 | 76
374004 | GAD | 7847.04 | 72 | 73 | 35
382005 | GAD | 532.5 | 72 | 73 | 77
382007 | GAD | 2137.3 | 72 | 73 | 77
382008 | GAD | 726.8 | 72 | 73 | 77
382009 | GAD | 553.8 | 72 | 73 | 77
384300 | GAD | 10357.06 | 72 | 19 | 59
384430 | GAD | 8158 | 72 | 19 | 7
386705 | GAD | 6480 | 72 | 19 | 89
401501 | GAD | 5409.6 | 72 | 73 | 77
401520 | GAD | 1123.2 | 72 | 19 | 19
403002 | GAD | 216 | 27 | 60 | 30
409203 | GAD | 1566 | 72 | 19 | 19
409300 | GAD | 3487.32 | 27 | 60 | 60
412200 | GAD | 8850 | 72 | 19 | 66
421956 | GAD | 259.2 | 72 | 59 | 59
421957 | FW | 12992.05 | 27 | 55 | 101
427492 | GAD | 1504 | 72 | 73 | 35
429811 | CIA | 1068.6 | 72 | 59 | 48
429811 | GAD | 1107.5 | 72 | 61 | 48
434001 | GAD | 262.5 | 72 | 19 | 59
434002 | GAD | 357.85 | 27 | 60 | 30
434300 | FW | 5693.12 | 27 | 92 | 801
434300 | GAD | 6361.3 | 27 | 92 | 801
440004 | GAD | 260 | 72 | 1 | 1
442742 | GAD | 695 | 72 | 19 | 59
446899 | GAD | 4197.6 | 72 | 19 | 57
446995 | GAD | 3158.4 | 27 | 55 | 76
454787 | CIA | 7842.15 | 72 | 55C | 9C
459007 | FW | 29481.13 | 27 | 92 | 87
465000 | GAD | 8647.2 | 27 | 55 | 76
469990 | GAD | 1645.58 | 27 | 34 | 34
475500 | GAD | 7977.6 | 72 | 19 | 19
481365 | GAD | 3171.12 | 27 | 55 | 15
481366 | GAD | 285.9 | 72 | 61 | 48
487600 | DW | 503513.24 | 27 | 90 | 76
487600 | FW | 719050.9 | 27 | 90 | 13
487600 | GAD | 1910179.21 | 27 | 73 | 76
488500 | GAD | 3332 | 72 | 73 | 35
500000 | GAD | 1665.7 | 72 | 61 | 48
501500 | GAD | 2061.32 | 72 | 19 | 33
503100 | GAD | 3962.16 | 72 | 61 | 48
511000 | GAD | 523.24 | 27 | 55 | 76
905443 | GAD | 2138.4 | 72 | 73 | 19
905603 | GAD | 288 | 72 | 61 | 48
905636 | GAD | 933.6 | 27 | 55 | 55
C00001 | CIA | 5553.74 | 72 | 55 | 55C
[NAME] | CIA | 3144.96 | 72 | 55 | 10C
C105197 | CIA | 1018 | 72 | 59 | 6C
C105427 | CIA | 4385.47 | 72 | 59 | 6C
C105573 | CIA | 1054.6 | 72 | 55 | 4C
C105692 | CIA | 2556.2 | 72 | 55 | 5C
C105693 | CIA | 27759.32 | 72 | 59 | 59C
C105694 | CIA | 22008 | 72 | 55 | 55C
C105697 | CIA | 5193.65 | 72 | 59 | 6C
C106493 | CIA | 384.9 | 72 | 55 | 9C
C269002 | CIA | 985.7 | 72 | 55 | 9C
C347220 | CIA | 1559.25 | 72 | 59 | 13C
C351451 | CIA | 2532.4 | 72 | 59 | 48C
C430102 | CIA | 179 | 72 | 55 | 60C
C512006 | CIA | 381.45 | 72 | 55 | 10C
C905445 | CIA | 1105 | 72 | 55 | 4C
C905448 | CIA | 146.4 | 72 | 55 | 4C
C905451 | CIA | 475 | 72 | 59 | 59C
C905459 | CIA | 1138.6 | 72 | 55 | 5C
C905467 | CIA | 529.5 | 72 | 59 | 48C
C905468 | CIA | 643.35 | 72 | 55 | 9C
C905479 | CIA | 443.5 | 72 | 55 | 9C
C905484 | CIA | 346 | 72 | 55 | 9C
C905486 | CIA | 523 | 72 | 55 | 4C
C905487 | CIA | 537.95 | 72 | 55 | 4C
C905502 | CIA | 1034 | 72 | 59 | 6C
C905503 | CIA | 234.6 | 72 | 59 | 13C
C905506 | CIA | 4641.7 | 72 | 55 | 9C
C905519 | CIA | 222.5 | 72 | 55 | 60C
C905541 | CIA | 569 | 72 | 55 | 11C
C905544 | CIA | 679.15 | 72 | 59 | 6C
C905547 | CIA | 471.15 | 72 | 55 | 4C
C905549 | CIA | 1112.3 | 72 | 59 | 6C
C905555 | CIA | 544.7 | 72 | 55 | 10C
C905556 | CIA | 1473.2 | 72 | 59 | 6C
C905568 | CIA | 1172 | 72 | 59 | 13C
C905569 | CIA | 446.5 | 72 | 59 | 6C
C905575 | CIA | 13451.65 | 72 | 55 | 4C
C905583 | CIA | 577.7 | 72 | 59 | 12C
C905590 | CIA | 2277.22 | 72 | 55 | 55C
C905594 | CIA | 1173 | 72 | 55 | 9C
C905608 | CIA | 581 | 72 | 55 | 55C
C905623 | CIA | 2393.5 | 72 | 59 | 6C
C905627 | CIA | 294.55 | 72 | 55 | 9C
C905629 | CIA | 974.45 | 72 | 55 | 4C
C905631 | CIA | 250.2 | 72 | 59 | 48C
C905638 | CIA | 1244 | 72 | 59 | 48C
C905649 | CIA | 270 | 72 | 59 | 6C
C905652 | CIA | 73 | 72 | 55 | 2C
C905653 | CIA | 1000.5 | 72 | 55 | 5C
C905657 | CIA | 469.75 | 72 | 55 | 5C
C905660 | CIA | 905.25 | 72 | 59 | 48C
C905672 | CIA | 1996.65 | 72 | 59 | 48C
C905683 | CIA | 273.6 | 72 | 55 | 60C
C905685 | CIA | 128 | 72 | 55 | 11C
C905690 | CIA | 145.5 | 72 | 59 | 9C
C905692 | CIA | 299.8 | 72 | 55 | 5C
C905693 | CIA | 561.75 | 72 | 55 | 10C
C905695 | CIA | 56 | 72 | 59 | 59C
C905696 | CIA | 8107 | 72 | 59 | 59
C905698 | CIA | 65631.5 | 72 | 59 | 6C
C905707 | CIA | 330 | 72 | 55 | 5C
C905716 | CIA | 154.5 | 72 | 55 | 4C
C905719 | CIA | 661 | 72 | 55 | 4C
C905721 | CIA | 266.55 | 72 | 59 | 48C
C905723 | CIA | 4089.29 | 72 | 55 | 72