Spreadsheet: 62274d1263247046-pull-every-instance-index-match-criteria-into-consecutive-rows-directors-intervention-report-template
Sheet: VLOOKUP

 |  |  |  | sub subtype lookup |  | status lookup |  | Level Lookup |  |  | Attendance lookup
 |  | 2 | 0 | 0 | None | 0 |  | 0 | N/A |  | 0 | Please Select
 |  | 3 | 1 | 1 | Detention: Assignment Log | 1 | Please Select | 2 | 0 |  | 1 | Absences ARE NOT affecting student's performance
 |  | 4 | 2 | 2 | Detention: Behavioral | 2 | Pending | 3 | 1 |  | 2 | Absences ARE affecting student's performance
0 | n/a | 6 | 4 | 3 | Detention: Organization | 3 | Active | 4 | 2 |  | 3 | Tardies ARE NOT affecting student's performance
1 | n/a | 7 | 5 | 5 | Make-Up: Consequence | 4 | Complete | 6 | 4 |  | 4 | Tardies ARE affecting student's performance
2 | Pending |  |  | 6 | Make-Up: Supplemental |  |  | 7 | 5 |  | MS ATTENDANCE
3 | Active |  |  | 7 | Academics |  |  |  |  |  | Unexcused | Excused | T1 | T2 | CS1 | CS2
4 | Complete |  |  | 8 | Attendance |  |  |  |  |  |  |  |  |  |  |  | Regular Session
 |  |  |  | 9 | Behavior |  |  |  |  |  |  |  |  |  |  |  | Make-Up Session
outreach sch |  |  |  | 10 | Family |  |  |  |  |  |  |  |  |  |  |  | Support Session
0 | n/a |  |  | 11 | Student Snapshot: Academic Strength
1 | n/a |  |  | 12 | Student Snapshot: Academic Need |  |  |  |  |  |  |  |  |  |  |  | Supplemental Session
2 | Completed |  |  | 13 | Student Snapshot: Performance Strength |  |  |  |  |  |  |  |  |  |  |  | Regular Session
3 | Rescheduled |  |  | 14 | Student Snapshot: Performance Need |  |  |  |  |  |  |  |  |  |  |  | Make-Up Session
4 | Cancelled |  |  | 15 | Student Snapshot: Tutoring Strategies |  |  |  |  |  |  |  |  |  |  |  | Support Session
 |  |  |  | 16 | Student Snapshot: Other |  |  |  |  |  |  |  |  |  |  |  | Supplemental Session
Review Status |  |  |  | 17 | Scholarship: Reduce |  |  |  |  |  |  |  |  |  |  |  | Regular Session
0 | n/a |  |  | 18 | Scholarship: Termination
1 | Pending |  |  | 19 | Scholarship: Reinstatement |  |  |  |  |  |  |  |  |  |  |  | Make-Up Session
2 | Successfully Completed |  |  | 20 | [NAME]
3 | Didn't [NAME] |  |  | 21 | Dismissal Voluntary: [NAME] |  |  |  |  |  |  |  |  |  |  |  | Support Session
4 | Progress made, but incomplete |  |  | 22 | Dismissal Voluntary: Not [NAME] |  |  |  |  |  |  |  |  |  |  |  | Supplemental Session
5 | Agreements Revised |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Regular Session
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Make-Up Session
CONTRACT For Success |  |  | Action VLOOKUP |  |  | Attendance lookup |  |  |  |  |  |  |  |  |  |  | Support Session
 |  |  |  | No |  | 0 | Please Select |  |  |  |  |  |  |  |  |  | Supplemental Session
09-Cont. For Success |  |  | 0 | No |  | 1 | Absences ARE NOT affecting student's performance
 |  |  | 1 | Please Select |  | 2 | Absences ARE affecting student's performance
IPP |  |  | 2 | Yes --- Pending |  | 3 | Tardies ARE NOT affecting student's performance
 |  |  | 3 | Yes --- Active |  | 4 | Tardies ARE affecting student's performance
10-IPP |  |  | 4 | Yes --- Complete
Probationary Contract
14-Probat. Contract
SAP
01-Wave-Maker Goals
HIDE THESE ROWS (E-N)!!!
 |  |  |  | sub subtype lookup |  | status lookup |  | Level Lookup
 |  | 2 | 0 | 0 | None | 0 |  | 0 | N/A
 |  | 3 | 1 | 1 | Detention: Assignment Log | 1 | Please Select | 2 | 0
 |  | 4 | 2 | 2 | Detention: Behavioral | 2 | Pending | 3 | 1
0 | n/a | 6 | 4 | 3 | Detention: Organization | 3 | Active | 4 | 2
1 | n/a | 7 | 5 | 5 | Make-Up: Consequence | 4 | Complete | 6 | 4
2 | Pending |  |  | 6 | Make-Up: Supplemental |  |  | 7 | 5
3 | Active |  |  | 7 | Academics
4 | Complete |  |  | 8 | Attendance
 |  |  |  | 9 | Behavior
outreach sch |  |  |  | 10 | Family
0 | n/a |  |  | 11 | Student Snapshot: Academic Strength
1 | n/a |  |  | 12 | Student Snapshot: Academic Need
2 | Completed |  |  | 13 | Student Snapshot: Performance Strength
3 | Rescheduled |  |  | 14 | Student Snapshot: Performance Need
4 | Cancelled |  |  | 15 | Student Snapshot: Tutoring Strategies
 |  |  |  | 16 | Student Snapshot: Other
Review Status |  |  |  | 17 | Scholarship: Reduce
0 | n/a |  |  | 18 | Scholarship: Termination
1 | Pending |  |  | 19 | Scholarship: Reinstatement
2 | Successfully Completed |  |  | 20 | [NAME]
3 | Didn't [NAME] |  |  | 21 | Dismissal Voluntary: [NAME]
4 | Progress made, but incomplete |  |  | 22 | Dismissal Voluntary: Not [NAME]
5 | Agreements Revised