Spreadsheet: 723025d1615481742-index-match-vs-vlookup-or-is-there-a-better-way-sample_pr
Sheet: CERT PR TOTAL

Job Number | Employee First Name | Employee Last Name | Employee Number | Date | Job Description | City | State | Job Start | Job Complete | Earning Code | Hours Amount | Note
ALCO-G001^ | [NAME] | Balderas | 11341 | 2020-04-23 00:00:00 | ALCO-G001^ VRAF | AURORA | CO | 2020-04-23 00:00:00 | 2020-05-13 00:00:00 | Reg | 3
ALCO-G001^ | Juan | [NAME] | 11345 | 2020-04-23 00:00:00 | ALCO-G001^ VRAF | AURORA | CO | 2020-04-23 00:00:00 | 2020-05-13 00:00:00 | Reg | 3
ALCO-G001^ | [NAME] | [NAME] | 11287 | 2020-04-23 00:00:00 | ALCO-G001^ VRAF | AURORA | CO | 2020-04-23 00:00:00 | 2020-05-13 00:00:00 | Reg | 3
ALCO-G001^ | Fabian | Oliva | 11346 | 2020-04-23 00:00:00 | ALCO-G001^ VRAF | AURORA | CO | 2020-04-23 00:00:00 | 2020-05-13 00:00:00 | Reg | 3
ALCO-G001^ | [NAME] | Guzman | 11015 | 2020-05-13 00:00:00 | ALCO-G001^ VRAF | AURORA | CO | 2020-04-23 00:00:00 | 2020-05-13 00:00:00 | Reg | 9.5
ALCO-G001^ | [NAME] | Lara | 11018 | 2020-05-13 00:00:00 | ALCO-G001^ VRAF | AURORA | CO | 2020-04-23 00:00:00 | 2020-05-13 00:00:00 | Reg | 9.5
ALCO-G001^ | Alfredo | Rodriguez | 11086 | 2020-05-13 00:00:00 | ALCO-G001^ VRAF | AURORA | CO | 2020-04-23 00:00:00 | 2020-05-13 00:00:00 | Reg | 8
APME-G001*^ | Gustavo | Aguilar Espinoza | 11028 | 2020-08-27 00:00:00 | APME-G001*^ DIA HTG WATER EXP LINES | DENVER | CO | 2020-08-27 00:00:00 | 00:00:00 | OT | 0.5
APME-G001*^ | Gustavo | Aguilar Espinoza | 11028 | 2020-08-27 00:00:00 | APME-G001*^ DIA HTG WATER EXP LINES | DENVER | CO | 2020-08-27 00:00:00 | 00:00:00 | OT | 1.0667
APME-G001*^ | Gustavo | Aguilar Espinoza | 11028 | 2020-08-27 00:00:00 | APME-G001*^ DIA HTG WATER EXP LINES | DENVER | CO | 2020-08-27 00:00:00 | 00:00:00 | Reg | 5
APME-G001*^ | Gustavo | Aguilar Espinoza | 11028 | 2020-08-27 00:00:00 | APME-G001*^ DIA HTG WATER EXP LINES | DENVER | CO | 2020-08-27 00:00:00 | 00:00:00 | Reg | 5.9333
APME-G001*^ | [NAME] | Campos | 11305 | 2020-08-27 00:00:00 | APME-G001*^ DIA HTG WATER EXP LINES | DENVER | CO | 2020-08-27 00:00:00 | 00:00:00 | Reg | 5
APME-G001*^ | [NAME] | Campos | 11305 | 2020-08-27 00:00:00 | APME-G001*^ DIA HTG WATER EXP LINES | DENVER | CO | 2020-08-27 00:00:00 | 00:00:00 | Reg | 5.5
APME-G001*^ | [NAME] | Navarro | 11032 | 2020-08-27 00:00:00 | APME-G001*^ DIA HTG WATER EXP LINES | DENVER | CO | 2020-08-27 00:00:00 | 00:00:00 | Reg | 5
APME-G001*^ | [NAME] | Navarro | 11032 | 2020-08-27 00:00:00 | APME-G001*^ DIA HTG WATER EXP LINES | DENVER | CO | 2020-08-27 00:00:00 | 00:00:00 | Reg | 6
APME-G001*^ | Alberto | [NAME] | 11016 | 2020-08-27 00:00:00 | APME-G001*^ DIA HTG WATER EXP LINES | DENVER | CO | 2020-08-27 00:00:00 | 00:00:00 | OT | 0.5
APME-G001*^ | Alberto | [NAME] | 11016 | 2020-08-27 00:00:00 | APME-G001*^ DIA HTG WATER EXP LINES | DENVER | CO | 2020-08-27 00:00:00 | 00:00:00 | OT | 3
APME-G001*^ | Alberto | [NAME] | 11016 | 2020-08-27 00:00:00 | APME-G001*^ DIA HTG WATER EXP LINES | DENVER | CO | 2020-08-27 00:00:00 | 00:00:00 | Reg | 5
APME-G001*^ | Alberto | [NAME] | 11016 | 2020-08-27 00:00:00 | APME-G001*^ DIA HTG WATER EXP LINES | DENVER | CO | 2020-08-27 00:00:00 | 00:00:00 | Reg | 4
APME-G001*^ | Gustavo | Aguilar Espinoza | 11028 | 2020-08-28 00:00:00 | APME-G001*^ DIA HTG WATER EXP LINES | DENVER | CO | 2020-08-27 00:00:00 | 00:00:00 | OT | 5
APME-G001*^ | Gustavo | Aguilar Espinoza | 11028 | 2020-08-28 00:00:00 | APME-G001*^ DIA HTG WATER EXP LINES | DENVER | CO | 2020-08-27 00:00:00 | 00:00:00 | OT | 3.5
APME-G001*^ | [NAME] | Navarro | 11032 | 2020-08-28 00:00:00 | APME-G001*^ DIA HTG WATER EXP LINES | DENVER | CO | 2020-08-27 00:00:00 | 00:00:00 | OT | 1
APME-G001*^ | [NAME] | Navarro | 11032 | 2020-08-28 00:00:00 | APME-G001*^ DIA HTG WATER EXP LINES | DENVER | CO | 2020-08-27 00:00:00 | 00:00:00 | OT | 1.5
APME-G001*^ | [NAME] | Navarro | 11032 | 2020-08-28 00:00:00 | APME-G001*^ DIA HTG WATER EXP LINES | DENVER | CO | 2020-08-27 00:00:00 | 00:00:00 | Reg | 4
APME-G001*^ | Alberto | [NAME] | 11016 | 2020-08-28 00:00:00 | APME-G001*^ DIA HTG WATER EXP LINES | DENVER | CO | 2020-08-27 00:00:00 | 00:00:00 | OT | 3
APME-G001*^ | Alberto | [NAME] | 11016 | 2020-08-28 00:00:00 | APME-G001*^ DIA HTG WATER EXP LINES | DENVER | CO | 2020-08-27 00:00:00 | 00:00:00 | OT | 5