Spreadsheet: 102394d1300332222-vlookup-problem-for-employees-with-same-shift-example-of-pull-from-schedule
Sheet: schedule

 | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | satuerday
 | 2011-01-01 00:00:00
[NAME] | OFF | 0 | 10-5 | 6 | 12-8 | 7 | 9-5 | 7 |  |  | 10-7 | 8 | 12-8 | 7
[NAME] | 1030-630 | 7 | OFF | 0 | 10-6 | 7 | 9-4 | 6 | 10-6 | 7 | 12-8 | 7 | OFF | 0
[NAME] | 11-7 | 7 | 12-8 | 7 | OFF | 0 | 9-11 | 2 | 12-8 | 7 | 10-6 | 7 | 12-8 | 7
Mark | OFF | 0 | 12-8 | 7 | 12-8 | 7 | 9-11/3-8 | 6.5 | 10-6 | 7 | OFF | 0 | 10-6 | 7
[NAME] | 1-7 | 5.5 |  |  |  |  |  |  |  |  | 3-8 | 4.5 | OFF | 0
robby | OFF | 0 | 3-8 | 4.5 | 3-8 | 4.5 | OFF |  | OFF |  | 2-8 | 5.5 | OFF | 0
angie | OFF | 0 | 10-3 | 4.5 |  |  | 12-5 | 4.5 |  |  | OFF |  | 10-3 | 4.5
becky | OFF | 0 | OFF |  | OFF |  | 2-8 | 5.5 | OFF |  | OFF |  | OFF | 0
micky | 1030-330 | 4.5 |  |  | OFF |  |  |  | OFF | 0 | 12-5 | 4.5 | 3-8 | 4.5
[NAME] | OFF | 0 | OFF | 0 | OFF | 0 | OFF |  | 3-8 | 4.5 | OFF |  | 12-5 | 4.5
 |  | hrs |  | hrs |  | hrs |  | hrs |  | hrs |  | hrs |  | hrs
A table format below of your data above and then >> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Here is another example using Date Filter and shift is column head.  You can simply drag shift heads to sort.
 |  |  |  |  |  | Filter By Date |  |  | Another Possible display from Table to the Left |  |  |  |  |  |  |  |  |  | You can drag people up and down to sort them by manager as I've done below.
Name | Date | Shift | Hours |  |  | Only Show hrs >0 |  |  | Weeks dates are column [NAME].
[NAME] | 2011-01-01 00:00:00 | OFF | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | (All) | <<Click here and select a single date if desired.
[NAME] | 2011-01-01 00:00:00 | 1030-630 | 7 |  |  | Date | 2011-01-03 00:00:00 |  | Sum of Hours | Column Labels
[NAME] | 2011-01-01 00:00:00 | 11-7 | 7 |  |  |  |  |  | Row Labels | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | Grand Total |  | Sum of Hours | Column Labels
Mark | 2011-01-01 00:00:00 | OFF | 0 |  |  | Row Labels | Sum of Hours |  | angie | 0 | 4.5 |  | 4.5 |  |  | 4.5 | 13.5 |  | Row Labels | 10-3 | 1030-330 | 1030-630 | 10-6 | 10-5 | 10-7 | 11-7 | 12-5 | 12-8 | 1-7 | 2-8 | 3-8 | 9-11 | 9-11/3-8 | 9-4 | 9-5 | OFF | (blank) | Grand Total
[NAME] | 2011-01-01 00:00:00 | 1-7 | 5.5 |  |  | [NAME] | 7 |  | becky | 0 |  |  | 5.5 |  |  | 0 | 5.5 |  | [NAME] |  |  |  |  | 6 | 8 |  |  | 14 |  |  |  |  |  |  | 7 | 0 |  | 35
robby | 2011-01-01 00:00:00 | OFF | 0 |  |  | 12-8 | 7 |  | [NAME] | 0 | 6 | 7 | 7 |  | 8 | 7 | 35 |  | [NAME] |  |  | 7 | 14 |  |  |  |  | 7 |  |  |  |  |  | 6 |  | 0 |  | 34
angie | 2011-01-01 00:00:00 | OFF | 0 |  |  | Mark | 7 |  | [NAME] | 5.5 |  |  |  |  | 4.5 | 0 | 10 |  | [NAME] |  |  |  | 7 |  |  | 7 |  | 21 |  |  |  | 2 |  |  |  | 0 |  | 37
becky | 2011-01-01 00:00:00 | OFF | 0 |  |  | 12-8 | 7 |  | [NAME] | 7 | 7 | 0 | 2 | 7 | 7 | 7 | 37 |  | Mark |  |  |  | 14 |  |  |  |  | 14 |  |  |  |  | 6.5 |  |  | 0 |  | 34.5
micky | 2011-01-01 00:00:00 | 1030-330 | 4.5 |  |  | robby | 4.5 |  | [NAME] | 0 | 0 | 0 |  | 4.5 |  | 4.5 | 9 |  | angie | 9 |  |  |  |  |  |  | 4.5 |  |  |  |  |  |  |  |  | 0 |  | 13.5
[NAME] | 2011-01-01 00:00:00 | OFF | 0 |  |  | 3-8 | 4.5 |  | Mark | 0 | 7 | 7 | 6.5 | 7 | 0 | 7 | 34.5 |  | becky |  |  |  |  |  |  |  |  |  |  | 5.5 |  |  |  |  |  | 0 |  | 5.5
[NAME] | 2011-01-02 00:00:00 | 10-5 | 6 |  |  | [NAME] | 7 |  | 10-6 |  |  |  |  | 7 |  | 7 | 14 |  | [NAME] |  |  |  |  |  |  |  |  |  | 5.5 |  | 4.5 |  |  |  |  | 0 |  | 10
[NAME] | 2011-01-02 00:00:00 | OFF | 0 |  |  | 10-6 | 7 |  | 12-8 |  | 7 | 7 |  |  |  |  | 14 |  | [NAME] |  |  |  |  |  |  |  | 4.5 |  |  |  | 4.5 |  |  |  |  | 0 |  | 9
[NAME] | 2011-01-02 00:00:00 | 12-8 | 7 |  |  | Grand Total | 25.5 |  | 9-11/3-8 |  |  |  | 6.5 |  |  |  | 6.5 |  | micky |  | 4.5 |  |  |  |  |  | 4.5 |  |  |  | 4.5 |  |  |  |  | 0 |  | 13.5
Mark | 2011-01-02 00:00:00 | 12-8 | 7 |  |  |  |  |  | OFF | 0 |  |  |  |  | 0 |  | 0 |  | robby |  |  |  |  |  |  |  |  |  |  | 5.5 | 9 |  |  |  |  | 0 |  | 14.5
[NAME] | 2011-01-02 00:00:00 |  |  |  |  |  |  |  | micky | 4.5 |  |  |  | 0 | 4.5 | 4.5 | 13.5 |  | Grand Total | 9 | 4.5 | 7 | 35 | 6 | 8 | 7 | 13.5 | 56 | 5.5 | 11 | 22.5 | 2 | 6.5 | 6 | 7 | 0 |  | 206.5
robby | 2011-01-02 00:00:00 | 3-8 | 4.5 |  |  |  |  |  | 1030-330 | 4.5 |  |  |  |  |  |  | 4.5
angie | 2011-01-02 00:00:00 | 10-3 | 4.5 |  |  |  |  |  | 12-5 |  |  |  |  |  | 4.5 |  | 4.5
becky | 2011-01-02 00:00:00 | OFF |  |  |  |  |  |  | 3-8 |  |  |  |  |  |  | 4.5 | 4.5
micky | 2011-01-02 00:00:00 |  |  |  |  |  |  |  | OFF |  |  |  |  | 0 |  |  | 0
[NAME] | 2011-01-02 00:00:00 | OFF | 0 |  |  |  |  |  | (blank)
[NAME] | 2011-01-03 00:00:00 | 12-8 | 7 |  |  |  |  |  | robby | 0 | 4.5 | 4.5 |  |  | 5.5 | 0 | 14.5
[NAME] | 2011-01-03 00:00:00 | 10-6 | 7 |  |  |  |  |  | 2-8 |  |  |  |  |  | 5.5 |  | 5.5
[NAME] | 2011-01-03 00:00:00 | OFF | 0 |  |  |  |  |  | 3-8 |  | 4.5 | 4.5 |  |  |  |  | 9
Mark | 2011-01-03 00:00:00 | 12-8 | 7 |  |  |  |  |  | OFF | 0 |  |  |  |  |  | 0 | 0
[NAME] | 2011-01-03 00:00:00 |  |  |  |  |  |  |  | [NAME] | 7 | 0 | 7 | 6 | 7 | 7 | 0 | 34
robby | 2011-01-03 00:00:00 | 3-8 | 4.5 |  |  |  |  |  | 1030-630 | 7 |  |  |  |  |  |  | 7
angie | 2011-01-03 00:00:00 |  |  |  |  |  |  |  | 10-6 |  |  | 7 |  | 7 |  |  | 14
becky | 2011-01-03 00:00:00 | OFF |  |  |  |  |  |  | 12-8 |  |  |  |  |  | 7 |  | 7
micky | 2011-01-03 00:00:00 | OFF |  |  |  |  |  |  | 9-4 |  |  |  | 6 |  |  |  | 6
[NAME] | 2011-01-03 00:00:00 | OFF | 0 |  |  |  |  |  | OFF |  | 0 |  |  |  |  | 0 | 0
[NAME] | 2011-01-04 00:00:00 | 9-5 | 7 |  |  |  |  |  | Grand Total | 24 | 29 | 25.5 | 31.5 | 25.5 | 36.5 | 34.5 | 206.5
[NAME] | 2011-01-04 00:00:00 | 9-4 | 6
[NAME] | 2011-01-04 00:00:00 | 9-11 | 2
Mark | 2011-01-04 00:00:00 | 9-11/3-8 | 6.5
[NAME] | 2011-01-04 00:00:00
robby | 2011-01-04 00:00:00 | OFF
angie | 2011-01-04 00:00:00 | 12-5 | 4.5
becky | 2011-01-04 00:00:00 | 2-8 | 5.5
micky | 2011-01-04 00:00:00
[NAME] | 2011-01-04 00:00:00 | OFF
[NAME] | 2011-01-05 00:00:00
[NAME] | 2011-01-05 00:00:00 | 10-6 | 7
[NAME] | 2011-01-05 00:00:00 | 12-8 | 7
Mark | 2011-01-05 00:00:00 | 10-6 | 7
[NAME] | 2011-01-05 00:00:00
robby | 2011-01-05 00:00:00 | OFF
angie | 2011-01-05 00:00:00
becky | 2011-01-05 00:00:00 | OFF
micky | 2011-01-05 00:00:00 | OFF | 0
[NAME] | 2011-01-05 00:00:00 | 3-8 | 4.5
[NAME] | 2011-01-06 00:00:00 | 10-7 | 8
[NAME] | 2011-01-06 00:00:00 | 12-8 | 7
[NAME] | 2011-01-06 00:00:00 | 10-6 | 7
Mark | 2011-01-06 00:00:00 | OFF | 0
[NAME] | 2011-01-06 00:00:00 | 3-8 | 4.5
robby | 2011-01-06 00:00:00 | 2-8 | 5.5
angie | 2011-01-06 00:00:00 | OFF
becky | 2011-01-06 00:00:00 | OFF
micky | 2011-01-06 00:00:00 | 12-5 | 4.5
[NAME] | 2011-01-06 00:00:00 | OFF
[NAME] | 2011-01-07 00:00:00 | 12-8 | 7
[NAME] | 2011-01-07 00:00:00 | OFF | 0
[NAME] | 2011-01-07 00:00:00 | 12-8 | 7
Mark | 2011-01-07 00:00:00 | 10-6 | 7
[NAME] | 2011-01-07 00:00:00 | OFF | 0
robby | 2011-01-07 00:00:00 | OFF | 0
angie | 2011-01-07 00:00:00 | 10-3 | 4.5
becky | 2011-01-07 00:00:00 | OFF | 0
micky | 2011-01-07 00:00:00 | 3-8 | 4.5
[NAME] | 2011-01-07 00:00:00 | 12-5 | 4.5