Spreadsheet: 79100d1279314418-formula-processing-example_hlookup
Sheet: Sheet2

ITEM CODE | [NAME] | QTY Onhand | Free Stock | QTY B/O | QTY P/O | QTY Net | QTY Sold | QTY Sold COMP | order | Order Quantity | EOQ | BackOrder Until | Last PO Date | Last PO Number | Last PO QTY | Vendor | Standard Cost | Last Cost | Cost | Order Value | Delivery Method | Due Date
5CO-01100 | [NAME] (21 1/8"-21 1/2") | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1 |  | 2008-04-11 00:00:00 | 241249 | 1 | 100039 | 48.06 | 45.79 | 45.79 |  |  | 2010-07-14 00:00:00
5CO-01120 | [NAME] (21 5/8"-22 1/4") | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1 |  | 2008-03-28 00:00:00 | 240838 | 1 | 100039 | 48.06 | 40.99 | 40.99 |  |  | 2010-07-14 00:00:00
5CO-01130 | [NAME] (22 3/8"-23") | 2 | 2 | 0 | 0 | 2 | 0 | 1 | -1 |  | 1 |  | 2010-04-09 00:00:00 | 296544 | 2 | 100039 | 48.06 | 48.06 | 48.06 |  |  | 2010-07-14 00:00:00
 | [NAME] (23 1/8"-23 78") | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1 |  | 2010-02-05 00:00:00 | 292900 | 1 | 100039 | 48.06 | 48.06 | 48.06 |  |  | 2010-07-14 00:00:00
5CO-03821 | R-CO Rectangular Chimney Surround | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 |  |  |  | 2010-04-21 00:00:00 | 297287 | 1 | 100039 | 178.9 | 178.9 | 178.9 |  |  | 2010-07-14 00:00:00
5CO-03825 | R-CO Rect. [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 |  | 1 |  | 2010-03-24 00:00:00 | 296120 | 1 | 100039 | 101.87 | 101.87 | 101.87 |  |  | 2010-07-14 00:00:00
5CO-03826 | R-CO Rect. Chimney Surround Extension | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 |  | 1 |  | 2009-10-23 00:00:00 | 278594 | 1 | 100039 | 97.43 | 97.43 | 97.43 |  |  | 2010-07-14 00:00:00
5CO-03831 | R-CO- Square Chimney Surround | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 |  | 1 |  | 2010-04-09 00:00:00 | 296085 | 1 | 100039 | 208.12 | 208.12 | 208.12 |  |  | 2010-07-14 00:00:00
5CO-03835 | R-CO Square Chimney Surround Trim Kit | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 |  | 1 |  | 2010-04-09 00:00:00 | 296085 | 1 | 100039 | 130.56 | 130.56 | 130.56 |  |  | 2010-07-14 00:00:00
5CO-03836 | R-CO-Square Chimney Surround Extension | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1 |  | 2008-06-23 00:00:00 | 242045 | 1 | 100039 | 119.25 | 114.1 | 114.1 |  |  | 2010-07-14 00:00:00
5CO-08000 | Ladder Levelers | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 4 |  | 1 |  | 2010-05-11 00:00:00 | 298481 | 1 | 100039 | 79.72 | 79.72 | 79.72 |  |  | 2010-07-14 00:00:00
5CO-08001 | [NAME] for Ladder Levelers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1 |  |  |  | 0 | 100039 | 17.96 | 10.5 | 10.5 |  |  | 2010-07-14 00:00:00
5CO-09100 | 8" x 8" Lock-Top Chimney Damper & Cap | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 |  | 1 |  | 2009-12-11 00:00:00 | 284839 | 1 | 100039 | 120.73 | 120.73 | 120.73 |  |  | 2010-07-14 00:00:00
5CO-09102 | 8" x 8" Sweeps Ring | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1 |  | 2009-12-11 00:00:00 | 284839 | 1 | 100039 | 27.75 | 27.75 | 27.75 |  |  | 2010-07-14 00:00:00
5CO-09110 | 8" x 13" Lock-Top Chimney Damper & Cap | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 11 |  | 1 |  | 2010-04-29 00:00:00 | 297592 | 2 | 100039 | 123.75 | 123.75 | 123.75 |  |  | 2010-07-14 00:00:00
5CO-09112 | 8" x 13" [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 5 |  | 1 |  | 2010-04-29 00:00:00 | 297592 | 2 | 100039 | 27.75 | 27.75 | 27.75 |  |  | 2010-07-14 00:00:00
5CO-09115 | 8" x 17" Lock-Top Chimney Damper & Cap | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1 |  | 2009-12-12 00:00:00 | 285022 | 1 | 100039 | 155.65 | 155.65 | 155.65 |  |  | 2010-07-14 00:00:00
5CO-09117 | 8" x 17" [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1 |  | 2009-12-12 00:00:00 | 285022 | 1 | 100039 | 27.75 | 27.75 | 27.75 |  |  | 2010-07-14 00:00:00
5CO-09120 | 13" x 13" Lock-Top Chimney Damper & Cap | 0 | 0 | 0 | 0 | 0 | 0 | 23 | 23 |  | 1 |  | 2010-03-02 00:00:00 | 294814 | 1 | 100039 | 126.5 | 126.5 | 126.5 |  |  | 2010-07-14 00:00:00
5CO-09122 | 13" x 13" [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 |  | 1 |  | 2010-03-02 00:00:00 | 294814 | 1 | 100039 | 29.8 | 29.8 | 29.8 |  |  | 2010-07-14 00:00:00
5CO-09125 | 13" x 17" Lock-Top Chimney Damper & Cap | 1 | 1 | 0 | 0 | 1 | 0 | 5 | 4 |  | 1 |  | 2010-02-09 00:00:00 | 293324 | 1 | 100039 | 162.75 | 162.75 | 162.75 |  |  | 2010-07-14 00:00:00
5CO-09127 | 13" x 17" [NAME] | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 0 |  | 1 |  | 2010-02-09 00:00:00 | 293204 | 1 | 100039 | 29.8 | 29.8 | 29.8 |  |  | 2010-07-14 00:00:00
5CO-09130 | 17" x 17" Lock-Top Chimney Damper & Cap | 0 | 0 | 0 | 1 | 1 | 0 | 0 | -1 |  | 1 |  | 2010-06-10 00:00:00 | 299702 | 1 | 100039 | 190.85 | 190.85 | 190.85 |  |  | 2010-07-14 00:00:00
5CO-09132 | 17" x 17" [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 2010-03-11 00:00:00 | 295478 | 1 | 100039 | 38.8 | 38.8 | 38.8 |  |  | 2010-07-14 00:00:00
5CO-09150 | 50' Cable For Chimney Cap/Damper | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 |  | 1 |  | 2009-10-23 00:00:00 | 278732 | 1 | 100039 | 14.96 | 14.96 | 14.96 |  |  | 2010-07-14 00:00:00
5CO-09300 | Lock-Top/Pop-Top 4' SS Cable Shield | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1 |  | 2006-11-08 00:00:00 | 205617 | 1 | 100039 | 12.65 | 10.45 | 10.45 |  |  | 2010-07-14 00:00:00
5CO-09410 | 6" RS Adaptor To Lock-Top Adaptor | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1 |  | 2009-12-11 00:00:00 | 284839 | 1 | 100039 | 40.13 | 40.13 | 40.13 |  |  | 2010-07-14 00:00:00
5CO-09412 | 7" RS Adaptor To Lock-Top Adaptor | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1 |  | 2008-09-02 00:00:00 | 249162 | 1 | 100039 | 42.92 | 47 | 47 |  |  | 2010-07-14 00:00:00
5CO-09413 | 7.5" RS Adaptor To Lock-Top Adaptor | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  |  | 0 | 100039 | 43.44 | 0 | 0 |  |  | 2010-07-14 00:00:00
5CO-09414 | 8" RS Adaptor To Lock-Top Adaptor | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 |  | 1 |  | 2010-03-10 00:00:00 | 295384 | 1 | 100039 | 45.02 | 45.02 | 45.02 |  |  | 2010-07-14 00:00:00
5CO-09416 | 9" RS Adaptor To Lock-Top Adaptor | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 |  | 1 |  | 2009-11-02 00:00:00 | 279407 | 1 | 100039 | 47.04 | 47.04 | 47.04 |  |  | 2010-07-14 00:00:00
5CO-09418 | 10" RS Adaptor To Lock-Top Adaptor | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1 |  | 2010-02-03 00:00:00 | 292095 | 1 | 100039 | 48.93 | 48.93 | 48.93 |  |  | 2010-07-14 00:00:00
5CO-09420 | 11" RS Adaptor To Lock-Top Adaptor | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1 |  |  |  | 0 | 100039 | 49.98 | 0 | 0 |  |  | 2010-07-14 00:00:00
5CO-09422 | 12" RS Adaptor To Lock-Top Adaptor | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 |  | 1 |  | 2010-03-02 00:00:00 | 294814 | 1 | 100039 | 51.2 | 51.2 | 51.2 |  |  | 2010-07-14 00:00:00
5CO-09501 | 8"x8" Lock-Top II Chimney Cap/Damper | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 0 |  | 1 |  | 2009-10-12 00:00:00 | 277067 | 1 | 100039 | 167.64 | 167.64 | 167.64 |  |  | 2010-07-14 00:00:00
5CO-09503 | 8"x13" Lock-Top II Chimney Cap/Damper | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 9 |  | 1 |  | 2010-01-18 00:00:00 | 289730 | 1 | 100039 | 177.14 | 177.14 | 177.14 |  |  | 2010-07-14 00:00:00
5CO-09505 | 8"x17" Lock-Top II Chimney Cap/Damper | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 |  | 1 |  | 2009-12-04 00:00:00 | 283686 | 1 | 100039 | 225.28 | 225.28 | 225.28 |  |  | 2010-07-14 00:00:00
5CO-09507 | 13"x13" Lock-Top II Chimney Cap/Damper | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 5 |  | 1 |  | 2010-05-11 00:00:00 | 298503 | 2 | 100039 | 193.5 | 193.5 | 193.5 |  |  | 2010-07-14 00:00:00
5CO-09509 | 13"x17" Lock-Top II Chimney Cap/Damper | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 |  | 1 |  | 2010-05-04 00:00:00 | 297798 | 1 | 100039 | 210.58 | 210.58 | 210.58 |  |  | 2010-07-14 00:00:00
5CO-09510 | 17"x17" Lock-Top II Chimney Cap/Damper | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1 |  | 2009-11-25 00:00:00 | 281970 | 2 | 100039 | 273.11 | 273.11 | 273.11 |  |  | 2010-07-14 00:00:00
5CO-09512 | 8"x8" Lock-Top II Chimney Cap/Damper | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1 |  | 2010-03-10 00:00:00 | 295384 | 1 | 100039 | 167.55 | 167.55 | 167.55 |  |  | 2010-07-14 00:00:00
5CO-09515 | 8"x13" Lock-Top II Chimney Cap/Damper | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 |  | 1 |  | 2009-11-24 00:00:00 | 281648 | 1 | 100039 | 181.82 | 181.82 | 181.82 |  |  | 2010-07-14 00:00:00
5CO-09518 | 8"x17" Lock-Top II Chimney Cap/Damper | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 |  | 1 |  | 2010-02-03 00:00:00 | 279899 | 1 | 100039 | 229.94 | 229.94 | 229.94 |  |  | 2010-07-14 00:00:00
5CO-09520 | 13"x13" Lock-Top II Chimney Cap/Damper | 0 | 0 | 0 | 0 | 0 | 2 | 6 | 6 |  | 1 |  | 2010-06-28 00:00:00 | 300310 | 1 | 100039 | 198.1 | 198.1 | 198.1 |  |  | 2010-07-14 00:00:00
5CO-09522 | 13"x17" Lock-Top II Chimney Cap/Damper | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 |  | 1 |  | 2009-11-13 00:00:00 | 278378 | 1 | 100039 | 222.78 | 222.78 | 222.78 |  |  | 2010-07-14 00:00:00