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

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 |  | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35
Appt Type | JM | JM No. | MH | MH No. | RP | RP No. | YM | YM No. | BR | BR No. | ZS | ZS No. | AW | AW No. | SL | SL No. | EB | EB No. | TM | TM No. | J Wadey | J Wadey No. | JK | JK No. | AD | AD No. | RR | RR No. | CM | CM No. | MC | MC No. | SOC | SOC No. | LL | LL No.
Same Day Appt | S/D GP | 10 | S/D GP | 10 | S/D GP | 10 | S/D GP | 10 | S/D GP | 10 | S/D GP | 10 | S/D GP | 0 | S/D GP | 0 | S/D GP | 0 | S/D GP | 0 | S/D GP | 0 | S/D GP | 0 | S/D GP | 0 | S/D GP | 0 | S/D GP | 0 | S/D GP | 0 | S/D GP | 0 | S/D GP | 0
Medical Reports/Baby Checks | RED BLOODS | 2 | RED BLOODS | 2 | RED BLOODS | 2 | RED BLOODS | 2 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0
Same Day Appt | S/D ACP | 0 | S/D ACP | 0 | S/D ACP | 0 | S/D ACP | 0 | S/D ACP | 0 | S/D ACP | 0 | S/D ACP | 10 | S/D ACP | 10 | S/D ACP | 10 | S/D ACP | 10 | S/D ACP | 10 | S/D ACP | 0 | S/D ACP | 0 | S/D ACP | 0 | S/D ACP | 0 | S/D ACP | 0 | S/D ACP | 0 | S/D ACP | 0
[NAME] | [NAME] | 0 | [NAME] | 0 | [NAME] | 0 | [NAME] | 0 | [NAME] | 0 | [NAME] | 0 | [NAME] | 10 | [NAME] | 10 | [NAME] | 10 | [NAME] | 10 | [NAME] | 10 | [NAME] | 0 | [NAME] | 0 | [NAME] | 0 | [NAME] | 0 | [NAME] | 0 | [NAME] | 0 | [NAME] | 0
[NAME] | ACP Green | 0 | ACP Green | 0 | ACP Green | 0 | ACP Green | 0 | ACP Green | 0 | ACP Green | 0 | ACP Green | 10 | ACP Green | 10 | ACP Green | 10 | ACP Green | 10 | ACP Green | 10 | ACP Green | 0 | ACP Green | 0 | ACP Green | 0 | ACP Green | 0 | ACP Green | 0 | ACP Green | 0 | ACP Green | 0
Same Day Appt | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0 | RED BLOODS | 0
Same Day Appt | E Consults | 0 | E Consults | 0 | E Consults | 0 | E Consults | 0 | E Consults | 0 | E Consults | 0 | E Consults | 0 | E Consults | 0 | E Consults | 0 | E Consults | 0 | E Consults | 0 | E Consults | 0 | E Consults | 0 | E Consults | 0 | E Consults | 0 | E Consults | 0 | E Consults | 0 | E Consults | 0
Dressings | DRESSINGS - AM | 0 | DRESSINGS - AM | 0 | DRESSINGS - AM | 0 | DRESSINGS - AM | 0 | DRESSINGS - AM | 0 | DRESSINGS - AM | 0 | DRESSINGS - AM | 0 | DRESSINGS - AM | 0 | DRESSINGS - AM | 0 | DRESSINGS - AM | 0 | DRESSINGS - AM | 0 | DRESSINGS - AM |  | DRESSINGS - AM |  | DRESSINGS - AM |  | DRESSINGS - AM |  | DRESSINGS - AM | 0 | DRESSINGS - AM | 0 | DRESSINGS - AM | 0
Dressings | DRESSINGS - PM | 0 | DRESSINGS - PM | 0 | DRESSINGS - PM | 0 | DRESSINGS - PM | 0 | DRESSINGS - PM | 0 | DRESSINGS - PM | 0 | DRESSINGS - PM | 0 | DRESSINGS - PM | 0 | DRESSINGS - PM | 0 | DRESSINGS - PM | 0 | DRESSINGS - PM | 0 | DRESSINGS - PM |  | DRESSINGS - PM |  | DRESSINGS - PM |  | DRESSINGS - PM |  | DRESSINGS - PM | 0 | DRESSINGS - PM | 0 | DRESSINGS - PM | 0
Bloods | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic |  | Bloods Clinic |  | Bloods Clinic |  | Bloods Clinic |  | Bloods Clinic |  | Bloods Clinic |  | Bloods Clinic
B12 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic |  | Bloods Clinic |  | Bloods Clinic |  | Bloods Clinic |  | Bloods Clinic |  | Bloods Clinic |  | Bloods Clinic
ABPM | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic |  | Bloods Clinic |  | Bloods Clinic |  | Bloods Clinic |  | Bloods Clinic |  | Bloods Clinic |  | Bloods Clinic
DM1 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic | 0 | Bloods Clinic |  | Bloods Clinic |  | Bloods Clinic |  | Bloods Clinic |  | Bloods Clinic |  | Bloods Clinic |  | Bloods Clinic
HRT | Nurse Session - AM | 0 | Nurse Session - AM | 0 | Nurse Session - AM | 0 | Nurse Session - AM | 0 | Nurse Session - AM | 0 | Nurse Session - AM | 0 | Nurse Session - AM | 0 | Nurse Session - AM | 0 | Nurse Session - AM | 0 | Nurse Session - AM | 0 | Nurse Session - AM | 0 | Nurse Session - AM |  | Nurse Session - AM |  | Nurse Session - AM | 0 | Nurse Session - AM | 0 | Nurse Session - AM | 0 | Nurse Session - AM | 0 | Nurse Session - AM | 0
Ear Checks | Nurse Session - PM | 0 | Nurse Session - PM | 0 | Nurse Session - PM | 0 | Nurse Session - PM | 0 | Nurse Session - PM | 0 | Nurse Session - PM | 0 | Nurse Session - PM | 0 | Nurse Session - PM | 0 | Nurse Session - PM | 0 | Nurse Session - PM | 0 | Nurse Session - PM | 0 | Nurse Session - PM |  | Nurse Session - PM |  | Nurse Session - PM |  | Nurse Session - PM |  | Nurse Session - PM | 0 | Nurse Session - PM | 0 | Nurse Session - PM | 0
General [NAME] | Nurse Session - PM | 0 | Nurse Session - PM | 0 | Nurse Session - PM | 0 | Nurse Session - PM | 0 | Nurse Session - PM | 0 | Nurse Session - PM | 0 | Nurse Session - PM | 0 | Nurse Session - PM | 0 | Nurse Session - PM | 0 | Nurse Session - PM | 0 | Nurse Session - PM | 0 | Nurse Session - PM |  | Nurse Session - PM |  | Nurse Session - PM | 18 | Nurse Session - PM | 17 | Nurse Session - PM | 0 | Nurse Session - PM | 0 | Nurse Session - PM | 0
[NAME] | [NAME] | 10 | [NAME] | 10 | [NAME] | 10 | [NAME] | 10 | [NAME] | 10 | [NAME] | 10 | [NAME] | 0 | [NAME] | 0 | [NAME] | 0 | [NAME] | 0 | [NAME] | 0 | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] | 0 | [NAME] | 0 | [NAME] | 0
DM2 | Nurse DM Clinic - AM | 0 | Nurse DM Clinic - AM | 0 | Nurse DM Clinic - AM | 0 | Nurse DM Clinic - AM | 0 | Nurse DM Clinic - AM | 0 | Nurse DM Clinic - AM | 0 | Nurse DM Clinic - AM | 0 | Nurse DM Clinic - AM | 0 | Nurse DM Clinic - AM | 0 | Nurse DM Clinic - AM | 0 | Nurse DM Clinic - AM | 0 | Nurse DM Clinic - AM |  | Nurse DM Clinic - AM |  | Nurse DM Clinic - AM |  | Nurse DM Clinic - AM |  | Nurse DM Clinic - AM | 0 | Nurse DM Clinic - AM | 0 | Nurse DM Clinic - AM | 0
DM2 | Nurse DM Clinic - PM | 0 | Nurse DM Clinic - PM | 0 | Nurse DM Clinic - PM | 0 | Nurse DM Clinic - PM | 0 | Nurse DM Clinic - PM | 0 | Nurse DM Clinic - PM | 0 | Nurse DM Clinic - PM | 0 | Nurse DM Clinic - PM | 0 | Nurse DM Clinic - PM | 0 | Nurse DM Clinic - PM | 0 | Nurse DM Clinic - PM | 0 | Nurse DM Clinic - PM |  | Nurse DM Clinic - PM |  | Nurse DM Clinic - PM |  | Nurse DM Clinic - PM |  | Nurse DM Clinic - PM | 0 | Nurse DM Clinic - PM | 0 | Nurse DM Clinic - PM | 0
[NAME] | ADHD | 0 | ADHD | 0 | ADHD | 0 | ADHD | 0 | ADHD | 0 | ADHD | 0 | ADHD | 0 | ADHD | 0 | ADHD | 0 | ADHD | 0 | ADHD |  | ADHD | 0 | ADHD | 0 | ADHD | 0 | ADHD | 0 | ADHD | 0 | ADHD | 0 | ADHD | 0
[NAME] | GP Green | 12 | GP Green | 12 | GP Green | 12 | GP Green | 12 | GP Green | 12 | GP Green | 12 | GP Green | 0 | GP Green | 0 | GP Green | 0 | GP Green | 0 | GP Green | 0 | GP Green | 0 | GP Green | 0 | GP Green | 0 | GP Green | 0 | GP Green | 0 | GP Green | 0 | GP Green | 0
Smears | Smears | 0 | Smears | 0 | Smears | 0 | Smears | 0 | Smears | 0 | Smears | 0 | Smears | 0 | Smears | 0 | Smears | 0 | Smears | 0 | Smears | 0 | Smears |  | Smears |  | Smears |  | Smears |  | Smears | 0 | Smears | 0 | Smears | 0
Imms | Imms | 0 | Imms | 0 | Imms | 0 | Imms | 0 | Imms | 0 | Imms | 0 | Imms | 0 | Imms | 0 | Imms | 0 | Imms | 0 | Imms | 0 | Imms |  | Imms |  | Imms |  | Imms |  | Imms | 0 | Imms | 0 | Imms | 0
Mental Health - SMI | Mental Health | 0 | Mental Health | 0 | Mental Health | 0 | Mental Health | 0 | Mental Health | 0 | Mental Health | 0 | Mental Health | 0 | Mental Health | 0 | Mental Health | 0 | Mental Health | 0 | Mental Health | 0 | Mental Health | 0 | Mental Health | 0 | Mental Health | 0 | Mental Health | 0 | Mental Health | 0 | Mental Health | 0 | Mental Health | 0
 | HCA Session | 0 | HCA Session | 0 | HCA Session | 0 | HCA Session | 0 | HCA Session | 0 | HCA Session | 0 | HCA Session | 0 | HCA Session | 0 | HCA Session | 0 | HCA Session | 0 | HCA Session | 0 | HCA Session | 0 | HCA Session | 0 | HCA Session | 0 | HCA Session | 0 | HCA Session | 0 | HCA Session | 0 | HCA Session | 0
NHS Health Checks | NHS HEALTH CHECKS | 0 | NHS HEALTH CHECKS | 0 | NHS HEALTH CHECKS | 0 | NHS HEALTH CHECKS | 0 | NHS HEALTH CHECKS | 0 | NHS HEALTH CHECKS | 0 | NHS HEALTH CHECKS | 0 | NHS HEALTH CHECKS | 0 | NHS HEALTH CHECKS | 0 | NHS HEALTH CHECKS | 0 | NHS HEALTH CHECKS | 0 | NHS HEALTH CHECKS |  | NHS HEALTH CHECKS |  | NHS HEALTH CHECKS |  | NHS HEALTH CHECKS |  | NHS HEALTH CHECKS | 0 | NHS HEALTH CHECKS | 0 | NHS HEALTH CHECKS | 0
Home Visits | HV ACP | 0 | HV ACP | 0 | HV ACP | 0 | HV ACP | 0 | HV ACP | 0 | HV ACP | 0 | HV ACP | 12 | HV ACP | 8 | HV ACP | 0 | HV ACP | 12 | HV ACP | 8 | HV ACP | 0 | HV ACP | 0 | HV ACP | 0 | HV ACP | 0 | HV ACP | 0 | HV ACP | 0 | HV ACP | 0
Nursing Home Ward Rounds | NH WR | 0 | NH WR | 0 | NH WR |  | NH WR | 0 | NH WR | 0 | NH WR | 0 | NH WR | 0 | NH WR | 0 | NH WR | 0 | NH WR | 0 | NH WR | 0 | NH WR | 0 | NH WR | 0 | NH WR | 0 | NH WR | 0 | NH WR | 0 | NH WR | 0 | NH WR | 0
Asthma | Asthma Clinic | 0 | Asthma Clinic | 0 | Asthma Clinic | 0 | Asthma Clinic | 0 | Asthma Clinic | 0 | Asthma Clinic | 0 | Asthma Clinic | 0 | Asthma Clinic | 0 | Asthma Clinic | 0 | Asthma Clinic | 0 | Asthma Clinic | 0 | Asthma Clinic | 0 | Asthma Clinic | 0 | Asthma Clinic | 0 | Asthma Clinic | 8 | Asthma Clinic | 0 | Asthma Clinic | 0 | Asthma Clinic | 0