Spreadsheet: 802052d1666618000-vlookup-seek-two-values-return-a-third-zone-open-order-report-with-priorities-test
Sheet: Central

BO ETA | PO | Priority | Month | Whse | Order# | Delivery # | Line# | Subinventory | Delivery Status | Item Number | Description | Serial Number | Qty | Aval | Ship To Party | Ship Address 1 | Ship City | State | Merch | Salesrep | Delivery Coemments Employee | Line Selling Prioce | Ordered Date
 |  |  |  | C01 | 11013679 |  | 1 |  | B = BACKORDERED | 3826C002 | IMAGERUNNER ADVANCE DX C5850I |  | 1 |  | CSL PLASMA INC | 4610 W DIVERSEY AVE | CHICAGO | IL | 10 | SHEEHAN III, THOMAS F. |  | 4988.55 | 2021-10-12 17:29:23
 |  |  |  | C01 | 11013679 |  | 2 |  | B = BACKORDERED | 4032C001 | INNER TRAY (1ST COPY TRAY KIT-A1) |  | 1 |  | CSL PLASMA INC | 4610 W DIVERSEY AVE | CHICAGO | IL | 20 | SHEEHAN III, THOMAS F. |  | 16.83 | 2021-10-12 17:29:23
 |  |  |  | C06 | 11013679 |  | 3 |  | B = BACKORDERED | 5358C001 | CABINET TYPE-V |  | 1 |  | CSL PLASMA INC | 4610 W DIVERSEY AVE | CHICAGO | IL | 20 | SHEEHAN III, THOMAS F. |  | 111.86 | 2021-10-12 17:29:23
 |  |  |  | C01 | 11013679 | 49769867 | 5 |  | S = RELEASED | 2368V120 | MID VOLUME CONNECTIVITY 30+PPM UP TO 79PPM |  | 1 |  | CSL PLASMA INC | 4610 W DIVERSEY AVE | CHICAGO | IL | 20 | SHEEHAN III, THOMAS F. | SLATER, [NAME] | 40.73 | 2021-10-12 17:29:23
 |  |  |  | C06 | 11013679 |  | 8 |  | B = BACKORDERED | 3763C003 | GPR-61 TONER BK (71K IMPRESSIONS @ 5% COVERAGE) |  | 1 |  | CSL PLASMA INC | 4610 W DIVERSEY AVE | CHICAGO | IL | 30 | SHEEHAN III, THOMAS F. |  | 0 | 2021-10-12 17:29:23
 |  |  |  | C01 | 11013679 |  | 9 |  | B = BACKORDERED | 3767C003 | GPR-61L TONER C (26K IMPRESSIONS @ 5% COVERAGE) |  | 1 |  | CSL PLASMA INC | 4610 W DIVERSEY AVE | CHICAGO | IL | 30 | SHEEHAN III, THOMAS F. |  | 0 | 2021-10-12 17:29:23
 |  |  |  | C41 | 11013679 |  | 10 |  | B = BACKORDERED | 3768C003 | GPR-61L TONER M (26K IMPRESSIONS @ 5% COVERAGE) |  | 1 |  | CSL PLASMA INC | 4610 W DIVERSEY AVE | CHICAGO | IL | 30 | SHEEHAN III, THOMAS F. |  | 0 | 2021-10-12 17:29:23
 |  |  |  | C01 | 11013679 |  | 11 |  | B = BACKORDERED | 3769C003 | GPR-61L TONER Y (26K IMPRESSIONS @ 5% COVERAGE) |  | 1 |  | CSL PLASMA INC | 4610 W DIVERSEY AVE | CHICAGO | IL | 30 | SHEEHAN III, THOMAS F. |  | 0 | 2021-10-12 17:29:23
 |  |  |  | C01 | 11025463 | 48271713 | 1 | STAGE | Y = PICKED | 3631C001 | IMAGERUNNER 1643P |  | 1 |  | BURLINGTON STORES, INC. FM | 174 ROOSEVELT RD | VILLA PARK | IL | 10 | FM - 51306 BURLINGTON STORES INC | DE LA TORRE, CRISTHIAN | 392.3 | 2021-12-29 11:23:34
 |  |  |  | C45 | 11025463 | 48271713 | 2 | STAGE | Y = PICKED | 3526C001 | TONER T06 BLACK |  | 1 |  | BURLINGTON STORES, INC. FM | 174 ROOSEVELT RD | VILLA PARK | IL | 30 | FM - 51306 BURLINGTON STORES INC | DE LA TORRE, CRISTHIAN | 0 | 2021-12-29 11:23:34
 |  |  |  | C45 | 11025464 |  | 1 |  | B = BACKORDERED | 3631C001 | IMAGERUNNER 1643P |  | 1 |  | BURLINGTON STORES, INC. FM | 174 ROOSEVELT RD | VILLA PARK | IL | 10 | FM - 51306 BURLINGTON STORES INC |  | 386.31 | 2021-12-29 11:24:02
 |  |  |  | C45 | 11025464 |  | 2 |  | B = BACKORDERED | 3526C001 | TONER T06 BLACK |  | 1 |  | BURLINGTON STORES, INC. FM | 174 ROOSEVELT RD | VILLA PARK | IL | 30 | FM - 51306 BURLINGTON STORES INC |  | 0 | 2021-12-29 11:24:02
 |  |  |  | C01 | 11025548 | 48158579 | 1 | STAGE | Y = PICKED | 5160C002 | IMAGECLASS X MF1643I II |  | 1 |  | BURLINGTON STORES, INC. FM | 174 ROOSEVELT RD | VILLA PARK | IL | 10 | FM - 51306 BURLINGTON STORES INC | DE LA TORRE, CRISTHIAN | 468.8 | 2021-12-29 12:11:36