Spreadsheet: 84629d1284655711-excel-2007-lookup-vlookup-using-two-lookup-values-test-sheet
Sheet: CHARGE REPORT PIVOT TABLE

Sum of Charge Value
Customer | Business Line | Total
102000 | DW | -12.72
 | FW | -108.82 |  |  |  |  | RETURN THESE VALUES INTO THE "SALES" TAB, IN THE "CHARGES" COLUMN, BY BUSINESS LINE.
 | GAD | -848.06
102000 Total |  | -969.5999999999999
103058 | GAD | -400.15
103058 Total |  | -400.15
103060 | GAD | 0.01
103060 Total |  | 0.01
103070 | GAD | -235.77
103070 Total |  | -235.77
103510 | FW | 111.74
 | GAD | -2.25
103510 Total |  | 109.49
103555 | FW | -1161
 | GAD | -2679.37
103555 Total |  | -3840.37
103643 | FW | 51.72
103643 Total |  | 51.72
103651 | GAD | -1060.2
103651 Total |  | -1060.2
103736 | GAD | 0
103736 Total |  | 0
103738 | GAD | -12.67
103738 Total |  | -12.67
104103 | FW | 50.05
104103 Total |  | 50.05
104106 | GAD | -19.5
104106 Total |  | -19.5
104251 | FW | 10.79
104251 Total |  | 10.79
104368 | GAD | -702
104368 Total |  | -702
104720 | GAD | -95.2
104720 Total |  | -95.2
105196 | GAD | -7.5
105196 Total |  | -7.5
105201 | FW | 21.9
105201 Total |  | 21.9
105503 | FW | 14.95
105503 Total |  | 14.95
105594 | GAD | -39.3
105594 Total |  | -39.3
106079 | GAD | -12883.76
106079 Total |  | -12883.76
106304 | FW | 14.01
106304 Total |  | 14.01
106575 | FW | -71.1
106575 Total |  | -71.1
107351 | GAD | -8801.94
107351 Total |  | -8801.94
204999 | GAD | -3861.4
204999 Total |  | -3861.4
212501 | GAD | -745.54
212501 Total |  | -745.54
212502 | GAD | 6.65
212502 Total |  | 6.65
214151 | FW | 18.79
214151 Total |  | 18.79
236234 | FW | 41.77
236234 Total |  | 41.77
242010 | FW | 5.94
242010 Total |  | 5.94
244601 | FW | 31.35
244601 Total |  | 31.35
245602 | GAD | -2877.6
245602 Total |  | -2877.6
245650 | GAD | -71.93
245650 Total |  | -71.93
255549 | GAD | -945.25
255549 Total |  | -945.25
286499 | GAD | -123.9
286499 Total |  | -123.9
292840 | FW | 42.05
 | GAD | -1240.89
292840 Total |  | -1198.84
301875 | FW | 68.13
301875 Total |  | 68.13
305520 | FW | 34.18
305520 Total |  | 34.18
308001 | GAD | -36
308001 Total |  | -36
309715 | GAD | -3673.39
309715 Total |  | -3673.39
309804 | FW | 43.25
309804 Total |  | 43.25
309807 | FW | 22.16
309807 Total |  | 22.16
309812 | FW | 7.2
309812 Total |  | 7.2
319551 | GAD | -734.98
319551 Total |  | -734.98
322649 | FW | 24.72
322649 Total |  | 24.72
322650 | FW | 55.54
 | GAD | -34.22
322650 Total |  | 21.32
342287 | CIA | 0.05
 | GAD | -1625
342287 Total |  | -1624.95
346421 | FW | 39.6
346421 Total |  | 39.6
351454 | FW | -43
351454 Total |  | -43
356100 | GAD | -1190.39
356100 Total |  | -1190.39
356992 | FW | -16.08
 | GAD | -56.16
356992 Total |  | -72.24
367004 | GAD | -3644.15
367004 Total |  | -3644.15
372001 | FW | 6.05
372001 Total |  | 6.05
374004 | GAD | -131.88
374004 Total |  | -131.88
384300 | GAD | -26.35
384300 Total |  | -26.35
384430 | FW | -7.56
384430 Total |  | -7.56
409203 | GAD | -10.38
409203 Total |  | -10.38
409300 | GAD | -877.64
409300 Total |  | -877.64
409800 | GAD | 0
409800 Total |  | 0
412200 | GAD | -894.86
412200 Total |  | -894.86
412201 | GAD | -65.12
412201 Total |  | -65.12
421957 | FW | -33.5
421957 Total |  | -33.5
421959 | GAD | -25.5
421959 Total |  | -25.5
434001 | FW | 10.86
434001 Total |  | 10.86
434002 | FW | 25.47
434002 Total |  | 25.47
459007 | FW | 270.46
459007 Total |  | 270.46
465000 | GAD | -423.15
465000 Total |  | -423.15
469990 | GAD | -684.78
469990 Total |  | -684.78
481365 | GAD | -5
481365 Total |  | -5
481366 | FW | 35.92
481366 Total |  | 35.92
487600 | FW | -18177.51
 | GAD | -69481.56000000001
487600 Total |  | -87659.07
501500 | GAD | -59.4
501500 Total |  | -59.4
514549DI | GAD | -250
514549DI Total |  | -250
514551DI | FW | -3707.39
 | GAD | -331
514551DI Total |  | -4038.39
800001 | GAD | 31.59
800001 Total |  | 31.59
900152 | GAD | 375
900152 Total |  | 375
905443 | GAD | -269.52
905443 Total |  | -269.52
905636 | FW | 80.36
905636 Total |  | 80.36
C00001 | FW | 238.19
 | GAD | 29.68
C00001 Total |  | 267.87
C105197 | CIA | -323.85
 | GAD | -335.4
C105197 Total |  | -659.25
C105427 | CIA | -17.25
 | FW | 59.3
C105427 Total |  | 42.05
C105692 | CIA | -18
 | FW | 8.85
C105692 Total |  | -9.15
C105693 | FW | 150.99
C105693 Total |  | 150.99
C105694 | FW | 499.94
C105694 Total |  | 499.94
C106099 | GAD | 1016.4
C106099 Total |  | 1016.4
C106493 | FW | 20.98
C106493 Total |  | 20.98
C217012 | CIA | -62.33
C217012 Total |  | -62.33
C430102 | FW | 5.73
 | GAD | -8.95
C430102 Total |  | -3.219999999999999
C512006 | FW | 19.32
C512006 Total |  | 19.32
C905448 | FW | 9.64
C905448 Total |  | 9.64
C905451 | FW | 25.2
C905451 Total |  | 25.2
[NAME] | CIA | -23.13
C905457 Total |  | -23.13
C905467 | FW | 45.12
 | GAD | -26.48
C905467 Total |  | 18.64
C905468 | FW | 51.58
C905468 Total |  | 51.58
C905479 | FW | 21.28
 | GAD | -22.18
C905479 Total |  | -0.8999999999999986
C905484 | FW | 7.59
C905484 Total |  | 7.59
C905486 | FW | 34.79
 | GAD | -26.15
C905486 Total |  | 8.64
C905487 | FW | 33.75
C905487 Total |  | 33.75
C905503 | FW | 5.94
C905503 Total |  | 5.94
C905519 | FW | 5.73
C905519 Total |  | 5.73
C905541 | FW | 18.91
C905541 Total |  | 18.91
C905544 | FW | 30.39
C905544 Total |  | 30.39
C905549 | GAD | -55.62
C905549 Total |  | -55.62
C905555 | FW | 30.07
C905555 Total |  | 30.07
C905559 | GAD | -797.8
C905559 Total |  | -797.8
C905569 | FW | 11.19
C905569 Total |  | 11.19
C905570 | CIA | -182.74
 | GAD | -20
C905570 Total |  | -202.74
C905583 | FW | 11.69
 | GAD | -74.45
C905583 Total |  | -62.76000000000001
C905594 | FW | 9.56
C905594 Total |  | 9.56
C905608 | FW | 20.36
C905608 Total |  | 20.36
C905623 | FW | 62.69
 | GAD | -50.21
C905623 Total |  | 12.48
C905627 | FW | 21.95
C905627 Total |  | 21.95
C905631 | FW | 6.05
C905631 Total |  | 6.05
C905633 | CIA | -117.6
C905633 Total |  | -117.6
C905638 | FW | 19.36
C905638 Total |  | 19.36
C905649 | FW | 7.67
C905649 Total |  | 7.67
C905652 | FW | 5.9
C905652 Total |  | 5.9
C905657 | FW | 15.25
C905657 Total |  | 15.25
C905660 | FW | 5.46
C905660 Total |  | 5.46
C905672 | FW | 19.49
C905672 Total |  | 19.49
C905683 | FW | 10.52
C905683 Total |  | 10.52
C905685 | FW | 7.24
C905685 Total |  | 7.24
C905691 | GAD | -3352.81
C905691 Total |  | -3352.81
C905692 | FW | 16.12
C905692 Total |  | 16.12
C905693 | FW | 24.33
C905693 Total |  | 24.33
C905695 | FW | 4.82
C905695 Total |  | 4.82
C905698 | CIA | -24311.5
C905698 Total |  | -24311.5
C905716 | FW | 10.95
C905716 Total |  | 10.95
C905719 | FW | 41.24
C905719 Total |  | 41.24
C905721 | FW | 6.19
C905721 Total |  | 6.19
Grand Total |  | -171090.08