Spreadsheet: 842910d1694892325-vlookup-help-example
Sheet: INVENTORY

TYPE | SUPER ASM # | PcMARK | [NAME] | UoM | DELIVERED QTY | LENGTH | DELIVERED? | DELIVERY DATE |  |  | STRUCTURE | TYPE | PcMARK | [NAME] | NEEDED QTY | DELIVERED QTY
CANTILEVER | 9860-06-MC | 06-PST | POST | EA | 1 |  | YES | 2023-09-16 00:00:00 |  |  | 9860-01-MC | CANTILEVER | 01-PST | 01-POST ASSEMBLY | 1
CANTILEVER | 9860-06-MC | 06-MA | MAST | EA | 1 |  | YES | 2023-09-16 00:00:00 |  |  | 9860-01-MC | CANTILEVER | 01-MA | 01-MAST ARM ASSEMBLY | 1
CANTILEVER | 9860-06-MC | 06-C1 | SS BEAM | EA |  |  |  | 2023-09-16 00:00:00 |  |  | 9860-01-MC | CANTILEVER | 01-ST | 01-SIGN SUPPORT TEE ASSEMBLY | 4
CANTILEVER | 9860-06-MC | 06-C2 | SS BEAM | EA |  |  |  | 2023-09-16 00:00:00 |  |  | 9860-01-MC | CANTILEVER | 01-UBA1 | 01-U-BOLT 1 ASSEMBLY | 8
CANTILEVER | 9860-06-MC | 06-ST | SS TEE | EA | 4 |  | YES | 2023-09-16 00:00:00 |  |  | 9860-01-MC | CANTILEVER | 01-C1 | 01-SIGN SUPPORT CHANNEL 1 | 3
CANTILEVER | 9860-07-MC | 07-PST | POST | EA | 1 |  | YES | 2023-09-16 00:00:00 |  |  | 9860-01-MC | CANTILEVER | 01-C2 | 01-SIGN SUPPORT CHANNEL 2 | 1
CANTILEVER | 9860-07-MC | 07-MA | MAST | EA | 1 |  | YES | 2023-09-16 00:00:00 |  |  | 9860-01-MC | CANTILEVER | 01-PL6 | 01-PLATE 6 (HAND HOLE COVER) | 2
CANTILEVER | 9860-07-MC | 07-C1 | SS BEAM | EA |  |  |  | 2023-09-16 00:00:00 |  |  | 9860-01-MC | CANTILEVER | 01-N1 | 01-NEOPRENE 1 (HAND HOLE COVER GASKET) | 2
CANTILEVER | 9860-07-MC | 07-C2 | SS BEAM | EA |  |  |  | 2023-09-16 00:00:00 |  |  | 9860-01-MC | CANTILEVER | HEX BOLT | 1-8x5 INCH LONG STRUCTURAL HEX BOLT | 28
CANTILEVER | 9860-07-MC | 07-ST | SS TEE | EA | 4 |  | YES | 2023-09-16 00:00:00 |  |  | 9860-01-MC | CANTILEVER | HEX NUT | 1-8 STRUCTURAL HEX NUT | 28
CANTILEVER |  | ALL | U-BOLTS W HARDWARE | EA | 71 |  |  | 2023-09-16 00:00:00 |  |  | 9860-01-MC | CANTILEVER | WASHER | 1" FLAT WASHER-NARROW | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-01-MC | CANTILEVER | DTI | 1" DTI WASHER | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-01-MC | CANTILEVER | HEX BOLT | 3/4-10x2 INCH LONG STRUCTURAL HEX BOLT | 8
 |  |  |  |  |  |  |  |  |  |  | 9860-01-MC | CANTILEVER | WASHER | 3/4" FLAT WASHER F436 GLV-INCH-TYPE A AND B | 16
 |  |  |  |  |  |  |  |  |  |  | 9860-01-MC | CANTILEVER | HEX NUT | 3/4-10 STRUCTURAL HEX NUT | 8
 |  |  |  |  |  |  |  |  |  |  | 9860-01-MC | CANTILEVER | CAP SCREW | 1/4-20X5/8 INCH LONG HEX CAP SCREW | 8
 |  |  |  |  |  |  |  |  |  |  | 9860-02-MC | CANTILEVER | 02-PST | 02-POST ASSEMBLY | 1
 |  |  |  |  |  |  |  |  |  |  | 9860-02-MC | CANTILEVER | 02-MA | 02-MAST ARM ASSEMBLY | 1
 |  |  |  |  |  |  |  |  |  |  | 9860-02-MC | CANTILEVER | 02-ST | 02-SIGN SUPPORT TEE ASSEMBLY | 4
 |  |  |  |  |  |  |  |  |  |  | 9860-02-MC | CANTILEVER | 02-UBA1 | 02-U-BOLT 1 ASSEMBLY | 8
 |  |  |  |  |  |  |  |  |  |  | 9860-02-MC | CANTILEVER | 02-C1 | 02-SIGN SUPPORT CHANNEL 1 | 3
 |  |  |  |  |  |  |  |  |  |  | 9860-02-MC | CANTILEVER | 02-C2 | 02-SIGN SUPPORT CHANNEL 2 | 1
 |  |  |  |  |  |  |  |  |  |  | 9860-02-MC | CANTILEVER | 02-PL6 | 02-PLATE 6 (HAND HOLE COVER) | 2
 |  |  |  |  |  |  |  |  |  |  | 9860-02-MC | CANTILEVER | 02-N1 | 02-NEOPRENE 1 (HAND HOLE COVER GASKET) | 2
 |  |  |  |  |  |  |  |  |  |  | 9860-02-MC | CANTILEVER | HEX BOLT | 1-8x5 INCH LONG STRUCTURAL HEX BOLT | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-02-MC | CANTILEVER | HEX NUT | 1-8 STRUCTURAL HEX NUT | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-02-MC | CANTILEVER | WASHER | 1" FLAT WASHER-NARROW | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-02-MC | CANTILEVER | DTI | 1" DTI WASHER | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-02-MC | CANTILEVER | HEX BOLT | 3/4-10x2 INCH LONG STRUCTURAL HEX BOLT | 8
 |  |  |  |  |  |  |  |  |  |  | 9860-02-MC | CANTILEVER | WASHER | 3/4" FLAT WASHER F436 GLV-INCH-TYPE A AND B | 16
 |  |  |  |  |  |  |  |  |  |  | 9860-02-MC | CANTILEVER | HEX NUT | 3/4-10 STRUCTURAL HEX NUT | 8
 |  |  |  |  |  |  |  |  |  |  | 9860-02-MC | CANTILEVER | CAP SCREW | 1/4-20X5/8 INCH LONG HEX CAP SCREW | 8
 |  |  |  |  |  |  |  |  |  |  | 9860-03-MC | CANTILEVER | 03-PST | 03-POST ASSEMBLY | 1
 |  |  |  |  |  |  |  |  |  |  | 9860-03-MC | CANTILEVER | 03-MA | 03-MAST ARM ASSEMBLY | 1
 |  |  |  |  |  |  |  |  |  |  | 9860-03-MC | CANTILEVER | 03-ST | 03-SIGN SUPPORT TEE ASSEMBLY | 4
 |  |  |  |  |  |  |  |  |  |  | 9860-03-MC | CANTILEVER | 03-UBA1 | 03-U-BOLT 1 ASSEMBLY | 8
 |  |  |  |  |  |  |  |  |  |  | 9860-03-MC | CANTILEVER | 03-C1 | 03-SIGN SUPPORT CHANNEL 1 | 3
 |  |  |  |  |  |  |  |  |  |  | 9860-03-MC | CANTILEVER | 03-C2 | 03-SIGN SUPPORT CHANNEL 2 | 1
 |  |  |  |  |  |  |  |  |  |  | 9860-03-MC | CANTILEVER | 03-PL6 | 03-PLATE 6 (HAND HOLE COVER) | 2
 |  |  |  |  |  |  |  |  |  |  | 9860-03-MC | CANTILEVER | 03-N1 | 03-NEOPRENE 1 (HAND HOLE COVER GASKET) | 2
 |  |  |  |  |  |  |  |  |  |  | 9860-03-MC | CANTILEVER | HEX BOLT | 1-8x5 INCH LONG STRUCTURAL HEX BOLT | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-03-MC | CANTILEVER | HEX NUT | 1-8 STRUCTURAL HEX NUT | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-03-MC | CANTILEVER | WASHER | 1" FLAT WASHER-NARROW | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-03-MC | CANTILEVER | DTI | 1" DTI WASHER | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-03-MC | CANTILEVER | HEX BOLT | 3/4-10x2 INCH LONG STRUCTURAL HEX BOLT | 8
 |  |  |  |  |  |  |  |  |  |  | 9860-03-MC | CANTILEVER | WASHER | 3/4" FLAT WASHER F436 GLV-INCH-TYPE A AND B | 16
 |  |  |  |  |  |  |  |  |  |  | 9860-03-MC | CANTILEVER | HEX NUT | 3/4-10 STRUCTURAL HEX NUT | 8
 |  |  |  |  |  |  |  |  |  |  | 9860-03-MC | CANTILEVER | CAP SCREW | 1/4-20X5/8 INCH LONG HEX CAP SCREW | 8
 |  |  |  |  |  |  |  |  |  |  | 9860-04-MC | CANTILEVER | 04-PST | 04-POST ASSEMBLY | 1
 |  |  |  |  |  |  |  |  |  |  | 9860-04-MC | CANTILEVER | 04-MA | 04-MAST ARM ASSEMBLY | 1
 |  |  |  |  |  |  |  |  |  |  | 9860-04-MC | CANTILEVER | 04-ST | 04-SIGN SUPPORT TEE ASSEMBLY | 4
 |  |  |  |  |  |  |  |  |  |  | 9860-04-MC | CANTILEVER | 04-UBA1 | 04-U-BOLT 1 ASSEMBLY | 8
 |  |  |  |  |  |  |  |  |  |  | 9860-04-MC | CANTILEVER | 04-C1 | 04-SIGN SUPPORT CHANNEL 1 | 3
 |  |  |  |  |  |  |  |  |  |  | 9860-04-MC | CANTILEVER | 04-C2 | 04-SIGN SUPPORT CHANNEL 2 | 1
 |  |  |  |  |  |  |  |  |  |  | 9860-04-MC | CANTILEVER | 04-PL6 | 04-PLATE 6 (HAND HOLE COVER) | 2
 |  |  |  |  |  |  |  |  |  |  | 9860-04-MC | CANTILEVER | 04-N1 | 04-NEOPRENE 1 (HAND HOLE COVER GASKET) | 2
 |  |  |  |  |  |  |  |  |  |  | 9860-04-MC | CANTILEVER | HEX BOLT | 1-8x5 INCH LONG STRUCTURAL HEX BOLT | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-04-MC | CANTILEVER | HEX NUT | 1-8 STRUCTURAL HEX NUT | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-04-MC | CANTILEVER | WASHER | 1" FLAT WASHER-NARROW | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-04-MC | CANTILEVER | DTI | 1" DTI WASHER | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-04-MC | CANTILEVER | HEX BOLT | 3/4-10x2 INCH LONG STRUCTURAL HEX BOLT | 8
 |  |  |  |  |  |  |  |  |  |  | 9860-04-MC | CANTILEVER | WASHER | 3/4" FLAT WASHER F436 GLV-INCH-TYPE A AND B | 16
 |  |  |  |  |  |  |  |  |  |  | 9860-04-MC | CANTILEVER | HEX NUT | 3/4-10 STRUCTURAL HEX NUT | 8
 |  |  |  |  |  |  |  |  |  |  | 9860-04-MC | CANTILEVER | CAP SCREW | 1/4-20X5/8 INCH LONG HEX CAP SCREW | 8
 |  |  |  |  |  |  |  |  |  |  | 9860-05-MC | CANTILEVER | 05-PST | 05-POST ASSEMBLY | 1
 |  |  |  |  |  |  |  |  |  |  | 9860-05-MC | CANTILEVER | 05-MA | 05-MAST ARM ASSEMBLY | 1
 |  |  |  |  |  |  |  |  |  |  | 9860-05-MC | CANTILEVER | 05-ST | 05-SIGN SUPPORT TEE ASSEMBLY | 5
 |  |  |  |  |  |  |  |  |  |  | 9860-05-MC | CANTILEVER | 05-UBA1 | 05-U-BOLT 1 ASSEMBLY | 10
 |  |  |  |  |  |  |  |  |  |  | 9860-05-MC | CANTILEVER | 05-C1 | 05-SIGN SUPPORT CHANNEL 1 | 3
 |  |  |  |  |  |  |  |  |  |  | 9860-05-MC | CANTILEVER | 05-C2 | 05-SIGN SUPPORT CHANNEL 2 | 2
 |  |  |  |  |  |  |  |  |  |  | 9860-05-MC | CANTILEVER | 05-PL6 | 05-PLATE 6 (HAND HOLE COVER) | 2
 |  |  |  |  |  |  |  |  |  |  | 9860-05-MC | CANTILEVER | 05-N1 | 05-NEOPRENE 1 (HAND HOLE COVER GASKET) | 2
 |  |  |  |  |  |  |  |  |  |  | 9860-05-MC | CANTILEVER | HEX BOLT | 1-8x5 INCH LONG STRUCTURAL HEX BOLT | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-05-MC | CANTILEVER | HEX NUT | 1-8 STRUCTURAL HEX NUT | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-05-MC | CANTILEVER | WASHER | 1" FLAT WASHER-NARROW | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-05-MC | CANTILEVER | DTI | 1" DTI WASHER | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-05-MC | CANTILEVER | HEX BOLT | 3/4-10x2 INCH LONG STRUCTURAL HEX BOLT | 10
 |  |  |  |  |  |  |  |  |  |  | 9860-05-MC | CANTILEVER | WASHER | 3/4" FLAT WASHER F436 GLV-INCH-TYPE A AND B | 20
 |  |  |  |  |  |  |  |  |  |  | 9860-05-MC | CANTILEVER | HEX NUT | 3/4-10 STRUCTURAL HEX NUT | 10
 |  |  |  |  |  |  |  |  |  |  | 9860-05-MC | CANTILEVER | CAP SCREW | 1/4-20X5/8 INCH LONG HEX CAP SCREW | 8
 |  |  |  |  |  |  |  |  |  |  | 9860-06-MC | CANTILEVER | 06-PST | 06-POST ASSEMBLY | 1
 |  |  |  |  |  |  |  |  |  |  | 9860-06-MC | CANTILEVER | 06-MA | 06-MAST ARM ASSEMBLY | 1
 |  |  |  |  |  |  |  |  |  |  | 9860-06-MC | CANTILEVER | 06-ST | 06-SIGN SUPPORT TEE ASSEMBLY | 4
 |  |  |  |  |  |  |  |  |  |  | 9860-06-MC | CANTILEVER | 06-UBA1 | 06-U-BOLT 1 ASSEMBLY | 8
 |  |  |  |  |  |  |  |  |  |  | 9860-06-MC | CANTILEVER | 06-C1 | 06-SIGN SUPPORT CHANNEL 1 | 3
 |  |  |  |  |  |  |  |  |  |  | 9860-06-MC | CANTILEVER | 06-C2 | 06-SIGN SUPPORT CHANNEL 2 | 1
 |  |  |  |  |  |  |  |  |  |  | 9860-06-MC | CANTILEVER | 06-PL6 | 06-PLATE 6 (HAND HOLE COVER) | 2
 |  |  |  |  |  |  |  |  |  |  | 9860-06-MC | CANTILEVER | 06-N1 | 06-NEOPRENE 1 (HAND HOLE COVER GASKET) | 2
 |  |  |  |  |  |  |  |  |  |  | 9860-06-MC | CANTILEVER | HEX BOLT | 1-8x5 INCH LONG STRUCTURAL HEX BOLT | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-06-MC | CANTILEVER | HEX NUT | 1-8 STRUCTURAL HEX NUT | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-06-MC | CANTILEVER | WASHER | 1" FLAT WASHER-NARROW | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-06-MC | CANTILEVER | DTI | 1" DTI WASHER | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-06-MC | CANTILEVER | HEX BOLT | 3/4-10x2 INCH LONG STRUCTURAL HEX BOLT | 8
 |  |  |  |  |  |  |  |  |  |  | 9860-06-MC | CANTILEVER | WASHER | 3/4" FLAT WASHER F436 GLV-INCH-TYPE A AND B | 16
 |  |  |  |  |  |  |  |  |  |  | 9860-06-MC | CANTILEVER | HEX NUT | 3/4-10 STRUCTURAL HEX NUT | 8
 |  |  |  |  |  |  |  |  |  |  | 9860-06-MC | CANTILEVER | CAP SCREW | 1/4-20X5/8 INCH LONG HEX CAP SCREW | 8
 |  |  |  |  |  |  |  |  |  |  | 9860-07-MC | CANTILEVER | 07-PST | 07-POST ASSEMBLY | 1
 |  |  |  |  |  |  |  |  |  |  | 9860-07-MC | CANTILEVER | 07-MA | 07-MAST ARM ASSEMBLY | 1
 |  |  |  |  |  |  |  |  |  |  | 9860-07-MC | CANTILEVER | 07-ST | 07-SIGN SUPPORT TEE ASSEMBLY | 4
 |  |  |  |  |  |  |  |  |  |  | 9860-07-MC | CANTILEVER | 07-UBA1 | 07-U-BOLT 1 ASSEMBLY | 8
 |  |  |  |  |  |  |  |  |  |  | 9860-07-MC | CANTILEVER | 07-C1 | 07-SIGN SUPPORT CHANNEL 1 | 3
 |  |  |  |  |  |  |  |  |  |  | 9860-07-MC | CANTILEVER | 07-C2 | 07-SIGN SUPPORT CHANNEL 2 | 1
 |  |  |  |  |  |  |  |  |  |  | 9860-07-MC | CANTILEVER | 07-PL6 | 07-PLATE 6 (HAND HOLE COVER) | 2
 |  |  |  |  |  |  |  |  |  |  | 9860-07-MC | CANTILEVER | 07-N1 | 07-NEOPRENE 1 (HAND HOLE COVER GASKET) | 2
 |  |  |  |  |  |  |  |  |  |  | 9860-07-MC | CANTILEVER | HEX BOLT | 1-8x5 INCH LONG STRUCTURAL HEX BOLT | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-07-MC | CANTILEVER | HEX NUT | 1-8 STRUCTURAL HEX NUT | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-07-MC | CANTILEVER | WASHER | 1" FLAT WASHER-NARROW | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-07-MC | CANTILEVER | DTI | 1" DTI WASHER | 28
 |  |  |  |  |  |  |  |  |  |  | 9860-07-MC | CANTILEVER | HEX BOLT | 3/4-10x2 INCH LONG STRUCTURAL HEX BOLT | 8
 |  |  |  |  |  |  |  |  |  |  | 9860-07-MC | CANTILEVER | WASHER | 3/4" FLAT WASHER F436 GLV-INCH-TYPE A AND B | 16
 |  |  |  |  |  |  |  |  |  |  | 9860-07-MC | CANTILEVER | HEX NUT | 3/4-10 STRUCTURAL HEX NUT | 8
 |  |  |  |  |  |  |  |  |  |  | 9860-07-MC | CANTILEVER | CAP SCREW | 1/4-20X5/8 INCH LONG HEX CAP SCREW | 8