Spreadsheet: 68147d1268696785-another-formula-to-lookup-a-cell-when-a-symbol-is-imput-demo
Sheet: Staff 2

Ｎｏ | Mr s |  |  |  |  |  |  |  |  | Mrs r |  |  |  |  |  |  |  |  | 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 |  |  | ● |  |  |  |  |  | 7:45～16:00 |  |  | ◎ |  |  |  |  |  | 0:15～8:30
17 | ● |  |  |  |  |  | 8:30～16:15 |  |  | ○ |  |  |  |  |  | Holiday |  |  | ● |  |  |  |  |  | 10:15～18:30
18 | ● |  |  |  |  |  | 8:30～16:15 |  |  | ○ |  |  |  |  |  | Holiday |  |  | ◎ |  |  |  |  |  | 0:15～8:30
19 | ○ |  |  |  |  |  | Holiday |  |  | ◎ |  |  |  |  |  | 0:15～8:30 |  |  | ○ |  |  |  |  |  | Holiday
20 | ● |  |  |  |  |  | 10:15～18:30 |  |  | ◎ |  |  |  |  |  | 0:15～8:30 |  |  | ◎ |  |  |  |  |  | 0:15～8:30
21 | ◎ |  |  |  |  |  | 16:00～0:15 |  |  | ● |  |  |  |  |  | 7:45～16:00 |  |  | ● |  |  |  |  |  | 10:15～18:30
22 | ◎ |  |  |  |  |  | 0:15～8:30 |  |  | ● |  |  |  |  |  | 7:45～16:00 |  |  | ● |  |  |  |  |  | 8:30～16:45
23 | ○ |  |  |  |  |  | Holiday
24 | ● |  |  |  |  |  | 10:15～18:30
25 | ○ |  |  |  |  |  | Holiday
26 | ● |  |  |  |  |  | 7:45～16:00
27 | ● |  |  |  |  |  | 8:30～16:15
28 | ● |  |  |  |  |  | 8:30～16:15
29 | ● |  |  |  |  |  | 7:45～16:00
30 | ○ |  |  |  |  |  | Holiday
31 | ● |  |  |  |  |  | 8:30～16:15
1 | ○ |  |  |  |  |  | Holiday
2 | ● |  |  |  |  |  | 7:45～16:00
3 | ○ |  |  |  |  |  | Holiday
4 | ● |  |  |  |  |  | 8:30～16:15
5 | ○ |  |  |  |  |  | Holiday
6 | ◎ |  |  |  |  |  | 16:00～0:15
7 | ◎ |  |  |  |  |  | 0:15～8:30
8 | ○ |  |  |  |  |  | Holiday
9 | ● |  |  |  |  |  | 8:30～16:15
10 | ● |  |  |  |  |  | 7:45～16:00
11 | ● |  |  |  |  |  | 10:15～18:30
12 | ● |  |  |  |  |  | 7:45～16:00
13 | ○ |  |  |  |  |  | Holiday
14 | ● |  |  |  |  |  | 8:30～16:15
15 | ● |  |  |  |  |  | 8:30～16:15
 | 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