Spreadsheet: 120090d1314971593-vlookup-loop-until-data-found-tracker-example
Sheet: Data

ID | Name | Date | Total Infraction | Corrective Action Infraction Count | Reason | Comments |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reason Codes
92497 |  | 2011-07-26 00:00:00 | 1 | 0 | Updated Balance at Level 1 (per TM) | Level 1 delivered 11/27/10 non attendance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Day Call Out - NTA
11742 |  | 2011-07-26 00:00:00 | 1 |  | Updated Balance (per TM) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Half Day Call Out - NTA
98480 | XXXX | 2011-07-26 00:00:00 | 0.25 |  | Updated Balance (per TM) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tardy - NTA
86763 | XXXX | 2011-07-26 00:00:00 | 5.25 | 3.25 | Updated Balance at Level 1 (per TM) | Level 1 delivered 11/16/10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Updated Balance at Level 1 (per TM)
32982 | XXXX | 2011-07-26 00:00:00 | 2 |  | Updated Balance (per TM) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Updated Balance at Level 2 (per TM)
25834 | XXXX | 2011-07-26 00:00:00 | 4.5 | 3 | Updated Balance at Level 1 (per TM) | Level 1 delivered 02/01/11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Updated Balance at Level 3 (per TM)
18308 | XXXX | 2011-07-27 00:00:00 | 3 |  | Updated Balance at Level 1 (per TM)
22270 | XXXX | 2011-07-26 00:00:00 | 2.5 |  | Updated Balance (per TM)
25847 | XXXX | 2011-07-26 00:00:00 | 6.25 | 3.75 | Updated Balance at Level 1 (per TM) | Level 1 delivered 01/13/11
25772 | XXXX | 2011-07-26 00:00:00 | 2 |  | Updated Balance (per TM)
25773 | XXXX | 2011-07-26 00:00:00 | 2.25 |  | Updated Balance (per TM)
25841 | XXXX | 2011-07-26 00:00:00 | 4.5 | 4.25 | Updated Balance at Level 1 (per TM) | Level 1 delivered 02/14/11
11730 | XXXX | 2011-07-26 00:00:00 | 0 | 0 | Updated Balance at Level 2 (per TM) | Level 2 delivered 12/29/10 non-attendance
86777 | XXXX | 2011-07-26 00:00:00 | 10.75 | 8.75 | Updated Balance to Level 2 (per TM) | Level 2 delivered 03/22/11
11734 | XXXX | 2011-07-26 00:00:00 | 4 | 3.25 | Updated Balance at Level 1 (per TM) | Level 1 delivered 10/26/10
25842 | XXXX | 2011-07-26 00:00:00 | 1.75 |  | Updated Balance (per TM)
25872 | XXXX | 2011-07-26 00:00:00 | 7.75 | 7.75 | Updated Balance at Level 2 (per TM) | Level 2 delivered 03/07/11
18380 | XXXX | 2011-07-26 00:00:00 | 3.25 |  | Updated Balance (per TM)
98485 | XXXX | 2011-07-26 00:00:00 | 7.25 | 7.25 | Updated Balance at Level 2 (per TM) | Level 2 delivered 01/28/11
97324 | XXXX | 2011-07-26 00:00:00 | 2.75 |  | Updated Balance (per TM)
18310 | XXXX | 2011-07-26 00:00:00 | 1.5 |  | Updated Balance (per TM)
25840 | XXXX | 2011-07-26 00:00:00 | 0.75 |  | Updated Balance (per TM)
86186 | XXXX | 2011-07-26 00:00:00 | 3.25 | 3.25 | Updated Balance at Level 1 (per TM) | Level 1 delivered 02/22/11
32957 | XXXX | 2011-07-26 00:00:00 | 3 | 3 | Updated Balance at Level 1 (per TM) | Level 1 delivered 05/19/11
86676 | XXXX | 2011-07-26 00:00:00 | 2 |  | Updated Balance (per TM)
19011 | XXXX | 2011-07-26 00:00:00 | 0.75 | 0 | Updated Balance (per TM) | Level 3 delivered 10/04/10 non-attendance
32589 | XXXX | 2011-07-26 00:00:00 | 1.5 |  | Updated Balance (per TM)
98484 | XXXX | 2011-07-26 00:00:00 | 4 | 3 | Updated Balance at Level 1 (per TM) | Level 1 delivered 03/10/11
92856 | XXXX | 2011-07-26 00:00:00 | 0.75 |  | Updated Balance (per TM)
55272 | XXXX | 2011-07-26 00:00:00 | 1.25 |  | Updated Balance (per TM)
99407 | XXXX | 2011-07-26 00:00:00 | 1 |  | Updated Balance (per TM)
25856 | XXXX | 2011-07-26 00:00:00 | 6.75 | 6.75 | Updated Balance at Level 2 (per TM) | Level 2 delivered 03/08/11
33271 | XXXX | 2011-07-26 00:00:00 | 0.25 |  | Updated Balance (per TM)
99434 | XXXX | 2011-07-26 00:00:00 | 2.5 |  | Updated Balance (per TM)
33216 | XXXX | 2011-07-26 00:00:00 | 1.25 |  | Updated Balance (per TM)
22274 | XXXX | 2011-07-26 00:00:00 | 1.25 |  | Updated Balance (per TM)
33214 | XXXX | 2011-07-26 00:00:00 | 1 |  | Updated Balance (per TM)
32836 | XXXX | 2011-07-26 00:00:00 | 3 |  | Updated Balance (per TM)
22209 | XXXX | 2011-07-26 00:00:00 | 2.75 |  | Updated Balance (per TM)
86198 | XXXX | 2011-07-26 00:00:00 | 2.5 |  | Updated Balance (per TM)
25829 | XXXX | 2011-07-26 00:00:00 | 2.75 |  | Updated Balance (per TM)
25839 | XXXX | 2011-07-26 00:00:00 | 3.5 | 3 | Updated Balance at Level 1 (per TM) | Level 1 delivered 02/17/11
32975 | XXXX | 2011-07-26 00:00:00 | 1.75 |  | Updated Balance (per TM)
25827 | XXXX | 2011-07-26 00:00:00 | 2 |  | Updated Balance (per TM)
32692 | XXXX | 2011-07-26 00:00:00 | 0.75 |  | Updated Balance (per TM)
32830 | XXXX | 2011-07-26 00:00:00 | 3.75 | 3.75 | Updated Balance at Level 1 (per TM) | Level 1 delivered 06/14/11
98497 | XXXX | 2011-07-26 00:00:00 | 12 | 12 | Updated Balance at Level 3 (per TM) | Level 3 delivered 07/22/11
25849 | XXXX | 2011-07-26 00:00:00 | 2.75 |  | Updated Balance (per TM)
32587 | XXXX | 2011-07-26 00:00:00 | 0.5 |  | Updated Balance (per TM)
25843 | XXXX | 2011-07-26 00:00:00 | 4.5 | 3.5 | Updated Balance at Level 1 (per TM) | Level 1 delivered 01/03/11
32843 | XXXX | 2011-07-26 00:00:00 | 1.75 |  | Updated Balance (per TM)
25852 | XXXX | 2011-07-26 00:00:00 | 9.25 | 9.25 | Updated Balance at Level 3 (per TM) | Level 3 delivered 03/02/11
99413 | XXXX | 2011-07-26 00:00:00 | 3 | 3 | Updated Balance at Level 1 (per TM) | Level 1 delivered 01/12/11
22293 | XXXX | 2011-07-26 00:00:00 | 2.5 |  | Updated Balance (per TM)
86764 | XXXX | 2011-07-26 00:00:00 | 1.75 |  | Updated Balance (per TM)
11726 | XXXX | 2011-07-26 00:00:00 | 2.25 |  | Updated Balance (per TM)
86682 | XXXX | 2011-07-26 00:00:00 | 2.25 | 2.25 | Updated Balance at Level 1 (per TM) | Level 1 delivered 01/06/11
97276 | XXXX | 2011-07-26 00:00:00 | 2.5 |  | Updated Balance (per TM)
98489 | XXXX | 2011-07-26 00:00:00 | 1.5 |  | Updated Balance (per TM)
11727 | XXXX | 2011-07-26 00:00:00 | 2 | 0.5 | Updated Balance at Level 3 (per TM) | Level 3 delivered 11/01/10 non-attendance
99416 | XXXX | 2011-07-26 00:00:00 | 1.75 |  | Updated Balance (per TM)
25831 | XXXX | 2011-07-26 00:00:00 | 1 |  | Updated Balance (per TM)
99439 | XXXX | 2011-07-26 00:00:00 | 4 | 4 | Updated Balance at Level 1 (per TM) | Level 1 delivered 07/12/11
91464 | XXXX | 2011-07-26 00:00:00 | 1 |  | Updated Balance (per TM)
98487 | XXXX | 2011-07-26 00:00:00 | 3 | 3 | Updated Balance at Level 1 (per TM) | Level 1 delivered 10/05/10
86667 | XXXX | 2011-07-26 00:00:00 | 1.5 |  | Updated Balance (per TM)
86684 | XXXX | 2011-07-26 00:00:00 | 2 | 0 | Updated Balance (per TM) | Level 2 delivered 07/05/11 non attendace
11754 | XXXX | 2011-07-26 00:00:00 | 7.75 | 7 | Updated Balance at Level 2 (per TM) | Level 2 delivered 01/26/11
86186 | XXXX | 2011-07-28 00:00:00 | 1 |  | Full Day Call Out - NTA
99416 | XXXX | 2011-07-28 00:00:00 | 1 |  | Full Day Call Out - NTA
22270 | XXXX | 2011-07-21 00:00:00 | 0.5 |  | Half Day Call Out - NTA
22270 | XXXX | 2011-07-22 00:00:00 | 1 |  | Full Day Call Out - NTA
11734 | XXXX | 2011-07-28 00:00:00 | 1 |  | Full Day Call Out - NTA
32843 | XXXX | 2011-07-29 00:00:00 | 1 |  | Full Day Call Out - NTA
99439 | XXXX | 2011-07-29 00:00:00 | 0.5 |  | Half Day Call Out - NTA
32830 | XXXX | 2011-08-04 00:00:00 | 0.25 |  | Partial Day Call Out - NTA
99407 | XXXX | 2011-08-08 00:00:00 | 0.5 |  | Half Day Call Out - NTA
86763 | XXXX | 2011-08-12 00:00:00 | 0.5 |  | Half Day Call Out - NTA
98491 | XXXX | 2011-08-12 00:00:00 | 1 |  | Full Day Call Out - NTA
18380 | XXXX | 2011-08-11 00:00:00 | 0.5 |  | Half Day Call Out - NTA
86763 | XXXX | 2011-08-13 00:00:00 | 1 |  | Full Day Call Out - NTA
32692 | XXXX | 2011-08-10 00:00:00 |  | 0.75 |  | Level 1 delivered 8/10/11
11726 | XXXX | 2011-08-14 00:00:00 | 0.25 |  | Tardy -NTA
98497 | XXXX | 2011-08-17 00:00:00 | 1 |  | Full Day Call Out - NTA
98491 | XXXX | 2011-08-15 00:00:00 | 1 |  | Full Day Call Out - NTA
98491 | XXXX | 2011-08-17 00:00:00 | 1 |  | Full Day Call Out - NTA
86763 | XXXX | 2011-08-16 00:00:00 | 1 |  | Full Day Call Out - NTA
86763 | XXXX | 2011-08-19 00:00:00 | 1 |  | Full Day Call Out - NTA
46490 | XXXX | 2011-08-17 00:00:00 | 0.25 |  | Tardy -NTA
46482 | XXXX | 2011-08-08 00:00:00 | 0.25 |  | Tardy -NTA
46494 | XXXX | 2011-08-08 00:00:00 | 0.25 |  | Tardy -NTA
46494 | XXXX | 2011-08-21 00:00:00 | 1 |  | Full Day Call Out - NTA
86777 | XXXX | 2011-08-18 00:00:00 | 1 |  | Full Day Call Out - NTA
98491 | XXXX | 2011-08-22 00:00:00 | 1 |  | Full Day Call Out - NTA
86763 | XXXX | 2011-08-25 00:00:00 | 1 |  | Full Day Call Out - NTA
98487 | XXXX | 2011-08-25 00:00:00 | 0.25 |  | Tardy -NTA
86186 | XXXX | 2011-08-26 00:00:00 | 0.5 |  | Half Day Call Out - NTA
86763 | XXXX | 2011-08-29 00:00:00 | 0.5 |  | Partial Day Call Out - NTA
46495 | XXXX | 2011-08-29 00:00:00 | 0.25 |  | Tardy -NTA
86198 | XXXX | 2011-08-30 00:00:00 | 0.25 |  | Partial Day Call Out - NTA
97276 | XXXX | 2011-08-30 00:00:00 | 1 |  | Full Day Call Out - NTA
98491 | XXXX | 2011-08-31 00:00:00 |  | 4 |  | Level 1 delivered 08/31/11
18308 | XXXX | 2011-03-26 00:00:00 |  |  |  | Level 1 delivered 03/26/11
22270 | XXXX | 2011-08-04 00:00:00 |  | 4 |  | Level 1 delivered 08/04/11
32836 | XXXX | 2010-06-10 00:00:00 |  | 3 |  | Level 1 delivered 06/10/10
32692 | XXXX | 2011-08-10 00:00:00 |  | 0.75 |  | Level 1 delivered 8/10/11non-attendance