Spreadsheet: 713952d1611030542-iferror-and-vlookup-lookup-help
Sheet: Sheet2

Item Number |  | 3rd Item Number | Description | [NAME] | Srch: Search Text | Search Text Compressed | Sls Cd1 | Sls Cd2 | Sls Cd3 | Sls Cd4 | Sls Cd5 | Cat Cd6 | Cat Cd7 | Cat Cd8 | Cat Cd9 | Cat Cd10 | Comm Class
E0001021 | E0001021 | 15-215 | WINDSHIELD WASHER -35 3.78L | 3.78L x 4 | 4L WASHER35 | 4LWASHER35 | COM |  | OTH |  |  |  |  |  |  | CHE000 | CHE
[NAME] | [NAME] | 26-248 | ANTIFREEZE UNIVERSAL 205L |  | ANTIFREEZE UNIVERSAL 205L | ANTIFREEZEUNIVERSAL205L | COM |  | OTH |  |  |  |  | EHC7 |  | 240200 | CHE
E0002959 | E0002959 | 16-734 | COOLANT HD XTENDED LIFE 3.78L |  | COOLANT HD XTENDED LIFE 3.78L | COOLANTHDXTENDEDLIFE378L | COM |  | OTH |  |  | ANT |  | EHC9 |  | 240300 | CHE
E0001495 | E0001495 | 26-289 | ANTIFREEZE PURPLE CONC HD 205L |  | DR AFHD PUR | DRAFHDPUR | COM |  | OTH |  |  |  |  | EHC7 |  | 000000 | CHE
7761 | 7761 | 7761 | PZ PREMIUM WHEELBEAR GRE707L | CA 10 X.397KG | PZ PREMIUM WHEELBEAR GRE707L | PZPREMIUMWHEELBEARGRE707L | LPZ | LGR | LUB | SHL | LBW |  |  |  | K.397 |  | LMC
ECO12SKU | ECO12SKU | ECO12SKU | 12 SKU RACK REQUIRES 6100585CA | ECO  RACK | ECOBOX 12 SKU RACK | ECOBOX12SKURACK | LSH |  | LUB | SHL | LBW |  |  |  | EA
ECORACK | ECORACK | ECORACK | 3x3 RACK  REQUIRES 6100585CA | ECO  RACK | 3x3 RACK  REQUIRES 6100585CA | 3X3RACKREQUIRES6100585CA | LSH |  | LUB | SHL | LBW |  |  |  | EA
6100585CA | 6100585CA | 6100585CA | ECO PITCHER W/SPOUT LID LABEL | ECOJUG 6X1 | ECO PITCHER W/SPOUT LID LABEL | ECOPITCHERWSPOUTLIDLABEL | LSH |  | LUB | SHL | LBW |  |  |  | EA
E0003001 | E0003001 | 16-104X52 | TURBO PWR GLOBAL XL | 16-104X52 NS  CASE  4 X 3.78LT | TURBO PWR GLOBAL XL | TURBOPWRGLOBALXL | COM |  | OTH |  |  |  |  | EHC9 |  |  | CHE
E0003004 | E0003004 | 16-244X52 | UNIVERSAL RAD | 16-244X52 NS  CASE  4 X 3.78LT | UNIVERSAL RAD | UNIVERSALRAD | COM |  | OTH |  |  |  |  | EHC9 |  |  | CHE
C0005302 | C0005302 | 203596 | DOT 3 BRAKE FLUID 12X 350ML | PART NUMBER 203596 | DOT 3 BRAKE FLUID | DOT3BRAKEFLUID | LNS |  | LUB |  | LUB | CRK | MSC |  |  | 240300 | LUB
BW90003 | BW90003 | BW90003 | DIESEL EXHAUST FLUID | DRUM  208L | DIESEL EXHAUST FLUID | DIESELEXHAUSTFLUID | LNS | LAT | LUB |  | LBW |  |  |  | L208 |  | DEF
BW90004 | BW90004 | BW90004 | DIESEL EXHAUST FLUID | CASE  2 X 9.46L | DIESEL EXHAUST FLUID | DIESELEXHAUSTFLUID | LNS | LAT | LUB |  |  |  |  | EHC13 | L9.5 |  | DEF
BW90005 | BW90005 | BW90005 | DIESEL EXHAUST FLUID | BULK | DIESEL EXHAUST FLUID | DIESELEXHAUSTFLUID | LNS | LAT | LUB |  |  |  |  |  | L1 |  | DEF
BW20001 | BW20001 | BW20001 | BW CHAIN OIL | CASE  4 X 4L | BW CHAIN OIL | BWCHAINOIL | LNS | LRC | LUB |  |  |  |  | EHC2 | [NAME] |  | LPL
RID1540-5 | RID1540-5 | RID1540-5 | RIDGELINE 15W-40 CK-4 | PAIL  18.9L | RIDGELINE 15W-40 CK-4 | RIDGELINE15W40CK4 | LNS | LHD | LUB |  | LBW |  |  | EHC3 | L18.9 |  | LPL
RID540-5 | RID540-5 | RID540-5 | RIDGELINE SYNTHETIC 5W-40 CK-4 | PAIL  18.9L | RIDGELINE SYNTHETIC 5W-40 CK-4 | RIDGELINESYNTHETIC5W40CK4 | LNS | LHD | LUB |  | LBW |  |  | EHC3 | L18.9 |  | LPL
RIDAW32-5 | RIDAW32-5 | RIDAW32-5 | RIDGELINE AW 32 HYDRAULIC OIL | PAIL  18.9L | RIDGELINE AW 32 HYDRAULIC OIL | RIDGELINEAW32HYDRAULICOIL | LNS | LHY | LUB |  | LBW |  |  | EHC3 | L18.9 |  | LPL
RID1540-3 | RID1540-3 | RID1540-3 | RIDGELINE 15W-40 CK-4 | CA 3 X 3.78L | RIDGELINE 15W-40 CK-4 | RIDGELINE15W40CK4 | LNS | LRC | LUB |  | LBW |  |  | EHC3 | L3.78 |  | LPL
RID1540-330 | RID1540-330 | RID1540-330 | RIDGELINE 15W-40 CK-4 | Tote  1249 L | RIDGELINE 15W-40 CK-4 | RIDGELINE15W40CK4 | LNS | LHY | LUB |  | LBW |  |  | EHC1 | L208 |  | LPL
550054464 | 550054464 | 550054464 | ROTELLA T1 40 STRAIGHT GRADE | DR  208.2L | ROTELLA T1 40 STRAIGHT GRADE | ROTELLAT140STRAIGHTGRADE | LSH | LHD | LUB | SHL | LBW |  |  | EHC1 | [NAME] |  | LVT
550054526 | 550054526 | 550054526 | ROTELLA T6 0W-40 CJ4 | PAIL  18.9L | ROTELLA T6 0W-40 CJ4 | ROTELLAT60W40CJ4 | LSH | LHD | LUB | SHL | LBW |  |  | EHC3 | L18.9 |  | LPT
550054467 | 550054467 | 550054467 | ROTELLA T1 40 STRAIGHT GRADE | CA 3 X 5L | ROTELLA T1 40 STRAIGHT GRADE | ROTELLAT140STRAIGHTGRADE | LSH | LHD | LUB | SHL | LBW |  |  | EHC3 | L5 |  | LVT
550054465 | 550054465 | 550054465 | ROTELLA T1 40 STRAIGHT GRADE | PAIL  18.9L | ROTELLA T1 40 STRAIGHT GRADE | ROTELLAT140STRAIGHTGRADE | LSH | LHD | LUB | SHL | LBW |  |  | EHC3 | L18.9 |  | LVT
550054463 | 550054463 | 550054463 | ROTELLA T1 10W STRAIGHT GRADE | PAIL  18.9L | ROTELLA T1 10W STRAIGHT GRADE | ROTELLAT110WSTRAIGHTGRADE | LSH | LHD | LUB | SHL | LBW |  |  | EHC3 | L18.9 |  | LVT
RID8090-3 | RID8090-3 | RID8090-3 | RIDGELINE 80W-90 | CA 3 X 3.78L | RIDGELINE 80W-90 | RIDGELINE80W90 | LNS | LGT | LUB |  | LBW |  |  | EHC3 | L18.9 |  | LPL
RID8090-5 | RID8090-5 | RID8090-5 | RIDGELINE 80W-90 | PAIL  18.9L | RIDGELINE 80W-90 | RIDGELINE80W90 | LNS | LGT | LUB |  | LBW |  |  | EHC3 | L18.9 |  | LPL
550054547 | 550054547 | `550054547 | ARGINA S2 40 | DR  208.2L | ARGINA S2 40 | ARGINAS240 | LSH | LIN | LUB | SHL | LBW |  |  | EHC1 | [NAME] |  | LNI