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

trainer |  |  |  |  | Type | Trainer | Location
[NAME] | Not available |  |  |  | LGV | [NAME]
[NAME] | Not available please speak to [NAME] |  |  |  | LGV | [NAME]
[NAME] | Available Slough not 12th August |  |  |  | Car | [NAME] | Leeds (Hillcrest House)
[NAME] | Pending |  |  |  | Car | [NAME] | [NAME]
[NAME] | Not available |  |  |  | LGV | [NAME]
[NAME] | Available Leeds poss Gosforth or [NAME] |  |  |  | Car | [NAME] | Leeds (Hillcrest House)
Clive Barber | Return to Operations |  |  |  | Car | Clive Barber | [NAME]
[NAME] | Available   Leeds preferably Gosforth occ |  |  |  | Car | [NAME] | Cambridge
[NAME] | Returned to Operations  LGV Testing NB |  |  |  | Car | [NAME] | Cambridge
[NAME] | Available Brentwood / Slough / Farnborough occ others |  |  |  | Car | [NAME] | Leeds (Hillcrest House)
[NAME] | Available Chadderton - progress check 11th |  |  |  | Car | [NAME] | Leeds (Hillcrest House)
[NAME] | Return to Operations |  |  |  | Car | [NAME]
[NAME] | Available |  |  |  | Car | [NAME]
[NAME] | [NAME] |  |  |  | Motorcycle | [NAME]
[NAME] | Available |  |  |  | Car | [NAME]
[NAME] | Available |  |  |  | Car | [NAME]
[NAME] | Not available A/L |  |  |  | Car | [NAME]
[NAME] | Available Gosforth or virtual Not 11th or 12th Aug |  |  |  | Motorcycle | [NAME]
Jan Nascimento |  |  |  |  | Car | [NAME]
[NAME] | Available  [NAME] and occasionally others |  |  |  | Motorcycle | [NAME]
[NAME] | If [NAME] no A/L needed A/L 12th Aug |  |  |  | Car | [NAME]
[NAME] |  |  |  |  | Car | Jan Nascimento
[NAME] |  |  |  |  | Car | [NAME]
[NAME] | Available Plymouth or virtual |  |  |  | LGV | [NAME]
[NAME] |  |  |  |  | Car | [NAME]
[NAME] | Not available A/L |  |  |  | Car | [NAME]
[NAME] | A/L 12th Aug |  |  |  | Motorcycle | [NAME]
[NAME] | Return to Operations |  |  |  | Car | [NAME]
[NAME] | Not available ( testing |  |  |  | Car | [NAME]
[NAME] | Available Brentwood, Cambridge, Slough |  |  |  | LGV | [NAME]
[NAME] |  |  |  |  | Car | [NAME]
[NAME] |  |  |  |  | LGV | [NAME]
[NAME] | Not available |  |  |  | Car | [NAME]
[NAME] |  |  |  |  | LGV | [NAME]
[NAME] | Available |  |  |  | Car | [NAME]
[NAME] |  |  |  |  | Car | [NAME]
[NAME] |  |  |  |  | Car | [NAME]
[NAME] | Available Slough occ Avonmouth & Cambridge |  |  |  | Car | [NAME]
[NAME] | Not available please speak to [NAME] |  |  |  | Car | [NAME]
[NAME] | Available Farnborough |  |  |  | Car | [NAME]
Clare Hazelwood | A/L 1st to 12th August |  |  |  | Car | [NAME]
[NAME] | Not available A/L |  |  |  | Motorcycle | [NAME]
[NAME] |  |  |  |  | Car | [NAME]
[NAME] | [NAME] occasionally others |  |  |  | Car | [NAME]
[NAME] | Pending |  |  |  | LGV | [NAME]
[NAME] | Not available A/L |  |  |  | Motorcycle | [NAME]
[NAME] Senior | Not available please speak to [NAME] |  |  |  | Car | [NAME]
[NAME] | Not available |  |  |  | LGV | [NAME]
[NAME] | Not available A/L
[NAME] | Available Cambridge
[NAME] | Available Cambridge
[NAME] | Return to Operations
[NAME] | Not available please speak to [NAME]
[NAME] | Not available please speak to [NAME]
[NAME] | Return to Operations
[NAME] | Not available please speak to [NAME]
[NAME] | Return to Operations
[NAME] | ( [NAME])