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

 | Days of the month |  | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
A |  | Mr A | B | B | B | B | H | H | B | B | B | B | B | H | H | B | B | B | B | B | B | B | H | H | B | B | B | B | B | H | H | B | B | 0
 |  | Mrs B | D | D | S | S | H | H | S | S | H | S | H | S | S | H | S | D | D | D | S | S | H | H | S | S | H | S | H | S | S | H | S | 0
 |  | Mr c | E | E | D | D | D | D | D | D | D | D | D | D | D | D | D | E | E | E | D | D | D | D | D | D | D | D | D | D | D | D | D | 0
 |  | Mrs d | Y | G | E | D | Ｇ | Ｇ | H | Ｄ | Ｅ | H | Ｇ | Ｇ | H | Ｇ | Ｄ | G | G | G | E | D | Ｇ | Ｇ | H | Ｄ | Ｅ | H | Ｇ | Ｇ | H | Ｇ | Ｄ | 0
 |  | Mr e | M | M | G | E | D | H | H | Ｇ | Ｇ | Ｄ | Ｅ | H | Ｇ | Ｄ | Ｅ | M | M | M | G | E | D | H | H | Ｇ | Ｇ | Ｄ | Ｅ | H | Ｇ | Ｄ | Ｅ | 0
 |  | Mr sf | N | N | M | G | E | D | Ｇ | H | Ｄ | Ｅ | H | Ｄ | Ｅ | H | Ｇ | N | N | N | M | G | E | D | Ｇ | H | Ｄ | Ｅ | H | Ｄ | Ｅ | H | Ｇ | 0
 |  | Mr g | P | P | N | M | G | E | D | Ｇ | Ｑ | Ｄ | Ｅ | H | Ｇ | M | M | P | P | P | N | M | G | E | D | Ｇ | Ｑ | Ｄ | Ｅ | H | Ｇ | M | M | 0
 |  | Mr sh | Q | Q | P | N | M | G | E | D | H | Ｇ | Ｄ | Ｅ | H | Ｇ | Ｑ | Q | Q | Q | P | N | M | G | E | D | H | Ｇ | Ｄ | Ｅ | H | Ｇ | Ｑ | 0
 |  | Mr i | S | S | Q | P | N | M | G | E | D | Ｇ | M | H | Ｑ | Ｄ | Ｅ | S | S | S | Q | P | N | M | G | E | D | Ｇ | M | H | Ｑ | Ｄ | Ｅ | 0
 |  | Mrs j | Y | Y | S | Q | P | N | M | G | E | D | H | Ｑ | Ｄ | Ｅ | H | Y | Y | Y | S | Q | P | N | M | G | E | D | H | Ｑ | Ｄ | Ｅ | H | 0
B |  | Mr k | B | B | Y | S | Q | P | N | M | G | E | D | M | M | H | H | B | B | B | Y | S | Q | P | N | M | G | E | D | M | M | H | H | 0
 |  | Mrs l | K | K | B | Y | S | Q | P | N | M | G | E | D | Ｅ | H | H | K | K | K | B | Y | S | Q | P | N | M | G | E | D | Ｅ | H | H | 0
 |  | Mr m | T | T | K | B | Y | S | Q | P | N | M | G | E | D | Ｐ | N | T | T | T | K | B | Y | S | Q | P | N | M | G | E | D | Ｐ | N | 0
 |  | Mrs n | F | F | T | K | B | Y | S | Q | P | N | M | G | E | D | H | F | F | F | T | K | B | Y | S | Q | P | N | M | G | E | D | H | 0
 |  | Mr o | ｇ | ｇ | F | T | K | B | Y | S | Q | P | N | M | G | E | D | ｇ | ｇ | ｇ | F | T | K | B | Y | S | Q | P | N | M | G | E | D | 0
 |  | Mrs p | H | H | ｇ | F | T | K | B | Y | S | Q | P | N | M | G | E | H | H | H | ｇ | F | T | K | B | Y | S | Q | P | N | M | G | E | 0
 |  | Mr q | W | W | H | ｇ | F | T | K | B | Y | S | Q | P | N | M | G | W | W | W | H | ｇ | F | T | K | B | Y | S | Q | P | N | M | G | 0
 |  | Mrs r | X | X | W | H | ｇ | F | T | K | B | Y | S | Q | P | N | M | X | X | X | W | H | ｇ | F | T | K | B | Y | S | Q | P | N | M | 0
 |  |  | Z | Z | X | W | H | ｇ | F | T | K | B | Y | S | Q | P | N | Z | Z | Z | X | W | H | ｇ | F | T | K | B | Y | S | Q | P | N | 0
 |  |  | R | R | Z | X | W | H | ｇ | F | T | K | B | Y | S | Q | P | R | R | R | Z | X | W | H | ｇ | F | T | K | B | Y | S | Q | P | 0
 |  |  | L | L | R | Z | X | W | H | ｇ | F | T | K | B | Y | S | Q | L | L | L | R | Z | X | W | H | ｇ | F | T | K | B | Y | S | Q | 0
 |  |  | U | U | L | R | Z | X | W | H | ｇ | F | T | K | B | Y | S | U | U | U | L | R | Z | X | W | H | ｇ | F | T | K | B | Y | S | 0
 |  | Mr s | V | V | U | L | R | Z | X | W | H | ｇ | F | T | K | B | Y | V | V | V | U | L | R | Z | X | W | H | ｇ | F | T | K | B | Y | 0
 | B | 8:45～17:00 | ●
 | D | 16:00～0:15 | ◇
 | E | 0:15～8:30 | ◎
 | G | 8:30～16:45 | ●
 | M | 9:15～17:30 | ●
 | N | 7:45～16:00 | ●
 | P | 10:15～18:30 | ●
 | Q | 11:45～20:00 | ●
 | S | 8:30～16:45 | ●
 | Y | 9:00～17:00 | ●
 | B | 8:45～17:00 | ●
 | K | 9:00～14:00 | ●
 | T | 9:00～12:00 | ●
 | F | 8:30～16:45 | ●
 | ｇ | 0:15～8:30 | ●
 | H | Holiday | ○
 | W | 9:00～17:07 | ●
 | X | 9:00～17:08 | ●
 | Z | 9:00～17:09 | ●
 | R | 9:00～17:10 | ●
 | L | 9:00～17:11 | ●
 | U | 9:00～17:12 | ●
 | V | 9:00～17:13 | ●
 | S | 9:00～17:14 | ●