Spreadsheet: 68159d1268720841-another-formula-to-lookup-a-cell-when-a-symbol-is-imput-demo-5
Sheet: Staff 2

Ｎｏ | Mr s |  |  |  |  |  |  |  |  | Mrs d |  |  |  |  |  |  |  |  | Mr q |  |  |  |  |  |  |  |  | Mrs p |  |  |  |  |  |  |  |  | Mr o
 | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time
16 | ● |  |  |  |  |  | 8:30～16:15 |  |  | ● |  |  |  |  |  | 9:00～17:14 |  |  | ● |  |  |  |  |  | 9:00～17:07
17 | ● |  |  |  |  |  | 8:30～16:15 |  |  | ● |  |  |  |  |  | 8:30～16:45 |  |  | ● |  |  |  |  |  | 9:00～17:07
18 | ● |  |  |  |  |  | 8:30～16:15 |  |  | ◎ |  |  |  |  |  | 0:15～8:30 |  |  | ● |  |  |  |  |  | 8:30～16:45
19 | ○ |  |  |  |  |  | Holiday |  |  | ◇ |  |  |  |  |  | 16:00～0:15 |  |  | ● |  |  |  |  |  | 8:30～16:45
20 | ● |  |  |  |  |  | 10:15～18:30 |  |  | ● |  |  |  |  |  | 8:30～16:45 |  |  | ◎ |  |  |  |  |  | 0:15～8:30
21 | ◎ |  |  |  |  |  | 16:00～0:15 |  |  | ● |  |  |  |  |  | 8:30～16:45 |  |  | ○ |  |  |  |  |  | Holiday
22 | ◎ |  |  |  |  |  | 0:15～8:30 |  |  | ● |  |  |  |  |  | 8:30～16:45 |  |  | ● |  |  |  |  |  | 9:00～14:00
23 | ○ |  |  |  |  |  | Holiday |  |  | ◇ |  |  |  |  |  | 16:00～0:15 |  |  | ● |  |  |  |  |  | 8:45～17:00
24 | ● |  |  |  |  |  | 10:15～18:30 |  |  | ◎ |  |  |  |  |  | 0:15～8:30 |  |  | ● |  |  |  |  |  | 9:00～17:14
25 | ○ |  |  |  |  |  | Holiday |  |  | ● |  |  |  |  |  | 8:30～16:45 |  |  | ○ |  |  |  |  |  | Holiday
26 | ● |  |  |  |  |  | 7:45～16:00 |  |  | ● |  |  |  |  |  | 8:30～16:45 |  |  | ○ |  |  |  |  |  | Holiday
27 | ● |  |  |  |  |  | 8:30～16:15 |  |  | ● |  |  |  |  |  | 8:30～16:45 |  |  | ○ |  |  |  |  |  | Holiday
28 | ● |  |  |  |  |  | 8:30～16:15 |  |  | ● |  |  |  |  |  | 8:30～16:45 |  |  | ○ |  |  |  |  |  | Holiday
29 | ● |  |  |  |  |  | 7:45～16:00 |  |  | ● |  |  |  |  |  | 8:30～16:45 |  |  | ○ |  |  |  |  |  | Holiday
30 | ○ |  |  |  |  |  | Holiday |  |  | ◇ |  |  |  |  |  | 16:00～0:15 |  |  | ● |  |  |  |  |  | 8:30～16:45
31 | ● |  |  |  |  |  | 8:30～16:15 |  |  | ● |  |  |  |  |  | 8:30～16:45 |  |  | ● |  |  |  |  |  | 9:00～17:07
1 | ○ |  |  |  |  |  | Holiday |  |  | ● |  |  |  |  |  | 8:30～16:45 |  |  | ● |  |  |  |  |  | 9:00～17:07
2 | ● |  |  |  |  |  | 7:45～16:00 |  |  | ● |  |  |  |  |  | 8:30～16:45 |  |  | ● |  |  |  |  |  | 9:00～17:07
3 | ○ |  |  |  |  |  | Holiday |  |  | ◎ |  |  |  |  |  | 0:15～8:30 |  |  | ● |  |  |  |  |  | 8:30～16:45
4 | ● |  |  |  |  |  | 8:30～16:15 |  |  | ◇ |  |  |  |  |  | 16:00～0:15 |  |  | ● |  |  |  |  |  | 8:30～16:45
5 | ○ |  |  |  |  |  | Holiday |  |  | ● |  |  |  |  |  | 8:30～16:45 |  |  | ◎ |  |  |  |  |  | 0:15～8:30
6 | ◎ |  |  |  |  |  | 16:00～0:15 |  |  | ● |  |  |  |  |  | 8:30～16:45 |  |  | ○ |  |  |  |  |  | Holiday
7 | ◎ |  |  |  |  |  | 0:15～8:30 |  |  | ● |  |  |  |  |  | 8:30～16:45 |  |  | ● |  |  |  |  |  | 9:00～14:00
8 | ○ |  |  |  |  |  | Holiday |  |  | ◇ |  |  |  |  |  | 16:00～0:15 |  |  | ● |  |  |  |  |  | 8:45～17:00
9 | ● |  |  |  |  |  | 8:30～16:15 |  |  | ◎ |  |  |  |  |  | 0:15～8:30 |  |  | ● |  |  |  |  |  | 9:00～17:14
10 | ● |  |  |  |  |  | 7:45～16:00 |  |  | ● |  |  |  |  |  | 8:30～16:45 |  |  | ○ |  |  |  |  |  | Holiday
11 | ● |  |  |  |  |  | 10:15～18:30 |  |  | ● |  |  |  |  |  | 8:30～16:45 |  |  | ○ |  |  |  |  |  | Holiday
12 | ● |  |  |  |  |  | 7:45～16:00 |  |  | ● |  |  |  |  |  | 8:30～16:45 |  |  | ○ |  |  |  |  |  | Holiday
13 | ○ |  |  |  |  |  | Holiday |  |  | ● |  |  |  |  |  | 8:30～16:45 |  |  | ○ |  |  |  |  |  | Holiday
14 | ● |  |  |  |  |  | 8:30～16:15 |  |  | ● |  |  |  |  |  | 8:30～16:45 |  |  | ○ |  |  |  |  |  | Holiday
15 | ● |  |  |  |  |  | 8:30～16:15 |  |  | ◇ |  |  |  |  |  | 16:00～0:15 |  |  | ● |  |  |  |  |  | 8:30～16:45
 | Mrs n |  |  |  |  |  |  |  |  | Mr m |  |  |  |  |  |  |  |  | Mrs l |  |  |  |  |  |  |  |  | Mr k |  |  |  |  |  |  |  |  | Mrs j
 | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 | Mr i |  |  |  |  |  |  |  |  | Mr sh |  |  |  |  |  |  |  |  | Mr g |  |  |  |  |  |  |  |  | Mr sf |  |  |  |  |  |  |  |  | Mr e
 | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 | Mrs d |  |  |  |  |  |  |  |  | Mr c |  |  |  |  |  |  |  |  | Mrs B |  |  |  |  |  |  |  |  | Mr A
 | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time |  |  | Day worked |  |  | Overtime |  |  | Time
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15