Spreadsheet: 131028d1322696501-matching-dates-and-returning-another-column-instructor
Sheet: Sheet2

 |  |  |  |  |  | Instructor resource
 |  | 2012-01-16 00:00:00 | Period 1 |  |  | 1
 |  | 2012-01-16 00:00:00 | Period 2 |  |  | 2
 |  | 2012-01-16 00:00:00 | Period 3 |  |  | 3
 |  | 2012-01-16 00:00:00 | Period 4 |  |  | 4
 |  | 2012-01-16 00:00:00 | Period 5 |  |  | 5
 |  | 2012-01-16 00:00:00 | Period 6 |  |  | 6
 |  | 2012-01-16 00:00:00 | Period 7 |  |  | 7
 |  | 2012-01-16 00:00:00 | Period 8 |  |  | 8
 |  | 2012-01-16 00:00:00 | Period 9 |  |  | 9
 |  | 2012-01-17 00:00:00 | Period 1 |  |  | 10
 |  | 2012-01-17 00:00:00 | Period 2 |  |  | 11
 |  | 2012-01-17 00:00:00 | Period 3 |  |  | 12
 |  | 2012-01-17 00:00:00 | Period 4 |  |  | 13
 |  | 2012-01-17 00:00:00 | Period 5 |  |  | 14
 |  | 2012-01-17 00:00:00 | Period 6 |  |  | 15
 |  | 2012-01-17 00:00:00 | Period 7 |  |  | 16
 |  | 2012-01-17 00:00:00 | Period 8 |  |  | 17
 |  | 2012-01-17 00:00:00 | Period 9 |  |  | 18
 |  | 2012-01-18 00:00:00 | Period 1 |  |  | 19
 |  | 2012-01-18 00:00:00 | Period 2 |  |  | 20
 |  | 2012-01-18 00:00:00 | Period 3 |  |  | 21
 |  | 2012-01-18 00:00:00 | Period 4 |  |  | 22
 |  | 2012-01-18 00:00:00 | Period 5 |  |  | 23
 |  | 2012-01-18 00:00:00 | Period 6 |  |  | 24
 |  | 2012-01-18 00:00:00 | Period 7 |  |  | 25
 |  | 2012-01-18 00:00:00 | Period 8 |  |  | 26
 |  | 2012-01-18 00:00:00 | Period 9 |  |  | 27
 |  | 2012-01-19 00:00:00 | Period 1 |  |  | 28
 |  | 2012-01-19 00:00:00 | Period 2 |  |  | 29
 |  | 2012-01-19 00:00:00 | Period 3 |  |  | 30
 |  | 2012-01-19 00:00:00 | Period 4 |  |  | 31
 |  | 2012-01-19 00:00:00 | Period 5 |  |  | 32
 |  | 2012-01-19 00:00:00 | Period 6 |  |  | 33
 |  | 2012-01-19 00:00:00 | Period 7 |  |  | 34
 |  | 2012-01-19 00:00:00 | Period 8 |  |  | 35
 |  | 2012-01-19 00:00:00 | Period 9 |  |  | 36
 |  | 2012-01-20 00:00:00 | Period 1 |  |  | 37
 |  | 2012-01-20 00:00:00 | Period 2 |  |  | 38
 |  | 2012-01-20 00:00:00 | Period 3 |  |  | 39
 |  | 2012-01-20 00:00:00 | Period 4 |  |  | 40
 |  | 2012-01-20 00:00:00 | Period 5 |  |  | 41
 |  | 2012-01-20 00:00:00 | Period 6 |  |  | 42
 |  | 2012-01-20 00:00:00 | Period 7 |  |  | 43
 |  | 2012-01-20 00:00:00 | Period 8 |  |  | 44
 |  | 2012-01-20 00:00:00 | Period 9 |  |  | 45
 |  | 2012-01-21 00:00:00 | Period 1 |  |  | 46
 |  | 2012-01-21 00:00:00 | Period 2 |  |  | 47
 |  | 2012-01-21 00:00:00 | Period 3 |  |  | 48
 |  | 2012-01-21 00:00:00 | Period 4 |  |  | 49
 |  | 2012-01-21 00:00:00 | Period 5 |  |  | 50
 |  | 2012-01-21 00:00:00 | Period 6 |  |  | 51
 |  | 2012-01-21 00:00:00 | Period 7 |  |  | 52
 |  | 2012-01-21 00:00:00 | Period 8 |  |  | 53
 |  | 2012-01-21 00:00:00 | Period 9 |  |  | 1
 |  | 2012-01-22 00:00:00 | Period 1 |  |  | 0
 |  | 2012-01-22 00:00:00 | Period 2 |  |  | 0
 |  | 2012-01-22 00:00:00 | Period 3 |  |  | 0
 |  | 2012-01-22 00:00:00 | Period 4 |  |  | 0
 |  | 2012-01-22 00:00:00 | Period 5 |  |  | 0
 |  | 2012-01-22 00:00:00 | Period 6 |  |  | 2
 |  | 2012-01-22 00:00:00 | Period 7 |  |  | 2
 |  | 2012-01-22 00:00:00 | Period 8 |  |  | 2
 |  | 2012-01-22 00:00:00 | Period 9 |  |  | 2
 |  | 2012-01-23 00:00:00 | Period 1 |  |  | 1
 |  | 2012-01-23 00:00:00 | Period 2 |  |  | 1
 |  | 2012-01-23 00:00:00 | Period 3 |  |  | 1
 |  | 2012-01-23 00:00:00 | Period 4 |  |  | 1
 |  | 2012-01-23 00:00:00 | Period 5 |  |  | 1
 |  | 2012-01-23 00:00:00 | Period 6 |  |  | 1
 |  | 2012-01-23 00:00:00 | Period 7 |  |  | 1
 |  | 2012-01-23 00:00:00 | Period 8 |  |  | 1
 |  | 2012-01-23 00:00:00 | Period 9 |  |  | 1
 |  | 2012-01-24 00:00:00 | Period 1 |  |  | 0
 |  | 2012-01-24 00:00:00 | Period 2 |  |  | 0
 |  | 2012-01-24 00:00:00 | Period 3 |  |  | 0
 |  | 2012-01-24 00:00:00 | Period 4 |  |  | 0
 |  | 2012-01-24 00:00:00 | Period 5 |  |  | 0
 |  | 2012-01-24 00:00:00 | Period 6 |  |  | 2
 |  | 2012-01-24 00:00:00 | Period 7 |  |  | 2
 |  | 2012-01-24 00:00:00 | Period 8 |  |  | 2
 |  | 2012-01-24 00:00:00 | Period 9 |  |  | 2
 |  | 2012-01-25 00:00:00 | Period 1 |  |  | 1
 |  | 2012-01-25 00:00:00 | Period 2 |  |  | 1
 |  | 2012-01-25 00:00:00 | Period 3 |  |  | 1
 |  | 2012-01-25 00:00:00 | Period 4 |  |  | 1
 |  | 2012-01-25 00:00:00 | Period 5 |  |  | 1
 |  | 2012-01-25 00:00:00 | Period 6 |  |  | 1
 |  | 2012-01-25 00:00:00 | Period 7 |  |  | 1
 |  | 2012-01-25 00:00:00 | Period 8 |  |  | 1
 |  | 2012-01-25 00:00:00 | Period 9 |  |  | 1
 |  | 2012-01-26 00:00:00 | Period 1 |  |  | 1
 |  | 2012-01-26 00:00:00 | Period 2 |  |  | 1
 |  | 2012-01-26 00:00:00 | Period 3 |  |  | 1
 |  | 2012-01-26 00:00:00 | Period 4 |  |  | 1
 |  | 2012-01-26 00:00:00 | Period 5 |  |  | 1
 |  | 2012-01-26 00:00:00 | Period 6 |  |  | 1
 |  | 2012-01-26 00:00:00 | Period 7 |  |  | 1
 |  | 2012-01-26 00:00:00 | Period 8 |  |  | 1
 |  | 2012-01-26 00:00:00 | Period 9 |  |  | 1
 |  | 2012-01-27 00:00:00 | Period 1 |  |  | 0
 |  | 2012-01-27 00:00:00 | Period 2 |  |  | 0
 |  | 2012-01-27 00:00:00 | Period 3 |  |  | 0
 |  | 2012-01-27 00:00:00 | Period 4 |  |  | 0
 |  | 2012-01-27 00:00:00 | Period 5 |  |  | 0
 |  | 2012-01-27 00:00:00 | Period 6 |  |  | 2
 |  | 2012-01-27 00:00:00 | Period 7 |  |  | 2
 |  | 2012-01-27 00:00:00 | Period 8 |  |  | 2
 |  | 2012-01-27 00:00:00 | Period 9 |  |  | 2
 |  | 2012-01-28 00:00:00 | Period 1 |  |  | 1
 |  | 2012-01-28 00:00:00 | Period 2 |  |  | 1
 |  | 2012-01-28 00:00:00 | Period 3 |  |  | 1
 |  | 2012-01-28 00:00:00 | Period 4 |  |  | 1
 |  | 2012-01-28 00:00:00 | Period 5 |  |  | 1
 |  | 2012-01-28 00:00:00 | Period 6 |  |  | 1
 |  | 2012-01-28 00:00:00 | Period 7 |  |  | 1
 |  | 2012-01-28 00:00:00 | Period 8 |  |  | 1
 |  | 2012-01-28 00:00:00 | Period 9 |  |  | 1
 |  | 2012-01-29 00:00:00 | Period 1 |  |  | 0
 |  | 2012-01-29 00:00:00 | Period 2 |  |  | 0
 |  | 2012-01-29 00:00:00 | Period 3 |  |  | 0
 |  | 2012-01-29 00:00:00 | Period 4 |  |  | 0
 |  | 2012-01-29 00:00:00 | Period 5 |  |  | 0
 |  | 2012-01-29 00:00:00 | Period 6 |  |  | 2
 |  | 2012-01-29 00:00:00 | Period 7 |  |  | 2
 |  | 2012-01-29 00:00:00 | Period 8 |  |  | 2
 |  | 2012-01-29 00:00:00 | Period 9 |  |  | 2
 |  | 2012-01-30 00:00:00 | Period 1 |  |  | 1
 |  | 2012-01-30 00:00:00 | Period 2 |  |  | 1
 |  | 2012-01-30 00:00:00 | Period 3 |  |  | 1
 |  | 2012-01-30 00:00:00 | Period 4 |  |  | 1
 |  | 2012-01-30 00:00:00 | Period 5 |  |  | 1
 |  | 2012-01-30 00:00:00 | Period 6 |  |  | 1
 |  | 2012-01-30 00:00:00 | Period 7 |  |  | 1
 |  | 2012-01-30 00:00:00 | Period 8 |  |  | 1
 |  | 2012-01-30 00:00:00 | Period 9 |  |  | 1