Spreadsheet: 752476d1634781299-needing-help-with-matching-lookup-table-produced-from-mulitple-tables-using-power-query-ctuck1002-
Sheet: All Buildings Table

Building | NIIN | Nomenclature | U of I | Batch | QTY | Unit Price | Total Price | Location | Date
CLIXServiceable | 002023961 | PACKING,PREFORMED | EA | A | 10 | 0.01 | 0.1 | W1L1 | 2021-01-15 00:00:00
CLIXServiceable | 006878679 | SPACER,RING | EA | A | 46 | 11.07 | 509.22 | W1L1 | 2021-01-15 00:00:00
CLIXServiceable | 000000079 | Washer Flat | EA | B | 1 | 0.35 | 0.35 | W2N9 | 2021-03-05 00:00:00
CLIXServiceable | 000000145 | Filter Element Fluid | EA | B | 4 | 49.3 | 197.2 | W1F1 | 2020-12-17 00:00:00
CLIXServiceable | 000016768 | Base  Mat | EA | A | 2 | 641.75 | 1283.5 | JR2 | 2020-12-17 00:00:00
CLIXServiceable | 000031788 | Nut Plain Blind Rivet | EA | A | 68 | 3.19 | 216.92 | W2M8 | 2021-04-16 00:00:00
CLIXServiceable | 000034094 | Washer Lock | EA | A | 6 | 4.37 | 26.22 | W2M5 | 2021-02-05 00:00:00
CLIXServiceable | 000034094 | Washer Lock | EA | A | 6 | 4.37 | 26.22 | W2N5 | 2021-07-02 00:00:00
CLIXServiceable | 000034094 | Washer Lock | EA | A | 6 | 4.37 | 26.22 | W2N4 | 2021-07-02 00:00:00
CLIXServiceable | 000034094 | Washer Lock | EA | A | 6 | 4.37 | 26.22 | W2M5 | 2021-09-10 00:00:00
CLIXServiceable | 000034094 | Washer Lock | EA | A | 6 | 4.37 | 26.22 | HH3 | 2021-10-01 00:00:00
CLIXServiceable | 000034109 | [NAME] | EA | A | 3 | 16.8 | 50.4 | W1K1 | 2021-01-29 00:00:00
CLIXServiceable | 000039302 | Packing With Retainer | EA | A | 1 | 0.98 | 0.98 | W2K1 | 2021-07-23 00:00:00
CLIXServiceable | 000045033 | Washer, Lock | EA | A | 8 | 2.77 | 22.16 | W1K4 | 2020-12-24 00:00:00
CLIXServiceable | 000045033 | WASHER,LOCK | HD | G | 20 | 2.77 | 55.4 | W2I14 | 2020-12-31 00:00:00
CLIXServiceable | 000045033 | WASHER,LOCK | EA | A | 16 | 2.77 | 44.32 | W1K3 | 2021-01-08 00:00:00
CLIXServiceable | 000045033 | Washer Lock | HD | A | 4 | 2.77 | 11.08 | W1K1 | 2021-01-15 00:00:00
CLIXServiceable | 000045033 | Washer Lock | EA | A | 8 | 2.77 | 22.16 | W1K1 | 2021-01-15 00:00:00
CLIXServiceable | 000045033 | Washer Lock | EA | A | 12 | 2.77 | 33.24 | W2M5 | 2021-02-05 00:00:00
CLIXServiceable | 000045033 | Washer Lock | EA | A | 4 | 2.77 | 11.08 | W2M6 | 2021-03-05 00:00:00
CLIXServiceable | 000045033 | Washer Lock | EA | A | 1 | 2.77 | 2.77 | W2M6 | 2021-06-11 00:00:00
CLIXServiceable | 000045033 | Washer Lock | EA | A | 4 | 2.77 | 11.08 | W2N5 | 2021-06-18 00:00:00
CLIXServiceable | 000045033 | Washer Lock | EA | A | 4 | 2.77 | 11.08 | [NAME] | 2021-07-02 00:00:00
CLIXServiceable | 000045033 | Washer Lock | EA | A | 4 | 2.77 | 11.08 | W2M6 | 2021-07-09 00:00:00
CLIXServiceable | 000045033 | Washer Lock | EA | A | 4 | 2.77 | 11.08 | W2M6 | 2021-07-23 00:00:00
CLIXServiceable | 000045033 | Washer Lock | EA | A | 8 | 2.77 | 22.16 | W2K1 | 2021-07-23 00:00:00
CLIXServiceable | 000045033 | Washer Lock | EA | A | 4 | 2.77 | 11.08 | W2K1 | 2021-07-23 00:00:00
CLIXServiceable | 000045033 | Washer Lock | EA | A | 16 | 2.77 | 44.32 | W2M6 | 2021-08-06 00:00:00
CLIXServiceable | 000045033 | Washer Lock | EA | A | 8 | 2.77 | 22.16 | W2I12 | 2021-08-13 00:00:00
CLIXServiceable | 000045033 | Washer Lock | EA | A | 8 | 2.77 | 22.16 | W2M6 | 2021-09-03 00:00:00
CLIXServiceable | 000045033 | Washer Lock | EA | A | 12 | 2.77 | 33.24 | W2M6 | 2021-09-03 00:00:00
CLIXServiceable | 000045033 | Washer Lock | EA | A | 36 | 2.77 | 99.72 | W2M6 | 2021-09-10 00:00:00
CLIXServiceable | 000045033 | Washer Lock | EA | A | 4 | 2.77 | 11.08 | W1K3 | 2021-10-01 00:00:00
CLIXServiceable | 000045033 | Washer Lock | EA | A | 4 | 2.77 | 11.08 | W1K4 | 2021-10-01 00:00:00
CLIXServiceable | 000045118 | NUT,SELF-LOCKING,ASSEMBLED WASHER | EA | A | 4 | 4.4 | 17.6 | W1K3 | 2021-01-08 00:00:00
CLIXServiceable | 000056500 | Power Supply Subassembly | EA | A | 1 | 150 | 150 | JJ1 | 2021-06-11 00:00:00
CLIXServiceable | 000074791 | Filter Element Fluid | EA | A | 5 | 5.79 | 28.95 | W1H2 | 2021-05-28 00:00:00
CLIXServiceable | 000074791 | Filter Element Fluid | EA | B | 1 | 5.79 | 5.79 | Box 54 | 2021-09-03 00:00:00
CLIXServiceable | 000074791 | Filter Element Fluid | EA | A | 2 | 5.79 | 11.58 | Box 57 | 2021-10-01 00:00:00
CLIXServiceable | 000079453 | Connector Orifice Assembly | EA | A | 2 | 13.1 | 26.2 | BB2 | 2021-06-18 00:00:00
CLIXServiceable | 000085961 | O-RING | EA | A | 21 | 16.11 | 338.31 | W1L1 | 2021-01-15 00:00:00
CLIXServiceable | 000085961 | O-RING | EA | A | 21 | 16.11 | 338.31 | W1L1 | 2021-01-15 00:00:00
CLIXServiceable | 000094015 | Retainer Battery | EA | A | 1 | 6.13 | 6.13 | BR2 | 2021-07-23 00:00:00
CLIXServiceable | 000094015 | Retainer Battery | EA | A | 1 | 6.13 | 6.13 | W2K1 | 2021-07-23 00:00:00
CLIXServiceable | 000094015 | Retainer Battery | EA | A | 2 | 6.13 | 12.26 | HR2 | 2021-09-17 00:00:00
CLIXServiceable | 000103867 | Plug Pipe | EA | A | 4 | 0.25 | 1 | CC2 | 2021-09-24 00:00:00
CLIXServiceable | 000103875 | Plug Pipe | EA | A | 1 | 0.31 | 0.31 | W2K1 | 2021-08-13 00:00:00
CLIXServiceable | 000103982 | Light Dome | EA | B | 1 | 41.14 | 41.14 | CC4 | 2021-09-17 00:00:00
CLIXServiceable | 000115093 | Washer Lock | EA | A | 4 | 1.73 | 6.92 | W2N4 | 2021-06-18 00:00:00
CLIXBulk | 015004991 | WHEEL AND TIRE ASSY | EA | A | 3 | 2543 | 7629 | BTIRES | 2021-05-28 00:00:00
CLIXBulk | 014935859 | WHEEL AND RUNFLAT | EA | A | 2 | 2183 | 4366 | BTIRES | 2021-05-28 00:00:00
CLIXBulk | 015427405 | WHEEL,PNEUMATIC TIRE | EA | A | 4 | 986 | 3944 | BTIRES | 2021-05-28 00:00:00
CLIXBulk | 013337632 | TIRE,PNEUMATIC,VEHICULAR | EA | A | 1 | 562.68 | 562.68 | BTIRES | 2021-05-28 00:00:00
CLIXBulk | 011481635 | TIRE,PNEUMATIC,VEHICULAR | EA | A | 4 | 160.62 | 642.48 | BTIRES | 2021-05-28 00:00:00
CLIXBulk | 014407615 | PARTS KIT, TRACK SHOE CONNECTOR | EA | B | 1059 | 15.88 | 16816.92 | BTRACK | 2021-06-04 00:00:00
CLIXBulk | 014968858 | PAD, TRACK SHOE | EA | B | 135 | 14.52 | 1960.2 | BTRACK | 2021-06-04 00:00:00
CLIXBulk | 011303366 | PAD, TRACK, SHOE | EA | B | 121 | 11.52 | 1393.92 | BTRACK | 2021-06-04 00:00:00
CLIXBulk | 012341917 | TRACK SHOE,VEHICULAR | EA | A | 32 | 347 | 11104 | BT5 | 2021-07-09 00:00:00
CLIXBulk | 014429686 | TRACK SHOE,VEHICULAR | EA | A | 64 | 199 | 12736 | BT5 | 2021-07-09 00:00:00
CLIXBulk | 014964444 | TRACK SHOE ASSEMBLY | EA | B | 217 | 227 | 49259 | BT5 | 2021-07-09 00:00:00
CLIXBulk | 013666243 | FILTER, GAS-PARTICULATE | EA | A | 1 | 2816 | 2816 | BJ1 | 2021-07-23 00:00:00
CLIXBulk | 015804772 | FENDER, VEHICULAR | EA | B | 1 | 1899.19 | 1899.19 | BJ1 | 2021-07-23 00:00:00
CLIXBulk | 011573652 | TANK, FUEL ENGINE | EA | B | 1 | 1411.51 | 1411.51 | BJ1 | 2021-07-23 00:00:00
CLIXBulk | 015254023 | BUMPER, VEHICULAR | EA | B | 1 | 592.32 | 592.32 | BJ1 | 2021-07-23 00:00:00
CLIXBulk | 016768103 | DOOR, VEHICULAR | EA | A | 1 | 8101 | 8101 | BJ1 | 2021-07-30 00:00:00
CLIXBulk | 013527252 | DOOR, VEHICULAR | EA | A | 2 | 2089.55 | 4179.1 | BJ1 | 2021-07-30 00:00:00
CLIXBulk | 013306175 | DOOR, VEHICULAR | EA | A | 1 | 151.22 | 151.22 | BJ1 | 2021-07-30 00:00:00
CLIXBulk | 014732309 | HOOD, ENGINE COMPARTMENT | EA | A | 2 | 1508 | 3016 | BJ1 | 2021-07-30 00:00:00
CLIXBulk | 016264650 | WINDOW INSTALLATION KIT, VEHICULAR | KT | A | 1 | 4121.07 | 4121.07 | BJ1 | 2021-07-30 00:00:00
CLIXBulk | 013840910 | SIDE RACK, VEHICLE BODY | EA | A | 1 | 1017.14 | 1017.14 | BJ1 | 2021-07-30 00:00:00
CLIXBulk | 015291110 | PLATE, FLOOR, METAL | EA | A | 1 | 1063 | 1063 | BJ1 | 2021-07-30 00:00:00
CLIXBulk | 013946981 | LADDER, VEHICLE BOARDING | EA | A | 1 | 203.94 | 203.94 | BJ1 | 2021-07-30 00:00:00
CLIXBulk | 013816341 | MAST | EA | B | 3 | 4859.14 | 14577.42 | BJ1 | 2021-08-06 00:00:00
CLIXBulk | 015678727 | TURRET, COMBAT VEHICLE | EA | B | 2 | 15729.25 | 31458.5 | BJ1 | 2021-08-06 00:00:00
CLII | 001985876 | ENVELOPE,MAILING | BX | A | 7 | 23.63 | 165.41 | S2
CLII | 000523776 | GOGGLES,INDUSTRIAL | EA | A | 1 | 2.99 | 2.99 | S1
CLII | 015629455 | HOLDER,MULTIPLE MAGAZ | EA | A | 43 | 44.56 | 1916.08 | S3
CLII | 015247638 | EXTERNAL MEDICAL MODU | EA | B | 1 | 10.82 | 10.82 | S3E
BII | 016057303 | WRENCH,BOX AND OPEN END,COMBINAT | EA | A | 1 | 19.28 | 19.28 | L1D
BII | 016568889 | SOCKET,SOCKET WRENCH | EA | A | 1 | 24.02 | 24.02 | L2C
BII | 001746865 | PANEL MARKER | EA | A | 53 | 30.12 | 1596.36 | W3D2
BII | 001489546 | REFLECTOR SET,HIGHWAY WARNING,TRI | EA | G | 10 | 23.09 | 230.9 | W3G11
BatchF | 015939062 | STEERING GEAR | EA | F | 1 | 2150 | 2150 | SKID 1
BatchF | 012312973 | CYLINDER ASSEMBLY, ACTUATING LINE | EA | F | 1 | 1903 | 1903 | SKID 1
BatchF | 012618124 | GENERATOR, ENGINE ACCESSORY | EA | F | 1 | 26443 | 26443 | SKID 2
BatchF | 013390029 | FUEL SYSTEM ASSEMBLY | EA | F | 1 | 42778 | 42778 | SKID 2
_31Servicable | 014957907 | [NAME] | EA | A | 1 | 10.79 | 10.79 | Lane 3 Box A | 2021-03-10 00:00:00
_31Servicable | [PHONE] | O Ring | EA | A | 1 | 0.32 | 0.32 | Lane 3 Box A | 2021-03-10 00:00:00
_31Servicable | 014957897 | [NAME] | EA | A | 1 | 65.57 | 65.57 | Lane 3 Box A | 2021-03-10 00:00:00
_31Servicable | 001675175 | O Ring | EA | A | 1 | 0.2 | 0.2 | Lane 3 Box A | 2021-03-10 00:00:00
_31Servicable | 012342618 | Gasket | EA | A | 1 | 17.46 | 17.46 | Lane 3 Box A | 2021-03-10 00:00:00
_31Servicable | 013984589 | [NAME] | EA | A | 3 | 8.58 | 25.74 | Lane 3 Box A | 2021-03-10 00:00:00
_31Servicable | 012050041 | [NAME] | EA | A | 1 | 0.25 | 0.25 | Lane 3 Box A | 2021-03-10 00:00:00
_31Servicable | 015074023 | O Ring | EA | A | 1 | 3.75 | 3.75 | Lane 3 Box A | 2021-03-10 00:00:00
_31Servicable | 012730500 | Light Indicator | EA | A | 13 | 16.99 | 220.87 | Lane 3 Box A | 2021-03-10 00:00:00
_31Servicable | 011688707 | Gasket | EA | A | 4 | 4.2 | 16.8 | Lane 3 Box A | 2021-03-10 00:00:00
Unserviceable | 012225658 | SPEAKER PHONE | EA | F | 1 | 0 | 0 | LANE 2 | 2021-03-09 00:00:00