Spreadsheet: 775778d1649318008-using-index-and-match-to-look-up-employee-id-skill-code-and-return-relevant-exp-date-skills-matrix
Sheet: DATA

employeeno | skill | competency | fromdt | to date
2194 | CERTIVT&A | Qualified | 2021-03-11 00:00:00 | 2040-01-01 00:00:00
2194 | CQL001 | Qualified | 2021-07-19 00:00:00 | 2023-07-19 00:00:00
2194 | CQL015 | Qualified | 2020-07-30 00:00:00 | 2022-07-30 00:00:00
2194 | CQL016 | Qualified | 2020-07-30 00:00:00 | 2022-07-30 00:00:00
2194 | CQR001 | Qualified | 2021-10-03 00:00:00 | 2023-10-03 00:00:00
2194 | CQR002 | Qualified | 2021-10-03 00:00:00 | 2023-10-03 00:00:00
2194 | CQR007 | Qualified | 2022-01-17 00:00:00 | 2024-01-17 00:00:00
2194 | CQR008 | Qualified | 2022-01-17 00:00:00 | 2024-01-17 00:00:00
2194 | CQR009 | Qualified | 2021-07-19 00:00:00 | 2023-07-19 00:00:00
2194 | CQR010 | Qualified | 2021-07-19 00:00:00 | 2023-07-19 00:00:00
2194 | CQR011 | Qualified | 2020-07-30 00:00:00 | 2022-07-30 00:00:00
2194 | CQR012 | Qualified | 2020-07-30 00:00:00 | 2022-07-30 00:00:00
2194 | CQR013 | Qualified | 2020-07-30 00:00:00 | 2022-07-30 00:00:00
2194 | CQR014 | Qualified | 2020-07-30 00:00:00 | 2022-07-30 00:00:00
2194 | CQR015 | Qualified | 2020-07-30 00:00:00 | 2022-07-30 00:00:00
2194 | CQR016 | Qualified | 2020-07-30 00:00:00 | 2022-07-30 00:00:00
2194 | CQR017 | Qualified | 2021-05-13 00:00:00 | 2023-05-13 00:00:00
2194 | CQR018 | Qualified | 2021-05-13 00:00:00 | 2023-05-13 00:00:00
2194 | CQR019 | Qualified | 2021-05-13 00:00:00 | 2023-05-13 00:00:00
2194 | CQR021 | Qualified | 2021-05-13 00:00:00 | 2023-05-13 00:00:00
2194 | CQR023 | Qualified | 2022-01-17 00:00:00 | 2024-01-17 00:00:00
2194 | CQR024 | Qualified | 2022-01-17 00:00:00 | 2024-01-17 00:00:00
2194 | CQR049 | Qualified | 2022-02-07 00:00:00 | 2024-02-07 00:00:00
2194 | CQR050 | Qualified | 2022-02-07 00:00:00 | 2024-02-07 00:00:00
2194 | CQR051 | Qualified | 2022-02-07 00:00:00 | 2024-02-07 00:00:00
2194 | CQR052 | Qualified | 2022-02-07 00:00:00 | 2024-02-07 00:00:00
2194 | CQY001 | Qualified | 2021-10-03 00:00:00 | 2023-10-03 00:00:00
2194 | CQY002 | Qualified | 2022-01-17 00:00:00 | 2024-01-17 00:00:00
2194 | CQY003 | Qualified | 2022-01-17 00:00:00 | 2024-01-17 00:00:00
2194 | CQY004 | Qualified | 2022-01-17 00:00:00 | 2024-01-17 00:00:00
2194 | CQY005 | Qualified | 2022-01-17 00:00:00 | 2024-01-17 00:00:00
2194 | CQY006 | Qualified | 2020-07-30 00:00:00 | 2022-07-30 00:00:00
2194 | CQY010 | Qualified | 2020-07-30 00:00:00 | 2022-07-30 00:00:00
2194 | CQY011 | Qualified | 2022-01-20 00:00:00 | 2024-01-20 00:00:00
2194 | DRV06 | Qualified | 2020-02-18 00:00:00 | 2040-01-01 00:00:00
2194 | DRV07 | Qualified | 2020-04-06 00:00:00 | 2040-01-01 00:00:00
2194 | EQP21QR | Qualified | 2020-04-06 00:00:00 | 2040-01-01 00:00:00
2194 | EQP22 | Qualified | 2020-04-06 00:00:00 | 2040-01-01 00:00:00
2194 | HLTAID001 | Qualified | 2020-02-27 00:00:00 | 2040-01-01 00:00:00
2194 | HLTAID003 | Qualified | 2020-02-27 00:00:00 | 2040-01-01 00:00:00
2194 | LMS02 | Qualified | 2021-12-30 00:00:00 | 2040-01-01 00:00:00
2194 | [NAME] | Qualified | 2020-02-12 00:00:00 | 2040-01-01 00:00:00
2194 | OPS030CQCNA01 | Qualified | 2022-02-10 00:00:00 | 2024-02-10 00:00:00
2194 | OPS030CQCNA02 | Qualified | 2022-02-10 00:00:00 | 2024-02-10 00:00:00
2194 | OPS030CQCNA03 | Qualified | 2022-02-10 00:00:00 | 2024-02-10 00:00:00
2194 | OPS030CQCNA04 | Qualified | 2022-02-10 00:00:00 | 2024-02-10 00:00:00
2194 | OPS030CQRCS | Qualified | 2022-02-10 00:00:00 | 2024-02-10 00:00:00
2194 | OPS05 | Qualified | 2020-02-13 00:00:00 | 2040-01-01 00:00:00
2194 | OPS07 | Qualified | 2021-12-06 00:00:00 | 2040-01-01 00:00:00
2194 | OPS08 | Qualified | 2021-12-09 00:00:00 | 2040-01-01 00:00:00
2194 | OPS09 | Qualified | 2021-12-09 00:00:00 | 2040-01-01 00:00:00
2194 | OPS10 | Qualified | 2021-12-13 00:00:00 | 2040-01-01 00:00:00
2194 | OPS11 | Qualified | 2020-02-27 00:00:00 | 2023-02-27 00:00:00
2194 | OPS15 | Qualified | 2020-02-12 00:00:00 | 2040-01-01 00:00:00
2194 | OPS21 | Qualified | 2022-02-01 00:00:00 | 2023-02-01 00:00:00
2194 | OPS38 | Qualified | 2020-09-29 00:00:00 | 2022-09-29 00:00:00
2194 | OPSRVF | Qualified | 2022-01-27 00:00:00 | 2023-01-27 00:00:00
2194 | OPSSARC | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | ORACOC | Qualified | 2020-09-21 00:00:00 | 2040-01-01 00:00:00
2194 | ORAENV | Qualified | 2020-02-12 00:00:00
2194 | ORAHR | Qualified | 2020-02-10 00:00:00 | 2040-01-01 00:00:00
2194 | PUAFER005 | Qualified | 2021-03-25 00:00:00 | 2040-01-01 00:00:00
2194 | PUAFER006 | Qualified | 2021-03-25 00:00:00 | 2040-01-01 00:00:00
2194 | PUAFER008 | Qualified | 2021-03-25 00:00:00 | 2040-01-01 00:00:00
2194 | PWR28 | Qualified | 2020-04-06 00:00:00 | 2040-01-01 00:00:00
2194 | QUALTRNDVR | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | RIIVEH201D | Qualified | 2020-02-19 00:00:00 | 2040-01-01 00:00:00
2194 | TAE40116 | Qualified | 2021-03-11 00:00:00 | 2040-01-01 00:00:00
2194 | TAEASS401 | Qualified | 2021-01-21 00:00:00 | 2040-01-01 00:00:00
2194 | TAEASS402 | Qualified | 2021-01-21 00:00:00 | 2040-01-01 00:00:00
2194 | TAEASS403 | Qualified | 2021-01-21 00:00:00 | 2040-01-01 00:00:00
2194 | TAEASS502 | Qualified | 2021-01-29 00:00:00 | 2040-01-01 00:00:00
2194 | TAEDEL301 | Qualified | 2021-01-21 00:00:00 | 2040-01-01 00:00:00
2194 | TAEDEL401 | Qualified | 2021-03-11 00:00:00 | 2040-01-01 00:00:00
2194 | TAEDEL402 | Qualified | 2021-03-11 00:00:00 | 2040-01-01 00:00:00
2194 | TAEDES401 | Qualified | 2021-01-29 00:00:00 | 2040-01-01 00:00:00
2194 | TAEDES402 | Qualified | 2021-01-29 00:00:00 | 2040-01-01 00:00:00
2194 | TAELLN411 | Qualified | 2021-03-11 00:00:00 | 2040-01-01 00:00:00
2194 | TLI42615 | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | [NAME] | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | TLIB3026 | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | TLIB3075 | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | TLIB3118 | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | TLIB4078 | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | [NAME] | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | TLIB4080 | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | TLIC2078 | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | TLIC3027 | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | TLIC4019 | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | TLIC4023 | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | TLIC4026 | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | TLIC4073 | Qualified | 2021-12-09 00:00:00 | 2040-01-01 00:00:00
2194 | TLIC4074 | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | TLID1001 | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | TLIE2007 | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | TLIF0004 | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | TLIF1001 | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | TLIF2010 | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | TLIF2080 | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | TLIF3058 | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | [NAME] | Qualified | 2018-04-18 00:00:00 | 2040-01-01 00:00:00
2194 | TNPHW01 | Qualified | 2020-02-15 00:00:00
2194 | TNPHW02 | Qualified | 2020-02-15 00:00:00
2194 | TNPHW03 | Qualified | 2020-02-13 00:00:00
2194 | TNPHW07 | Qualified | 2021-11-19 00:00:00
2194 | TNPHW09 | Qualified | 2020-02-12 00:00:00 | 2023-02-12 00:00:00
2194 | TNPHW10 | Qualified | 2020-02-13 00:00:00
2194 | TNPHW11 | Qualified | 2020-02-12 00:00:00 | 2023-02-12 00:00:00
2194 | TNPHW12 | Qualified | 2021-08-06 00:00:00 | 2023-08-06 00:00:00
2194 | TNPHW13 | Qualified | 2020-02-14 00:00:00 | 2023-02-14 00:00:00
2194 | TNPHW14 | Qualified | 2020-02-13 00:00:00 | 2023-02-13 00:00:00
2194 | [NAME] | Qualified | 2020-02-15 00:00:00 | 2023-02-15 00:00:00
2194 | TNPHW17 | Qualified | 2020-02-11 00:00:00 | 2040-01-01 00:00:00
2194 | VEH48 | Qualified | 2020-04-06 00:00:00 | 2040-01-01 00:00:00