Spreadsheet: 808585d1670524015-looking-up-two-cells-to-find-result-in-another-cell-match-and-index-example-rota-and-appt-number-planning
Sheet: Sheet1

 |  |  | WEEK 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Notes/Changes
 |  |  |  | Room | AMC - ROOM 1 | AMC - ROOM 2 | AMC - ROOM 3 | AMC - ROOM 4 | AMC - ROOM 5 | AMC - ROOM 6 | AMC - ROOM 7 | AMC - ROOM 8 (minor ops) | AMC - ROOM 9 (treatment rm) | AMC - GoTo RECEPTION | AMC - GoTo RECEPTION 2 | AMC - ROOM 10 HOT ROOM | E-consult Desk | HOME | HOME | CP - ROOM 1 | CP - ROOM 2 | CP - ROOM 3 | CP - ROOM 4 | CP - TR | CP - R | CP - ECG
 | Monday
WK 1 |  | 2022-12-05 00:00:00 | AM | Name |  | SL | EB |  |  |  |  |  |  | RP | AW |  |  |  |  |  |  | TM | ZS
 |  |  |  | Shift |  | [NAME] | S/D ACP |  |  |  |  |  |  | Go2GP | SIGNPOSTING & Results |  |  |  |  |  |  | ACP Green | RED BLOODS
 |  |  | PM | Name |  |  | EB |  | BR |  |  |  |  | RP | SL |  | AW |  |  |  |  | TM | ZS
 |  |  |  | Shift |  |  | S/D ACP |  | S/D GP |  |  |  |  | Go2GP | SIGNPOSTING & Results |  | HV ACP |  |  |  |  | S/D ACP | E Consults |  |  |  | Move BR back to AMC in the afternoon - more likely to be filled
 |  |  |  | Jobs |  |  |  |  |  |  |  |  |  | RP
 |  |  |  | Jobs |  |  |  |  |  |  |  |  |  | Extended Access ([NAME] only)
 | Tuesday |  | AM | Name |  | SL | J Wadey |  |  |  |  | RP |  | MH | TM |  |  | AW | JM |  |  | EB | YM
 |  |  |  | Shift |  | S/D ACP | [NAME] |  |  |  |  | Microsuction |  | Go2GP | SIGNPOSTING & Results |  |  | NH WR | PCN |  |  | REPORTS | RED BLOODS |  |  |  | MH to be Go2GP all day
 |  |  | PM | Name |  |  | TM | RP |  |  |  |  |  | MH | SL |  | J Wadey | AW | JM |  |  | EB | YM |  |  |  | [NAME] to move back to Coppice to do Imms
 |  |  |  | Shift |  |  | S/D ACP | S/D GP |  |  |  |  |  | Go2GP | SIGNPOSTING & Results |  | HV ACP | NH WR | [NAME] |  |  | Hyper | E Consults
 |  |  |  | Jobs |  |  | TM |  |  |  |  |  |  | YM
 |  |  |  | Jobs |  |  | Extended Access |  |  |  |  |  |  | Extended Access
 | Wednesday |  | AM | Name | J Wadey | ZS |  | TM |  |  | AW | JM or MH | MC | BR | EB |  |  |  |  |  |  |  | JM or MH
 |  |  |  | Shift | [NAME] | [NAME] |  | S/D ACP |  |  | [NAME] | Minor Ops Clinic | Minor Ops Clinic | Go2GP | SIGNPOSTING & Results |  |  |  |  |  |  |  | RED BLOODS |  |  |  | Alternate S/D GP with LTC for Zoe in the afternoon? So that JM can do some greens?
 |  |  | PM | Name | JM or ZS | ZS or MH | EB | J Wadey |  |  |  |  |  | BR | AW |  | TM |  |  |  |  |  | JM or MH |  |  |  | Or, Alternate JM and S/D GP with MH at Coppice?
 |  |  |  | Shift | S/D GP | [NAME] | ACP Green | S/D ACP |  |  |  |  |  | Go2GP | SIGNPOSTING & Results |  | HV ACP |  |  |  |  |  | E Consults |  |  |  | Who do to urines at Coppice? Can a nurse do instead?
 |  |  |  | Jobs |  |  |  |  |  |  |  |  |  | JM | AW |  | TM
 |  |  |  | Jobs |  |  |  |  |  |  |  |  |  | Extended Access | Extended Access |  | Extended Access
 | Thursday |  | AM | Name |  | SL |  |  | MH |  | AW |  |  | ZS | TM | J Wadey |  | JM |  | Social Prescribers |  |  | RP
 |  |  |  | Shift |  | [NAME] |  |  | Practice [NAME] |  | [NAME] |  |  | Go2GP | SIGNPOSTING & Results | S/D ACP |  | Practice [NAME] |  |  |  |  | RED BLOODS
 |  |  | PM | Name |  | SL |  |  | MH |  | AW |  |  | ZS | AW | J Wadey | TM |  |  | Social Prescribers |  |  | RP
 |  |  |  | Shift |  | HV ACP |  |  | S/D GP |  | S/D ACP |  |  | Go2GP | SIGNPOSTING & Results | ADHD | [NAME] |  |  |  |  |  | E Consults
 |  |  |  | Jobs |  |  | ?? |  | MH
 |  |  |  | Jobs |  |  | Extended Access |  | Extended Access
 | Friday |  | AM | Name |  | SL | J Wadey | YM |  |  |  |  |  | JM | TM |  |  |  |  |  |  |  | ZS
 |  |  |  | Shift |  | S/D ACP | [NAME] | GP Green |  |  |  |  |  | Go2GP | SIGNPOSTING & Results |  |  |  |  |  |  |  | RED BLOODS
 |  |  | PM | Name |  | SL |  | YM |  |  |  |  |  | JM | TM |  | J Wadey | MH | RP |  |  |  | ZS
 |  |  |  | Shift |  | S/D ACP |  | S/D GP |  |  |  |  |  | Go2GP | SIGNPOSTING & Results |  | HV ACP | [NAME] | [NAME] |  |  |  | E Consults
 |  |  |  | Jobs |  |  |  |  |  |  |  |  |  | Extended Access ([NAME] only) |  |  |  |  |  |  |  |  |  | Check Defib/Oxygen | [NAME]
 |  |  |  | Jobs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check Defib/Oxygen | [NAME]
 | Saturday |  | AM | Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ACP |  |  | Partner
 |  |  |  | Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Extended Access ([NAME] only) |  |  | Extended Access ([NAME] only)
 |  |  | PM | Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ACP |  |  | Partner
 |  |  |  | Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Extended Access ([NAME] only) |  |  | Extended Access ([NAME] only)
 |  |  |  | Jobs
 |  |  |  | Jobs
 | Same Day Appt
 | Medical Reports/Baby Checks
 | Same Day Appt
 | [NAME]
 | [NAME]
 | Same Day Appt
 | Same Day Appt
 | Dressings
 | Dressings
 | Bloods
 | B12
 | ABPM
 | DM1
 | HRT
 | Ear Checks
 | General [NAME]
 | [NAME]
 | DM2
 | DM2
 | [NAME]
 | [NAME]
 | Smears
 | Imms
 | Mental Health - SMI
 | NHS Health Checks
 | Home Visits
 | Nursing Home Ward Rounds
 | Asthma