Spreadsheet: 40290d1238595971-vlookup-problem-copy-of-book3
Sheet: Sheet1

Product# | Description1 | Branch_Cost | Manufacture_Vendor# | Manufac_Vendor_Name | Each_Price | Lot1_Price | Lot1_Qty | Lot2_Price | [NAME] | LotA_Price | LotA_Qty | LotB_Price | LotB_Qty | [NAME] |  | Catalog_Page# | Product_Type | Hazardous_Flag | Discontinued_Ind | Avg_Cost_Whse1 | Avg_Cost_Whse2 | Br_Cost_Chg_Date | Vendor_Product_Description | Dir_Cost_Eff_Date | Dir_Cost1 | Dir_Qty1 | Dir_Cost2 | Dir_Qty2 | Dir_Cost3 | Dir_Qty3 | Corp_User_Description | Corp_Category_Code | Corp_Cat_Description | MSDS_Flag | Corp_Memo | Regular_Price | List_Price | LIST_LOT1 | LIST_LOT2 | Tax_Flag | Buy_From_Vendor# | Buy_From_Vendor_Name
C99-100 | MISC PRODUCT | 0 | 1 | JOHNSTONE-PORTLAND DC | 0 |  |  |  |  |  |  |  |  | 999 | MISC GOODS |  | 999 |  | N | 47 | 5 |  |  |  |  |  |  |  |  |  |  | 999-99 |  |  |  |  |  |  |  | N | 1 | JOHNSTONE-PORTLAND DC
C99-103 | TO CANCEL INVOICE | 0 | 1 | JOHNSTONE-PORTLAND DC | 0 |  |  |  |  |  |  |  |  | 999 | MISC GOODS |  | 999 |  | N | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 999-99 |  |  |  |  |  |  |  | N | 1 | JOHNSTONE-PORTLAND DC
C99-107 | TRACK PREPAID ORDER | 0 | 1 | JOHNSTONE-PORTLAND DC | 0 |  |  |  |  |  |  |  |  | 999 | MISC GOODS |  | 999 |  | N | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 999-99 |  |  |  |  |  |  |  | N | 1 | JOHNSTONE-PORTLAND DC
C99-300 | WARRANTY CHARGE | 0 | 1 | JOHNSTONE-PORTLAND DC | 0 |  |  |  |  |  |  |  |  | 999 | MISC GOODS |  | 999 |  | N |  |  |  | WARRANTY CHARGE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N | 1 | JOHNSTONE-PORTLAND DC
G31-702 | LPCG50 1/2" NM CORD GRIP | 0.79 | 113 | ARLINGTON INDUSTRIES,INC. | 1.45 | 1.32 | 25 |  |  |  |  |  |  | 413 | ELECTRICAL SUPPLIES | 1226 | 3 |  | N | 0.49 | 0.49 | 2008-08-07 00:00:00 | LPCG50 | 2008-08-07 00:00:00 | 0.736 | 100 |  |  |  |  | NON-METAL 1/2" CORD GRIP | 413-24 | CABLE/CONDUIT FITTINGS | E |  | 1.45 | 3.22 | 2.93 |  | N | 1 | JOHNSTONE-PORTLAND DC
G31-703 | LPCG757 3/4" NM CORD GRI | 1.11 | 113 | ARLINGTON INDUSTRIES,INC. | 2.02 | 1.85 | 10 |  |  |  |  |  |  | 413 | ELECTRICAL SUPPLIES | 1226 | 3 |  | N | 1.11 | 1.11 | 2008-08-07 00:00:00 | LPCG757 | 2008-08-07 00:00:00 | 1.027 | 50 |  |  |  |  | NON-METAL 3/4" CORD GRIP | 413-24 | CABLE/CONDUIT FITTINGS | E | CENT M4A,F | 2.02 | 4.49 | 4.11 |  | N | 1 | JOHNSTONE-PORTLAND DC
G21-863 | EN95 D ALK BATTERY | 0.63 | 114 | EVEREADY/ENERGIZER | 0.99 |  |  |  |  |  |  |  |  | 217 | BATTERIES | 1248 | 3 |  | N | 0.57 | 0.573 | 2009-03-01 00:00:00 | EN95 | 2008-05-01 00:00:00 | 0.597 | 72 |  |  |  |  | D ALKALINE BATTERY | 217-02 | ALKALINE | E |  | 1.24 | 2.76 | 2.31 | 2.16 | Y | 1 | JOHNSTONE-PORTLAND DC
G21-864 | EN93 C ALK BATTERY | 0.52 | 114 | EVEREADY/ENERGIZER | 0.79 |  |  |  |  |  |  |  |  | 217 | BATTERIES | 1248 | 3 |  | N | 0.01 | 0.01 | 2009-03-01 00:00:00 | EN93 | 2007-02-01 00:00:00 | 0.494 | 72 |  |  |  |  | C ALKALINE BATTERY | 217-02 | ALKALINE | E |  | 1.03 | 2.29 | 1.91 | 1.78 | Y | 1 | JOHNSTONE-PORTLAND DC
G21-865 | EN91 [NAME] | 0.27 | 114 | EVEREADY/ENERGIZER | 0.39 |  |  |  |  |  |  |  |  | 217 | BATTERIES | 1248 | 3 |  | N | 0.28 | 0.28 | 2009-03-01 00:00:00 | EN91 | 2008-05-01 00:00:00 | 0.258 | 144 |  |  |  |  | AA ALKALINE BATTERY | 217-02 | ALKALINE | E |  | 0.54 | 1.2 |  |  | Y | 1 | JOHNSTONE-PORTLAND DC
G22-302 | EN92 AAA ALK BATTERY | 0.28 | 114 | EVEREADY/ENERGIZER | 0.45 |  |  |  |  |  |  |  |  | 217 | BATTERIES | 1248 | 3 |  | N | 0.3 | 0.01 | 2009-03-01 00:00:00 | EN92 | 2008-05-01 00:00:00 | 0.268 | 144 |  |  |  |  | AAA ALKALINE BATTERY | 217-02 | ALKALINE | E |  | 0.56 | 1.24 | 1.04 | 0.96 | Y | 1 | JOHNSTONE-PORTLAND DC
G22-719 | EN22 9V ALK BATTERY | 0.98 | 114 | EVEREADY/ENERGIZER | 1.49 |  |  |  |  |  |  |  |  | 217 | BATTERIES | 1248 | 3 |  | N | 0.93 | 0.01 | 2009-03-01 00:00:00 | EN22 | 2007-02-01 00:00:00 | 0.937 | 72 |  |  |  |  | 9V ALKALINE BATTERY | 217-02 | ALKALINE | E |  | 1.95 | 4.33 |  |  | Y | 1 | JOHNSTONE-PORTLAND DC
G31-228 | KPR102BP-2 2PK 2DKIP BUL | 1.63 | 114 | EVEREADY/ENERGIZER | 3.27 | 2.97 | 10 | 2.72 | 20 |  |  |  |  | 209 | HAND HELD LIGHTING | 1571 | 3 |  | N | 1.63 | 1.63 | 2009-01-20 00:00:00 | KPR102BP-2 | 2008-05-01 00:00:00 | 1.483 | 10 |  |  |  |  | 2D KRIP BULB 2PK | 209-03 | ACCESSORIES | E | Cent M 4 A,F & V4P | 3.27 | 7.27 | 6.6 | 6.04 | Y | 1 | JOHNSTONE-PORTLAND DC
G31-373 | 357BP W/E 1.55V LB | 0.49 | 114 | EVEREADY/ENERGIZER | 1.08 | 0.92 | 6 | 0.84 | 12 |  |  |  |  | 217 | BATTERIES | 1248 | 3 |  | N | 0.01 | 0.49 | 2009-01-20 00:00:00 | 357BP | 2008-05-01 00:00:00 | 0.443 | 6 |  |  |  |  | W/E 1.55V LG | 217-04 | GENERAL PURPOSE | E |  | 1.08 | 2.4 | 2.04 | 1.87 | Y | 1 | JOHNSTONE-PORTLAND DC
G31-532 | 393 W/E 1.55V SM | 0.6 | 114 | EVEREADY/ENERGIZER | 1.34 | 1.14 | 5 | 1.04 | 10 |  |  |  |  | 217 | BATTERIES | 1248 | 3 |  | N | 0.195 | 0.38 | 2009-01-20 00:00:00 | 393 | 2008-05-01 00:00:00 | 0.546 | 100 |  |  |  |  | W/E 1.55V SM | 217-04 | GENERAL PURPOSE | E | ENERGIZER | 1.34 | 2.98 | 2.53 | 2.31 | Y | 1 | JOHNSTONE-PORTLAND DC
G31-593 | R215WB-S SUB G33-168 D99 | 3.27 | 114 | EVEREADY/ENERGIZER | 5.8 | 5.14 | 6 |  |  |  |  |  |  | 209 | HAND HELD LIGHTING | D99 | 3 |  | Y | 4.72 | 3.63 | 2007-05-23 00:00:00 | R215WB-S | 2002-08-02 00:00:00 | 3.265 | 6 |  |  |  |  | 2AA HD LIGHT W/BATTERIES | 209-01 | FLASH LIGHTS | E | CENTRAL MDC | 5.8 | 12.89 | 11.42 |  | Y | 1 | JOHNSTONE-PORTLAND DC
G31-677 | E251Y 2D LIGHT W/MAGNET | 2.03 | 114 | EVEREADY/ENERGIZER | 3.13 |  |  |  |  |  |  |  |  | 209 | HAND HELD LIGHTING | 1571 | 3 |  | N | 2.03 | 2.03 | 2009-01-20 00:00:00 | E251Y | 2002-08-02 00:00:00 | 1.844 | 12 |  |  |  |  | 2D LIGHT W/MAGNET | 209-01 | FLASH LIGHTS | E |  | 3.13 | 6.96 | 6.44 |  | Y | 1 | JOHNSTONE-PORTLAND DC
G31-678 | IN251WB-S SUBG33-169 D99 | 3.88 | 114 | EVEREADY/ENERGIZER | 6.9 | 6.11 | 6 |  |  |  |  |  |  | 209 | HAND HELD LIGHTING | D99 | 3 |  | Y | 3.39 | 3.943 | 2007-05-23 00:00:00 | IN251WB-S | 2002-08-02 00:00:00 | 3.883 | 6 |  |  |  |  | LATERN | 209-01 | FLASH LIGHTS | E |  | 6.9 | 15.33 | 13.58 |  | Y | 1 | JOHNSTONE-PORTLAND DC
G32-048 | TUF4D1H SUB G80-344 D99 | 11.11 | 114 | EVEREADY/ENERGIZER | 19.75 | 17.5 | 4 |  |  |  |  |  |  | 209 | HAND HELD LIGHTING | D99 | 3 |  | Y | 12.274 | 12.35 | 2007-05-23 00:00:00 | TUF4D1H | 2002-08-02 00:00:00 | 11.114 | 4 |  |  |  |  | LANTERN | 209-02 | LANTERNS | E |  | 19.75 | 43.89 | 38.89 |  | Y | 1 | JOHNSTONE-PORTLAND DC