Spreadsheet: 745534d1629990418-if-formula-read-multiple-columns-and-check-for-result-and-return-name-in-other-column-sample
Sheet: Sheet1

Date | Name | CRN | 900 Number | Inspection | Air Brakes | Backing | Road Test | 1st Test Result | 1st Examiner | 2nd Test Date | Inspection2 | Air Brakes2 | Backing2 | Road Test2 | 2nd Test Result | 2nd Examiner | Reciept Number | Amount Paid | 3rd Test Date | Inspection3 | Air Brakes3 | Backing3 | Road Test3 | 3rd Test Result | 3rd Examiner
2021-06-18 00:00:00 | [NAME] | 40890 | 900252393 | Pass | Pass | Pass | Pass | Pass
2021-06-18 00:00:00 | bob | 40890 | 900190094 | Pass | Pass | Pass | Pass | Pass
2021-06-18 00:00:00 | bill | 40853 | 900150991 | Fail | Pass | N/A | N/A | Fail |  | 2021-07-02 00:00:00 | Pass | Pass | Fail | N/A | Fail |  | E008639 | 100 | 2021-07-23 00:00:00 | N/A | N/A | Pass | Pass | Pass
2021-06-18 00:00:00 | [NAME] | 40887 | 900059824 | Fail | Fail | N/A | N/A | Fail
2021-06-19 00:00:00 | [NAME] | 40853 | 900182676 | Fail | Fail | N/A | N/A | Fail |  | 2021-07-10 00:00:00 | Fail | Fail | N/A | N/A | Fail
2021-06-19 00:00:00 | phillip | 40853 | 900249662 | Fail | Fail | N/A | N/A | Fail |  | 2021-07-02 00:00:00 | Fail | Fail | N/A | N/A | Fail |  | E008665 | 100 | 2021-08-12 00:00:00 | Fail | Fail | N/A | N/A | Fail
2021-06-19 00:00:00 | willie | 40900 | 900166284 | Fail | Pass | N/A | N/A | Fail |  | 2021-07-03 00:00:00 | Pass | Pass | Pass | Pass | Pass
2021-06-19 00:00:00 | doug | 40901 | 900193491 | Fail | Fail | N/A | N/A | Fail |  | 2021-07-03 00:00:00 | Pass | Pass | Pass | Fail | Fail
2021-06-25 00:00:00 | [NAME] | 40901 | 900252166 | Pass | Pass | Pass | Fail | Fail |  | 2021-07-15 00:00:00 | N/A | N/A | N/A | Pass | Pass
2021-05-13 00:00:00 | mary | 40853 | 900250124 | Pass | Pass | Fail | N/A | Fail |  | 2021-06-25 00:00:00 | N/A | N/A | Fail | N/A | Fail |  | E008644 | 100 | 2021-07-23 00:00:00 | N/A | N/A | Pass | Pass | Pass
2021-06-26 00:00:00 | kate | 40853 | 900149864 | Fail | Pass | N/A | N/A | Fail |  | 2021-07-24 00:00:00 | Pass | Pass | Pass | Pass | Pass
2021-06-26 00:00:00 | [NAME] | 40901 | 900251784 | Fail | Fail | N/A | N/A | Pass |  | 2021-07-23 00:00:00 | Pass | Pass | Pass | Fail | Fail
2021-06-26 00:00:00 | gwen | 40853 | 900233981 | Pass | Pass | Pass | Fail | Fail |  | 2021-07-23 00:00:00 | Pass | Pass | Pass | Fail | Fail |  | E008675 | 100 | 2021-08-21 00:00:00 | N/A | N/A | N/A | Pass | Pass
2021-05-13 00:00:00 | [NAME] | 40853 | 900248401 | Pass | Pass | Fail | N/A | Fail |  | 2021-07-01 00:00:00 | N/A | N/A | Fail | N/A | Fail
2021-07-02 00:00:00 |  | 40853 | 900140981 | Fail | Pass | N/A | N/A | Fail |  | 2021-07-24 00:00:00 | Fail | Pass | N/A | N/A | Fail |  | M128231 | 100 | 2021-08-21 00:00:00 | Fail | Pass | N/A | N/A | Fail
2021-07-02 00:00:00 |  | 40900 | 900251106 | Pass | Fail | N/A | N/A | Fail |  | 2021-07-24 00:00:00 | Pass | Fail | N/A | N/A | Fail
2021-07-03 00:00:00 |  | 40900 | 900252676 | Pass | Pass | Pass | Fail | Fail |  | 2021-08-21 00:00:00 | N/A | N/A | N/A | Pass | Pass
2021-07-03 00:00:00 |  | 40890 | 900232732 | Fail | Fail | N/A | N/A | Fail |  | 2021-08-05 00:00:00 | Pass | Pass | Pass | Pass | Pass
2021-07-09 00:00:00 |  | 40890 | 900166023 | Fail | Fail | N/A | N/A | Fail
2021-06-11 00:00:00 |  | 40890 | 900249523 | Pass | Fail | N/A | N/A | Fail |  | 2021-07-09 00:00:00 | Pass | Pass | Pass | Pass | Pass
2021-06-11 00:00:00 |  | 40901 | 900188810 |  |  |  |  | Fail
2021-06-11 00:00:00 |  | 40901 | 900197733 | Pass | Pass | Fail | N/A | Fail |  | 2021-07-09 00:00:00 | Fail | Fail | N/A | N/A | Fail |  | E008656 | 100
2021-07-10 00:00:00 |  | 40890 | 900211178 | Fail | Fail | N/A | N/A | Fail |  | 2021-07-10 00:00:00 | Pass | Pass | Fail | N/A | Fail |  | E008654 | 100 | 2021-07-24 00:00:00 | N/A | N/A | Pass | Pass | Pass
2021-06-11 00:00:00 |  | 40890 | 900251544 |  |  |  |  | Fail
2021-07-10 00:00:00 |  | 40901 | 900237743 | Fail | Fail | N/A | N/A | Fail
2021-04-14 00:00:00 |  | 40878 | 900218759 | Fail | Fail | N/A | N/A | Fail |  | 2021-04-28 00:00:00 | Fail | Fail | N/A | N/A | Fail |  |  |  | 2021-07-17 00:00:00 | Pass | Pass | Pass | Pass | Pass
2021-04-07 00:00:00 |  | 40878 | 900250591 | Pass | Fail | N/A | N/A | Fail |  | 2021-04-13 00:00:00 | Fail | Fail | N/A | N/A | Fail |  |  |  | 2021-04-28 00:00:00 | Fail | Fail | N/A | N/A | Fail