Spreadsheet: 704720d1605716677-possible-vlookup-testbadge-4-1-1-
Sheet: Sheet2

Name | EMP ID | Column3 | Date
Green, [NAME] | TAB0100914 | None | Sun |  | 2020-11-01 00:00:00
Green, [NAME] | TAB0100914 | Shift | Mon |  | 2020-11-02 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-02 00:00:00 | 2020-11-02 00:00:00 | Regular | 08:00:00 | 12:00:00 | 2020-11-02 00:00:00 | 4 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Green, [NAME] | TAB0100914 | Shift | Mon |  | 2020-11-02 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-02 00:00:00 | 2020-11-02 00:00:00 | Break | 12:00:00 | 13:00:00 | 2020-11-02 00:00:00 | 1 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Green, [NAME] | TAB0100914 | Shift | Mon |  | 2020-11-02 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-02 00:00:00 | 2020-11-02 00:00:00 | Regular | 13:00:00 | 17:00:00 | 2020-11-02 00:00:00 | 4 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Green, [NAME] | TAB0100914 | Shift | Tue |  | 2020-11-03 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-03 00:00:00 | 2020-11-03 00:00:00 | Regular | 08:00:00 | 12:00:00 | 2020-11-03 00:00:00 | 4 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Green, [NAME] | TAB0100914 | Shift | Tue |  | 2020-11-03 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-03 00:00:00 | 2020-11-03 00:00:00 | Break | 12:00:00 | 13:00:00 | 2020-11-03 00:00:00 | 1 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Green, [NAME] | TAB0100914 | Shift | Tue |  | 2020-11-03 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-03 00:00:00 | 2020-11-03 00:00:00 | Regular | 13:00:00 | 17:00:00 | 2020-11-03 00:00:00 | 4 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Green, [NAME] | TAB0100914 | Shift | Wed |  | 2020-11-04 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-04 00:00:00 | 2020-11-04 00:00:00 | Regular | 08:00:00 | 12:00:00 | 2020-11-04 00:00:00 | 4 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Green, [NAME] | TAB0100914 | Shift | Wed |  | 2020-11-04 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-04 00:00:00 | 2020-11-04 00:00:00 | Break | 12:00:00 | 13:00:00 | 2020-11-04 00:00:00 | 1 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Green, [NAME] | TAB0100914 | Shift | Wed |  | 2020-11-04 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-04 00:00:00 | 2020-11-04 00:00:00 | Regular | 13:00:00 | 17:00:00 | 2020-11-04 00:00:00 | 4 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Green, [NAME] | TAB0100914 | Shift | Thu |  | 2020-11-05 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-05 00:00:00 | 2020-11-05 00:00:00 | Regular | 08:00:00 | 12:00:00 | 2020-11-05 00:00:00 | 4 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Green, [NAME] | TAB0100914 | Shift | Thu |  | 2020-11-05 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-05 00:00:00 | 2020-11-05 00:00:00 | Break | 12:00:00 | 13:00:00 | 2020-11-05 00:00:00 | 1 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Green, [NAME] | TAB0100914 | Shift | Thu |  | 2020-11-05 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-05 00:00:00 | 2020-11-05 00:00:00 | Regular | 13:00:00 | 17:00:00 | 2020-11-05 00:00:00 | 4 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Green, [NAME] | TAB0100914 | Shift | Fri |  | 2020-11-06 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-06 00:00:00 | 2020-11-06 00:00:00 | Regular | 08:00:00 | 12:00:00 | 2020-11-06 00:00:00 | 4 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Green, [NAME] | TAB0100914 | Shift | Fri |  | 2020-11-06 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-06 00:00:00 | 2020-11-06 00:00:00 | Break | 12:00:00 | 13:00:00 | 2020-11-06 00:00:00 | 1 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Green, [NAME] | TAB0100914 | Shift | Fri |  | 2020-11-06 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-06 00:00:00 | 2020-11-06 00:00:00 | Regular | 13:00:00 | 17:00:00 | 2020-11-06 00:00:00 | 4 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Green, [NAME] | TAB0100914 | None | Sat |  | 2020-11-07 00:00:00
Green, [NAME] | TAB0100914 | None | Sun |  | 2020-11-08 00:00:00
Green, [NAME] | TAB0100914 | None | Sun |  | 2020-11-01 00:00:00
Doe, [NAME] | [NAME] | Shift | Mon |  | 2020-11-02 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-02 00:00:00 | 2020-11-02 00:00:00 | Regular | 08:00:00 | 12:00:00 | 2020-11-02 00:00:00 | 4 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Doe, [NAME] | [NAME] | Shift | Mon |  | 2020-11-02 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-02 00:00:00 | 2020-11-02 00:00:00 | Break | 12:00:00 | 13:00:00 | 2020-11-02 00:00:00 | 1 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Doe, [NAME] | [NAME] | Shift | Mon |  | 2020-11-02 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-02 00:00:00 | 2020-11-02 00:00:00 | Regular | 13:00:00 | 17:00:00 | 2020-11-02 00:00:00 | 4 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Doe, [NAME] | [NAME] | Shift | Tue |  | 2020-11-03 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-03 00:00:00 | 2020-11-03 00:00:00 | Regular | 08:00:00 | 12:00:00 | 2020-11-03 00:00:00 | 4 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Doe, [NAME] | [NAME] | Shift | Tue |  | 2020-11-03 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-03 00:00:00 | 2020-11-03 00:00:00 | Break | 12:00:00 | 13:00:00 | 2020-11-03 00:00:00 | 1 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Doe, [NAME] | [NAME] | Shift | Tue |  | 2020-11-03 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-03 00:00:00 | 2020-11-03 00:00:00 | Regular | 13:00:00 | 17:00:00 | 2020-11-03 00:00:00 | 4 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Doe, [NAME] | [NAME] | Shift | Wed |  | 2020-11-04 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-04 00:00:00 | 2020-11-04 00:00:00 | Regular | 08:00:00 | 12:00:00 | 2020-11-04 00:00:00 | 4 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Doe, [NAME] | [NAME] | Shift | Wed |  | 2020-11-04 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-04 00:00:00 | 2020-11-04 00:00:00 | Break | 12:00:00 | 13:00:00 | 2020-11-04 00:00:00 | 1 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Doe, [NAME] | [NAME] | Shift | Wed |  | 2020-11-04 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-04 00:00:00 | 2020-11-04 00:00:00 | Regular | 13:00:00 | 17:00:00 | 2020-11-04 00:00:00 | 4 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Doe, [NAME] | [NAME] | Shift | Thu |  | 2020-11-05 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-05 00:00:00 | 2020-11-05 00:00:00 | Regular | 08:00:00 | 12:00:00 | 2020-11-05 00:00:00 | 4 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Doe, [NAME] | [NAME] | Shift | Thu |  | 2020-11-05 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-05 00:00:00 | 2020-11-05 00:00:00 | Break | 12:00:00 | 13:00:00 | 2020-11-05 00:00:00 | 1 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Doe, [NAME] | [NAME] | Shift | Thu |  | 2020-11-05 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-05 00:00:00 | 2020-11-05 00:00:00 | Regular | 13:00:00 | 17:00:00 | 2020-11-05 00:00:00 | 4 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Doe, [NAME] | [NAME] | Shift | Fri |  | 2020-11-06 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-06 00:00:00 | 2020-11-06 00:00:00 | Regular | 08:00:00 | 12:00:00 | 2020-11-06 00:00:00 | 4 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Doe, [NAME] | [NAME] | Shift | Fri |  | 2020-11-06 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-06 00:00:00 | 2020-11-06 00:00:00 | Break | 12:00:00 | 13:00:00 | 2020-11-06 00:00:00 | 1 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Doe, [NAME] | [NAME] | Shift | Fri |  | 2020-11-06 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-06 00:00:00 | 2020-11-06 00:00:00 | Regular | 13:00:00 | 17:00:00 | 2020-11-06 00:00:00 | 4 |  |  |  |  |  |  |  |  |  | 8-5w1hl
Doe, [NAME] | [NAME] | None | Sat |  | 2020-11-07 00:00:00
Doe, [NAME] | [NAME] | None | Sun |  | 2020-11-08 00:00:00
Black, [NAME] | TAB0100965 | Shift | Sun |  | 2020-11-01 00:00:00 | 09:00:00 | 00:30:00 | 2020-11-02 00:00:00 | 2020-11-01 00:00:00 | Regular | 09:00:00 | 00:30:00 | 2020-11-02 00:00:00 | 15.5 |  |  |  |  |  |  |  |  |  | 9a-1230a
Black, [NAME] | TAB0100965 | Shift | Mon |  | 2020-11-02 00:00:00 | 14:30:00 | 00:30:00 | 2020-11-03 00:00:00 | 2020-11-02 00:00:00 | Regular | 14:30:00 | 00:30:00 | 2020-11-03 00:00:00 | 10 |  |  |  |  |  |  |  |  |  | 230p-1230a
Black, [NAME] | TAB0100965 | Shift | Tue |  | 2020-11-03 00:00:00 | 14:30:00 | 00:30:00 | 2020-11-04 00:00:00 | 2020-11-03 00:00:00 | Regular | 14:30:00 | 00:30:00 | 2020-11-04 00:00:00 | 10 |  |  |  |  |  |  |  |  |  | 230p-1230a
Black, [NAME] | TAB0100965 | Shift | Wed |  | 2020-11-04 00:00:00 | 13:00:00 | 19:30:00 | 2020-11-04 00:00:00 | 2020-11-04 00:00:00 | Regular | 13:00:00 | 19:30:00 | 2020-11-04 00:00:00 | 6.5 |  |  |  |  |  |  |  |  |  | 1p-730p
Black, [NAME] | TAB0100965 | None | Thu |  | 2020-11-05 00:00:00
Black, [NAME] | TAB0100965 | None | Fri |  | 2020-11-06 00:00:00
Black, [NAME] | TAB0100965 | None | Sat |  | 2020-11-07 00:00:00
Black, [NAME] | TAB0100965 | Shift | Sun |  | 2020-11-08 00:00:00 | 09:00:00 | 00:30:00 | 2020-11-09 00:00:00 | 2020-11-08 00:00:00 | Regular | 09:00:00 | 00:30:00 | 2020-11-09 00:00:00 | 15.5 |  |  |  |  |  |  |  |  |  | 9a-1230a