Spreadsheet: 273163d1382627468-simple-vlookup-assistance-don-sample1
Sheet: Template

 |  |  |  |  | ABC Company |  |  |  |  |  |  | Product Code | Description
 |  |  |  |  | Technician Job Card |  |  |  |  |  |  | 255-14-10 | [NAME] 90 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 255-14-12 | [NAME] 90 DEG
 |  |  |  |  |  |  | DB No. |  |  |  |  | 255-21-16 | [NAME] 90 DEG
 |  |  |  |  |  |  | Date: |  |  |  |  | 260-04-04 | BSPP SWEPT 45 DEG
 |  |  |  |  |  |  | Fleet/Machine: |  |  |  |  | 260-06-06 | BSPP SWEPT 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 260-08-08 | BSPP SWEPT 45 DEG
 |  | Client: |  | ________________________________________________________ |  |  |  |  |  |  |  | 260-10-08
 |  | Location: |  | ________________________________________________________ |  |  |  |  |  |  |  | 260-10-10 | BSPP SWEPT 45 DEG
 |  | Contact: |  | ________________________________________________________ |  |  |  |  |  |  |  | 260-16-16 | BSPP SWEPT 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 264-07-04 | [NAME] 45 DEG
 |  | JOB Description |  |  |  |  |  |  |  |  |  | 264-08-04 | [NAME] 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 264-09-04 | [NAME] 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 264-09-06 | [NAME] 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 264-12-06 | [NAME] 45 DEG
 |  | Product Code | Quantity | Description |  |  |  |  |  |  |  | 264-14-10 | [NAME] 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 264-21-12 | [NAME] 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 264-26-20 | [NAME] 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 273-12-04 | DKL MALE
 |  |  |  |  |  |  |  |  |  |  |  | 273-16-06 | DKL MALE
 |  |  |  |  |  |  |  |  |  |  |  | 273-18-06 | DKL MALE
 |  |  |  |  |  |  |  |  |  |  |  | 273-30-12 | DKL MALE
 |  |  |  |  |  |  |  |  |  |  |  | 274-14-04 | DKL FEMALE
 |  |  |  |  |  |  |  |  |  |  |  | 274-22-08 | DKL FEMALE
 |  |  |  |  |  |  |  |  |  |  |  | 274-26-10 | DKL FEMALE
 |  |  |  |  |  |  |  |  |  |  |  | 274-30-12 | DKL FEMALE
 |  |  |  |  |  |  |  |  |  |  |  | 274-36-16 | DKL FEMALE
 |  |  |  |  |  |  |  |  |  |  |  | 274-45-20 | DKL FEMALE
 |  | Date: |  |  |  |  |  |  |  |  |  | 275-14-04 | DKS MALE
 |  | Time Started: | 00:00:00 |  |  |  |  |  |  |  |  | 275-16-04 | DKS MALE
 |  | Time Finished: | 00:00:00 |  |  |  |  |  |  |  |  | 275-18-04 | DKS MALE
 |  | Total Reg: | 00:00:00 |  |  |  |  |  |  |  |  | 275-24-08 | DKS MALE
 |  | Total O/T: | 0 |  |  |  |  |  |  |  |  | 275-30-10 | DKS MALE
 |  |  |  |  |  | Job Order No: |  |  |  |  |  | 275-36-12 | DKS MALE
 |  | [NAME] |  |  |  | Authorisation Signature: |  |  |  |  |  | 276-14-04 | DKS FEMALE
 |  | [NAME] |  |  |  |  |  |  |  |  |  | 276-16-04 | DKS FEMALE
 |  | Total Dist |  |  |  | Name: (print) |  |  |  |  |  | 276-20-06 | DKS FEMALE
 |  |  |  |  |  |  |  |  |  |  |  | 276-22-06 | DKS FEMALE
 |  |  |  |  |  |  |  |  |  |  |  | 276-30-10 | DKS FEMALE
 |  |  |  |  |  |  |  |  |  |  |  | 276-42-16 | DKS FEMALE
 |  |  |  |  |  |  |  |  |  |  |  | 276-52-20 | DKS FEMALE
 |  |  |  |  |  |  |  |  |  |  |  | 283-14-04 | DKL SWEPT 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 283-16-06 | DKL SWEPT 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 283-22-08 | DKL SWEPT 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 283-26-10 | DKL SWEPT 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 283-30-12 | DKL SWEPT 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 283-36-16 | DKL SWEPT 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 283-45-20 | DKL SWEPT 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 284-12-04 | DKL SWEPT 90 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 284-14-04 | DKL SWEPT 90 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 284-16-06 | DKL SWEPT 90 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 284-26-10 | DKL SWEPT 90 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 284-30-12 | DKL SWEPT 90 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 284-45-20 | DKL SWEPT 90 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 285-14-04 | DKS SWEPT 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 285-16-04 | DKS SWEPT 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 285-18-04 | DKS SWEPT 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 285-20-06 | DKS SWEPT 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 285-22-06 | DKS SWEPT 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 285-24-08 | DKS SWEPT 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 285-30-10 | DKS SWEPT 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 285-36-12 | DKS SWEPT 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 285-42-16 | DKS SWEPT 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 286-14-04 | DKS SWEPT 90 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 286-16-04 | DKS SWEPT 90 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 286-18-04 | DKS SWEPT 90 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 286-20-06 | DKS SWEPT 90 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 286-22-06 | DKS SWEPT 90 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 286-24-08 | DKS SWEPT 90 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 286-36-12 | DKS SWEPT 90 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 286-42-16 | DKS SWEPT 90 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 286-52-20
 |  |  |  |  |  |  |  |  |  |  |  | 2SC-06 | [NAME] 2SC ENDLESS
 |  |  |  |  |  |  |  |  |  |  |  | 2SN-04 | [NAME] 2SN 1/4".
 |  |  |  |  |  |  |  |  |  |  |  | 2SN-06 | [NAME] 2SN 3/8".
 |  |  |  |  |  |  |  |  |  |  |  | 2SN-08 | [NAME] 2SN 1/2".
 |  |  |  |  |  |  |  |  |  |  |  | 2SN-10 | [NAME] 2SN 5/8".
 |  |  |  |  |  |  |  |  |  |  |  | 2SN-12 | [NAME] 2SN 3/4".
 |  |  |  |  |  |  |  |  |  |  |  | 2SN-16 | [NAME] 2SN 1".
 |  |  |  |  |  |  |  |  |  |  |  | 2SN-32 | [NAME] 2SN 2".
 |  |  |  |  |  |  |  |  |  |  |  | 3001-04 | MALE TIP (PROBE) ENERPAC 700 BAR
 |  |  |  |  |  |  |  |  |  |  |  | 3002-04 | COUP BODY (CARRIER) ENERPAC 700 BAR
 |  |  |  |  |  |  |  |  |  |  |  | 3003-04 | DUST CAP
 |  |  |  |  |  |  |  |  |  |  |  | 3004-04 | DUST PLUG
 |  |  |  |  |  |  |  |  |  |  |  | 30CT-04 | 1/4" SPECTRA 30CT CONSTANT PRESSURE 3000PSI
 |  |  |  |  |  |  |  |  |  |  |  | 30CT-06 | 3/8" SPECTRA 30CT CONSTANT PRESSURE 3000PSI
 |  |  |  |  |  |  |  |  |  |  |  | 30CT-08 | 1/2" SPECTRA 30CT CONSTANT PRESSURE 3000PSI
 |  |  |  |  |  |  |  |  |  |  |  | 30CTX2-04 | 1/4" SPECTRA 30CT TWINLINE CONSTANT PRESSURE 3000PSI
 |  |  |  |  |  |  |  |  |  |  |  | 30CTX2-06 | 3/8" SPECTRA 30CT TWINLINE CONSTANT PRESSURE 3000PSI
 |  |  |  |  |  |  |  |  |  |  |  | 3130-03 | 3130-03    HOSE - 100R7 BLACK
 |  |  |  |  |  |  |  |  |  |  |  | 323-32-32 | SAE FLANGE STR
 |  |  |  |  |  |  |  |  |  |  |  | 3236-08-08
 |  |  |  |  |  |  |  |  |  |  |  | 3236-12-12
 |  |  |  |  |  |  |  |  |  |  |  | 3236-16-12 | SAE 6000 FLANGE STR
 |  |  |  |  |  |  |  |  |  |  |  | 359-08-08 | SAE FLANGE 90 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 359-10-10
 |  |  |  |  |  |  |  |  |  |  |  | 359-12-12 | SAE FLANGE 90 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 359-16-16 | SAE FLANGE 90 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 3596-12-12
 |  |  |  |  |  |  |  |  |  |  |  | 368-08-08 | SAE FLANGE 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 368-20-20 | SAE FLANGE 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 3686-12-12
 |  |  |  |  |  |  |  |  |  |  |  | 3686-16-12 | SAE 6000 FLANGE 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 3686-16-16 | SAE 6000 FLANGE 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 3686-20-16 | SAE 6000 FLANGE 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 3686-20-20 | SAE 6000 FLANGE 45 DEG
 |  |  |  |  |  |  |  |  |  |  |  | 3DHO-06-06 | THERMOPLASTIC [NAME] R7 3/8" TWIN LINE
 |  |  |  |  |  |  |  |  |  |  |  | 3R80-08 | 3R80-08    HOSE - 100R8 BLACK
 |  |  |  |  |  |  |  |  |  |  |  | 4001-04 | MALE TIP (PROBE) AG. INTERCHANGE
 |  |  |  |  |  |  |  |  |  |  |  | 4001-04B | MALE TIP (PROBE)
 |  |  |  |  |  |  |  |  |  |  |  | 4001-06 | MALE TIP (PROBE) AG. INTERCHANGE
 |  |  |  |  |  |  |  |  |  |  |  | 4001-06B | MALE TIP (PROBE)
 |  |  |  |  |  |  |  |  |  |  |  | 4001-08 | MALE TIP (PROBE) AG. INTERCHANGE
 |  |  |  |  |  |  |  |  |  |  |  | 4001-08B | MALE TIP (PROBE)
 |  |  |  |  |  |  |  |  |  |  |  | 4001-12B | MALE TIP (PROBE)
 |  |  |  |  |  |  |  |  |  |  |  | 4001-16 | MALE TIP (PROBE) AG. INTERCHANGE
 |  |  |  |  |  |  |  |  |  |  |  | 4001-16B | MALE TIP (PROBE)
 |  |  |  |  |  |  |  |  |  |  |  | 4002-04 | COUPLING BODY (CARRIER) AG. INTERCHANGE
 |  |  |  |  |  |  |  |  |  |  |  | 4002-04B | COUPLING BODY (CARRIER)
 |  |  |  |  |  |  |  |  |  |  |  | 4002-06 | COUPLING BODY (CARRIER) AG. INTERCHANGE
 |  |  |  |  |  |  |  |  |  |  |  | 4002-06B | COUPLING BODY (CARRIER)
 |  |  |  |  |  |  |  |  |  |  |  | 4002-08 | COUPLING BODY (CARRIER) AG. INTERCHANGE
 |  |  |  |  |  |  |  |  |  |  |  | 4002-08B | COUPLING BODY (CARRIER)
 |  |  |  |  |  |  |  |  |  |  |  | 4002-12 | COUPLING BODY (CARRIER) AG. INTERCHANGE
 |  |  |  |  |  |  |  |  |  |  |  | 4002-12B | COUPLING BODY (CARRIER)
 |  |  |  |  |  |  |  |  |  |  |  | 4002-16 | COUPLING BODY (CARRIER) AG. INTERCHANGE
 |  |  |  |  |  |  |  |  |  |  |  | 4002-16B | COUPLING BODY (CARRIER)
 |  |  |  |  |  |  |  |  |  |  |  | 401-12-12 | BSP FEMALE
 |  |  |  |  |  |  |  |  |  |  |  | 401-16-16 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | 405-17-12 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | 405-26-20 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | 423-12-12 | SAE FLANGE STR