Spreadsheet: 792444d1660908440-formula-with-multiple-matches-training-example-v2
Sheet: Trainers

Type | Trainer | Area | Job Title | P/O |  |  |  | Type | Trainer
 | [NAME] | Driver Services | Delivery Coach | PSI |  |  |  | Car | [NAME]
 | [NAME] | Driver Services | Technical Quality | OSI |  |  |  | Car | [NAME]
LGV | [NAME] | Driver Services | Driving Examiner | OSI |  |  |  | Car | [NAME]
 | [NAME] | Vehicle Services | [NAME] | PSI |  |  |  | Car | Clive Barber
LGV | [NAME] | Driver Services | Driving Examiner | OSI |  |  |  | Car | [NAME]
Car | [NAME] | Driver Services | LDTM | OSI |  |  |  | Car | [NAME]
 | [NAME] | Driver Services | LDTM | OSI |  |  |  | Car | [NAME]
 | [NAME] | Vehicle Services | [NAME] | PSI |  |  |  | Car | [NAME]
 | Clare Hazelwood | Driver Services | LDTM | OSI |  |  |  | Car | [NAME]
 | Clive Barber | Driver Services | Driving Examiner | OSI |  |  |  | Car | [NAME]
 | [NAME] | Vehicle Services | Delivery Coach | PSI |  |  |  | Car | [NAME]
 | [NAME] | Driver Services | LDTM | OSI |  |  |  | Car | [NAME]
Car | [NAME] | Driver Services | LDTM | OSI |  |  |  | Car | [NAME]
 | [NAME] | Driver Services | [NAME] | PSI |  |  |  | Car | [NAME]
Car | [NAME] | Driver Services | Driving Examiner | OSI |  |  |  | Car | [NAME]
 | [NAME] | Driver Services | Driving Examiner | OSI |  |  |  | Car | Jan Nascimento
 | [NAME] | Driver Services | LDTM | OSI |  |  |  | Car | [NAME]
 | [NAME] | Driver Services | LDTM | OSI |  |  |  | Car | [NAME]
 | Enforcement | Vehicle Services | Mixture of Enforcement Staff | OSI |  |  |  | Car | [NAME]
Car | [NAME] R | Driver Services | Driving Examiner | OSI |  |  |  | Car | [NAME]
Car/MC | [NAME] | Driver Services | Driving Examiner | OSI |  |  |  | Car | [NAME]
 | [NAME] | Driver Services | Driving Examiner | OSI |  |  |  | Car | [NAME]
Car | [NAME] | Driver Services | Technical Quality | OSI |  |  |  | Car | [NAME]
Car/MC | [NAME] | Driver Services | LDTM | OSI |  |  |  | Car | [NAME]
Car/MC | [NAME] | Driver Services | [NAME] | PSI |  |  |  | Car | [NAME]
 | [NAME] | Vehicle Services | [NAME] | PSI |  |  |  | Car | [NAME]
Car | Jan Nascimento | Driver Services | Driving Examiner | OSI |  |  |  | Car | [NAME]
 | [NAME] | Driver Services | LDTM | OSI |  |  |  | Car | [NAME]
Car | [NAME] | Driver Services | [NAME] | PSI |  |  |  | Car | [NAME]
 | [NAME] | Driver Services | Delivery Coach | PSI |  |  |  | Car | [NAME]
 | [NAME] | Vehicle Services | [NAME] | PSI |  |  |  | Car | [NAME]
 | [NAME] | Vehicle Services | Delivery Coach | PSI |  |  |  | Car | [NAME]
 | [NAME] | Vehicle Services | [NAME] | PSI |  |  |  | Car | [NAME]
Car/LGV | [NAME] | Driver Services | Driving Examiner | OSI |  |  |  | LGV | [NAME]
 | [NAME] | Driver Services | Delivery Coach | PSI |  |  |  | LGV | [NAME]
 | [NAME] | Driver Services | Delivery Coach | PSI |  |  |  | LGV | [NAME]
 | [NAME] | Driver Services | Driving Examiner | OSI |  |  |  | LGV | [NAME]
 | [NAME] | Driver Services | LDTM | OSI |  |  |  | LGV | [NAME]
 | [NAME] | Vehicle Services | [NAME] | PSI |  |  |  | LGV | [NAME]
Car/LGV | [NAME] | Driver Services | [NAME] | PSI |  |  |  | LGV | [NAME]
Car | [NAME] | Driver Services | LDTM | OSI |  |  |  | LGV | [NAME]
 | [NAME] | Driver Services | LDTM | OSI |  |  |  | LGV | [NAME]
 | [NAME] | Driver Services | LDTM | OSI |  |  |  | Motorcycle | [NAME]
Car | [NAME] | Driver Services | [NAME] | PSI |  |  |  | Motorcycle | [NAME]
Car | [NAME] | Driver Services | [NAME] | PSI |  |  |  | Motorcycle | [NAME]
 | [NAME] | Driver Services | Technical Quality | OSI |  |  |  | Motorcycle | [NAME]
Car/MC | [NAME] | Driver Services | [NAME] | PSI |  |  |  | Motorcycle | [NAME]
 | [NAME] | Driver Services | Driving Examiner | OSI |  |  |  | Motorcycle | [NAME]
LGV/MC | [NAME] | Driver Services | [NAME] | PSI
 | [NAME] | Driver Services | LDTM | OSI
LGV | [NAME] | Driver Services | [NAME] | PSI