Spreadsheet: 826518d1682067055-import-data-from-another-sheet-depending-on-a-job-ref-testsheet-help1
Sheet: Data for certificate 

Job ref | Start time | Completion time | [NAME] | Name | Customer | Make | Model | [NAME] | BMW Model | [NAME] | [NAME] | Mercedes Model | Nissan Model | Volkswagen Model | New Model | Registration No | Mileage | VIN No | Order Number | Vehicle scan documents | Systems that have been calibrated | Within specified Limits for manufacturer | Coded Control Unit | Outstanding safety defects | Notes | Work Carried Out | Equipment Used | ADAS Safety Status | Reason for work | Technician | Price | Certs
6 | 2023-04-05 22:21:20 | 2023-04-05 22:21:48 | anonymous | Leaf Heap | AGL | Mercedes |  |  |  |  |  | A-Class |  |  |  | ABCDEF | 4553 | RDHGERHEBHR | 798786 | Pre and Post Scan | Radar; | Yes | None; |  |  | ADAS Calibration | Texa; | Calibration Complete | Panel/bumper removal & refit; | Leaf Heap
7 | 2023-04-05 22:22:45 | 2023-04-05 22:23:11 | anonymous | Leaf Heap | DLG | Citroen |  |  |  | C1 |  |  |  |  |  | 123456 | 12345 | DRHXTJHTJFTXJTFXJ | 552254 | Pre and Post Scan | Radar; | Yes | None; |  |  | ADAS Calibration | Texa; | Calibration Complete | Panel/bumper removal & refit; | Leaf Heap
8 | 2023-04-05 22:24:33 | 2023-04-05 22:25:16 | anonymous | Leaf Heap | TSL | Nissan |  |  |  |  |  |  | Juke |  |  | QWERTY | 43443 | ESTGHZERHDHXH | 23274 | Pre and Post Scan | 360 Camera; | Yes | None; |  |  | ADAS Calibration | Autel; | Calibration Complete | Component removal & refit;Panel/bumper removal & refit; | [NAME]
9 | 2023-04-05 22:26:22 | 2023-04-05 22:26:56 | anonymous | Leaf Heap | KV | Ford |  |  |  |  | Puma |  |  |  |  | 98765 | 5345 | TDSRGSERHZT | 314 | Pre and Post Scan | Radar; | Yes | Radar; |  |  | Coding & Calibration | Texa;Manufacture Software; | Calibration Complete | Component removal & refit;Panel/bumper removal & refit; | [NAME]
10 | 2023-04-12 22:31:03 | 2023-04-12 22:31:34 | anonymous | Leaf Heap | Komo | BMW |  |  | X5 |  |  |  |  |  |  | ASDFGH | 575 | GSDGS | 265489 | Pre and Post Scan | Radar; | Yes | Airbag; |  |  | Coding & Calibration | Texa;Manufacture Software; | Calibration Complete | Component replacement;Presence of an error;Panel/bumper removal & refit; | [NAME]
11 | 2023-04-12 22:35:08 | 2023-04-12 22:43:33 | anonymous | Leaf Heap | Sacre | Volkswagen |  |  |  |  |  |  |  | Polo |  | 147258 | 47778 | FDHD | 2001 | Pre and Post Scan | Radar; | Yes | None; |  |  | ADAS Calibration | Texa; | Calibration Complete | Presence of an error;Panel/bumper removal & refit; | [NAME]
12 | 2023-04-17 13:11:19 | 2023-04-17 13:11:46 | anonymous | Leaf Heap | AGL | Volkswagen |  |  |  |  |  |  |  | Golf |  | QAZWSX | 13213 | hfdhdfh | 4745 | Pre and Post Scan | Radar; | Yes | Radar; |  |  | Coding & Calibration | Autel; | Calibration Complete | Presence of an error;Panel/bumper removal & refit; | [NAME]
13 | 2023-04-05 22:22:45 | 2023-04-05 22:23:11 | anonymous | Leaf Heap | DLG | Audi | A1 |  |  | C1 |  |  |  |  |  | 369258 | 6987 | DRHXTJHTJFTXJTFXJ | 215 | Pre and Post Scan | Radar; | Yes | None; |  |  | Coding & Calibration | Texa; | Calibration Complete | Panel/bumper removal & refit; | Leaf Heap
14 | 2023-04-05 22:24:33 | 2023-04-05 22:25:16 | anonymous | Leaf Heap | TSL | Nissan | QashqaI |  |  |  |  |  | Juke |  |  | VFRBGT | 43443 | ESTGHZERHDHXH | 265897 | Pre and Post Scan | 360 Camera; | Yes | None; |  |  | Coding & Calibration