Spreadsheet: 120609d1315406389-excel-2007-combining-if-and-vlookup-in-a-formula-sample-excel-report
Sheet: Balances

Capture Date | Name | 1st Leave Code (Custom) | 1st Leave Code Balance | 2nd Leave Code (Custom) | 2nd Leave Code Balance | 3rd Leave Code (Custom) | 3rd Leave Code Balance | 4th Leave Code (Custom) | 4th Leave Code Balance | 5th Leve Code (Custom) | 5th Leave Code Balance | 6th Leave Code (Custom) | 6th Leave Code Balance | 7th Leave Code (Custom) | 7th Leave Code Balance
2011-06-30 00:00:00 | ABPLANALP, [NAME] | [NAME] | 108 | Personal Leave | 1.5 | [NAME] | 142 | Prof Leave | -7 | Other Leave | 0 |  | 0 |  | 0
2011-06-30 00:00:00 | ADAMS, [NAME]. | [NAME] | 28 | Personal Leave | 0 | [NAME] | 108 | Prof Leave | 0 | Other Leave | 0 |  | 0 |  | 0
2011-06-30 00:00:00 | AGIN, RICHARD | [NAME] | 20.5 | Personal Leave | 4 | [NAME] | 96 | Prof Leave | -8.5 | Other Leave | 0 |  | 0 |  | 0
2011-06-30 00:00:00 | AIDEN, [NAME] | [NAME] | 63.5 | Personal Leave | 0 | Vacation Leave | 0 | Prof Leave | -4 | Other Leave | 0 | Vacation Leave | 0 | [NAME] | 115
2011-06-30 00:00:00 | AIDEN, [NAME] | [NAME] | 81 | Personal Leave | 4 | Vacation Leave | 0 | Other Leave | 0 | Prof Leave | 0 |  | 0 |  | 0
2011-06-30 00:00:00 | AIDEN, [NAME] | [NAME] | 38.5 | Personal Leave | 3 | Vacation Leave | 15 | Vacation Leave | 9 | [NAME] | 108 | Prof Leave | 0 | Prof Leave | 0
2011-06-30 00:00:00 | AKINRINADE, CHANNING M. | [NAME] | 5 | Personal Leave | 1 | [NAME] | 147 | Prof Leave | -3 | Other Leave | 0 |  | 0 |  | 0
2011-06-30 00:00:00 | ALEBIOSU, ABDUL-RAZAK A. | [NAME] | 157.5 | Vacation Leave | 0 | Personal Leave | 0 | Other Leave | 0 | Prof Leave | 0 |  | 0 |  | 0
2011-06-30 00:00:00 | ALEBIOSU, [NAME] | [NAME] | 263.25 | Personal Leave | 4 | [NAME] | 197 | Prof Leave | 0 | Other Leave | 0 |  | 0 |  | 0
2011-06-30 00:00:00 | ALEXANDER, RICHARD III | [NAME] | 1 | Vacation Leave | 0 | Personal Leave | 0 | Prof Leave | 0 | Other Leave | 0 | Vacation Leave | 0 | [NAME] | 105
2011-06-30 00:00:00 | ALILE, BRIGHT | [NAME] | 75 | Personal Leave | 4 | Vacation Leave | 11.5 | Prof Leave | 0 | Other Leave | 0 | Vacation Leave | 0 | [NAME] | 110
2011-06-30 00:00:00 | ALLEN, [NAME] | [NAME] | 144 | Personal Leave | 2 | [NAME] | 176.5 | Prof Leave | -4 | Other Leave | 0 |  | 0 |  | 0
2011-06-30 00:00:00 | AMAKER, ALANA J. | [NAME] | 26.75 | Personal Leave | 0 | [NAME] | 91 | Prof Leave | -1.5 | Other Leave | -1 |  | 0 |  | 0
2011-06-30 00:00:00 | [NAME], [NAME] | [NAME] | 62.75 | Personal Leave | 1 | [NAME] | 132 | Other Leave | -1 | Prof Leave | 0 |  | 0 |  | 0
2011-06-30 00:00:00 | ANDRE, MARJORIE ANN | [NAME] | 33 | Personal Leave | 0 | Vacation Leave | 5 | Prof Leave | 0 | Other Leave | 0 | Vacation Leave | 0 | [NAME] | 104.5
2011-06-30 00:00:00 | ARCENEAUX, [NAME] | [NAME] | 6.5 | Vacation Leave | 2 | Personal Leave | 0 | [NAME] | 135 | Vacation Leave | 0 | Other Leave | 0 | Prof Leave | -2
2011-06-30 00:00:00 | AREY, [NAME] | [NAME] | 19 | Personal Leave | 4 | [NAME] | 96 | Prof Leave | -37.5 | Other Leave | 0 |  | 0 |  | 0
2011-06-30 00:00:00 | [NAME], ANTHONY | [NAME] | 1 | Personal Leave | 0 | [NAME] | 108 | Vacation Leave | 10 | Vacation Leave | 0.5 | Prof Leave | 0 | Prof Leave | 0
2011-06-30 00:00:00 | BUTLER, ANTOINETTE J. | [NAME] | 4.5 | Personal Leave | 0 | [NAME] | 95 | Prof Leave | 0 | Other Leave | 0 |  | 0 |  | 0
2011-06-30 00:00:00 | CABEY, CARROL A. | [NAME] | 2 | Personal Leave | 0 | Other Leave | 0 | Prof Leave | 0 |  | 0 |  | 0 |  | 0
2011-06-30 00:00:00 | CADET, GUADALUPE M. | [NAME] | 5 | Vacation Leave | 0 | Personal Leave | 2 | Other Leave | 0 | Prof Leave | 0 |  | 0 |  | 0
2011-06-30 00:00:00 | CALIXTE, FRANZ | [NAME] | 87.5 | Personal Leave | 4 | [NAME] | 157 | Prof Leave | -15.5 | Other Leave | 0 |  | 0 |  | 0
2011-06-30 00:00:00 | CAMPBELL, MARCUS A. | [NAME] | 38.5 | Personal Leave | 2 | [NAME] | 132 | Prof Leave | -9.5 | Other Leave | 0 | Vacation Leave | 3 | Vacation Leave | 0
2011-06-30 00:00:00 | CAMPBELL, TOYA D. | [NAME] | 45.5 | Vacation Leave | 0 | Personal Leave | 1 | [NAME] | 132 | Vacation Leave | 0 | Prof Leave | -11 | Prof Leave | 0
2011-06-30 00:00:00 | CAMPOS, [NAME] | [NAME] | 17.5 | Personal Leave | 2.5 | [NAME] | 112 | Prof Leave | -10.5 | Other Leave | 0 |  | 0 |  | 0
2011-06-30 00:00:00 | CANCHOLA, ARACELY | Personal Leave | 1.5 | Prof Leave | -8.5 | [NAME] | 7 | [NAME] | 83 | Other Leave | 0 |  | 0 |  | 0
2011-06-30 00:00:00 | CARDIS, [NAME] | [NAME] | 6.5 | Personal Leave | 1.5 | [NAME] | 58 | Prof Leave | -6.5 | Other Leave | 0 |  | 0 |  | 0
2011-06-30 00:00:00 | CARNEY, [NAME] | [NAME] | 98 | Personal Leave | 3 |  | 0 | [NAME] | 115 | Prof Leave | -2.5 | Other Leave | -1 |  | 0