Spreadsheet: 68056d1268618354-another-formula-to-lookup-a-cell-when-a-symbol-is-imput-demo
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 | Ｂ | Ｂ | Ｂ | Ｂ | H | H | Ｂ | Ｂ | Ｂ | Ｂ | Ｂ | H | H | Ｂ | Ｂ | Ｂ | Ｂ | Ｂ | H | H | Ｂ | Ｂ | Ｂ | Ｂ | Ｂ | H | H | Ｂ | Ｂ | Ｂ | Ｂ | 0
 |  | Mrs B | S | S | S | S | H | H | S | S | H | S | H | S | S | H | S | S | S | H | S | H | S | S | S | S | H | S | S | S | S | S | H | 0
 |  | Mr c | Ｂ | Ｂ | Ｂ | Ｂ | H | H | Ｂ | Ｂ | Ｂ | Ｂ | Ｂ | H | H | Ｂ | Ｂ | Ｂ | Ｂ | Ｂ | H | H | Ｂ | Ｂ | Ｂ | Ｂ | Ｂ | H | H | Ｂ | Ｂ | Ｂ | Ｂ | 0
 |  | Mrs d | Ｇ | H | H | Ｇ | Ｇ | Ｇ | H | Ｄ | Ｅ | H | Ｇ | Ｇ | H | Ｇ | Ｄ | Ｅ | H | Ｇ | Ｇ | Ｑ | g | H | Ｇ | Ｄ | Ｅ | H | Ｇ | H | Ｑ | Ｄ | Ｅ | 0
 |  | Mr e | H | Ｇ | Ｇ | Ｄ | Ｅ | H | H | Ｇ | Ｇ | Ｄ | Ｅ | H | Ｇ | Ｄ | Ｅ | H | Ｄ | Ｅ | H | Ｇ | Ｇ | Ｄ | Ｅ | H | Ｄ | Ｅ | H | Ｑ | Ｄ | Ｅ | H | 0
 |  | Mr sf | Ｅ | H | Ｄ | Ｅ | H | H | Ｇ | H | Ｄ | Ｅ | H | Ｄ | Ｅ | H | Ｇ | Ｇ | Ｇ | Ｄ | Ｅ | H | Ｇ | g | N | H | Ｐ | Ｑ | H | Ｇ | Ｇ | Ｇ | Ｄ | 0
 |  | Mr g | Ｑ | H | Ｇ | Ｇ | Ｄ | Ｅ | H | Ｇ | Ｑ | Ｄ | Ｅ | H | Ｇ | M | M | Ｑ | H | Ｄ | Ｅ | H | M | M | Ｄ | Ｅ | H | H | H | Ｄ | Ｅ | H | N | 0
 |  | Mr sh | H | Ｇ | Ｄ | Ｅ | H | Ｑ | Ｄ | Ｅ | H | Ｇ | Ｄ | Ｅ | H | Ｇ | Ｑ | Ｄ | Ｅ | H | Ｑ | Ｄ | Ｅ | H | Ｇ | H | Ｇ | Ｇ | Ｄ | Ｅ | H | Ｇ | H | 0
 |  | Mr i | Ｇ | Ｄ | Ｅ | H | H | M | Ｄ | Ｅ | H | Ｇ | M | H | Ｑ | Ｄ | Ｅ | H | Ｇ | Ｇ | M | M | Ｄ | Ｅ | H | H | Ｇ | Ｇ | H | Ｇ | Ｇ | H | Ｄ | 0
 |  | Mrs j | Ｄ | Ｅ | H | N | Ｑ | Ｄ | Ｅ | H | M | M | H | Ｑ | Ｄ | Ｅ | H | Ｇ | H | Ｑ | Ｄ | Ｅ | H | Ｇ | H | N | N | Ｄ | Ｅ | H | H | Ｑ | Ｇ | 0
B |  | Mr k | H | H | M | Ｄ | Ｅ | H | M | M | Ｄ | Ｅ | H | M | M | H | H | M | Ｄ | Ｅ | H | g | Ｑ | H | M | M | M | Ｄ | Ｅ | H | M | M | M | 0
 |  | Mrs l | M | N | N | M | M | H | H | Ｄ | Ｅ | H | Ｇ | Ｄ | Ｅ | H | H | N | M | M | H | Ｄ | Ｅ | H | Ｄ | Ｅ | H | M | M | M | Ｄ | Ｅ | H | 0
 |  | Mr m | Ｄ | Ｅ | H | Ｐ | Ｄ | Ｅ | H | N | N | H | Ｄ | Ｅ | H | Ｐ | N | Ｄ | Ｅ | H | N | Ｐ | N | H | H | Ｄ | Ｅ | H | N | Ｄ | Ｅ | H | g | 0
 |  | Mrs n | H | Ｄ | Ｅ | H | N | Ｄ | Ｅ | H | Ｇ | Ｐ | Ｑ | H | Ｄ | Ｅ | H | Ｐ | N | H | Ｄ | Ｅ | H | Ｑ | g | Ｇ | H | H | Ｑ | g | N | Ｄ | Ｅ | 0
 |  | Mr o | H | Ｑ | Ｐ | Ｑ | Ｇ | H | Ｐ | Ｑ | H | Ｑ | g | H | Ｐ | g | Ｐ | H | g | Ｐ | g | H | Ｐ | Ｇ | Ｑ | H | Ｄ | Ｅ | H | Ｐ | H | Ｐ | Ｑ | 0
 |  | Mrs p | Ｐ | M | Ｑ | g | H | Ｇ | Ｑ | g | H | N | Ｐ | N | H | Ｑ | g | H | Ｐ | H | Ｇ | N | H | N | Ｐ | Ｐ | Ｑ | H | H | g | Ｐ | N | H | 0
 |  | Mr q | g | Ｐ | g | H | g | Ｐ | Ｇ | Ｐ | H | g | g | Ｇ | H | H | Ｇ | H | Ｑ | g | Ｐ | H | g | Ｐ | H | Ｇ | g | Ｐ | Ｇ | H | g | H | Ｇ | 0
 |  | Mrs r | N | H | H | g | g | N | N | H | g | H | g | Ｐ | N | H | Ｄ | Ｅ | H | g | g | g | Ｄ | Ｅ | H | Ｑ | g | H | Ｄ | Ｅ | H | g | Ｐ | 0
 |  | Mr s | g | g | g | H | Ｐ | Ｄ | Ｅ | H | Ｐ | H | N | g | g | N | H | g | H | N | H | Ｇ | H | Ｄ | Ｅ | H | g | N | Ｐ | N | H | g | g | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Ｂ→8:45～17:00
 | Ｇ→8:30～16:45
 | Ｑ→11:45～20:00
 | Ｄ→16:00～0:15
 | Ｅ→0:15～8:30
 | H→Holiday
 | g→8:30～16:45
 | M→9:15～17:30
 | N→7:45～16:00
 | Ｐ→10:15～18:30
 | Ｄ→16:00～0:15
 | Ｅ→0:15～8:30
 | S→9:00～17:00