Spreadsheet: 802222d1666709573-vlookup-seek-two-values-return-a-third-book123
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 | Pick Confirm Date | Schedule Delivery Date | Delivery Comments Date | [NAME] | Latest Comments | 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. | 19-SEP-2022 16:18:56 | 30-DEC-22 |  | ON HOLD - CLIENT |  |  | 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. | 19-SEP-2022 16:19:27 | 30-DEC-22 |  | ON HOLD - CLIENT |  |  | 16.83 | 2021-10-12 17:29:23
 |  |  |  | C01 | 11013679 |  | 3 |  | B = BACKORDERED | 5358C001 | CABINET TYPE-V |  | 1 |  | CSL PLASMA INC | 4610 W DIVERSEY AVE | CHICAGO | IL | 20 | SHEEHAN III, THOMAS F. | 19-SEP-2022 16:19:44 | 30-DEC-22 |  | ON HOLD - CLIENT |  |  | 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. | 19-SEP-2022 16:19:51 |  | 2022-09-21 10:37:32 | DO NOT CALL CUSTOMER-SCHEDULE WITH PM | PER CUSTOMER NO DELIVERY TILL NEXT YEAR | SLATER, [NAME] | 40.73 | 2021-10-12 17:29:23
 |  |  |  | C01 | 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. | 19-SEP-2022 16:19:58 | 30-DEC-22 |  | ON HOLD - CLIENT |  |  | 0 | 2021-10-12 17:29:23
 |  |  |  | C06 | 11014156 |  | 1 |  | B = BACKORDERED | 4912C002 | IMAGERUNNER ADVANCE DX C3835I |  | 1 |  | HOMEWOOD SUITES | 3701 TANACROSS DR | FORT WORTH | TX | 10 | CRUMPTON, CYNTHIA LA NETTE | 21-OCT-2021 12:27:35 | 30-DEC-22 |  | TO BE SCHEDULED |  |  | 6698.3 | 2021-10-18 12:21:18
 |  |  |  | C06 | 11014156 |  | 2 |  | R = READY TO RELEASE | 4917C002 | CASSETTE FEEDING UNIT-AW1 |  | 1 |  | HOMEWOOD SUITES | 3701 TANACROSS DR | FORT WORTH | TX | 20 | CRUMPTON, CYNTHIA LA NETTE | 21-OCT-2021 12:27:49 |  |  | CUSA BACK ORDER |  |  | 864.51 | 2021-10-18 12:21:18
 |  |  |  | C06 | 11014156 |  | 3 |  | B = BACKORDERED | 4000C002 | INNER FINISHER-L1 |  | 1 |  | HOMEWOOD SUITES | 3701 TANACROSS DR | FORT WORTH | TX | 20 | CRUMPTON, CYNTHIA LA NETTE | 21-OCT-2021 12:28:12 |  |  | CUSA BACK ORDER |  |  | 864.51 | 2021-10-18 12:21:18
 |  |  |  | C06 | 11014156 |  | 4 |  | R = READY TO RELEASE | 4919C001 | SUPER G3 FAX BOARD-BH1 |  | 1 |  | HOMEWOOD SUITES | 3701 TANACROSS DR | FORT WORTH | TX | 20 | CRUMPTON, CYNTHIA LA NETTE | 21-OCT-2021 12:28:33 |  |  | CUSA BACK ORDER |  |  | 637.83 | 2021-10-18 12:21:18
 |  |  |  | C06 | 11014156 |  | 5 |  | R = READY TO RELEASE | 2368V120 | MID VOLUME CONNECTIVITY 30+PPM UP TO 79PPM |  | 1 |  | HOMEWOOD SUITES | 3701 TANACROSS DR | FORT WORTH | TX | 20 | CRUMPTON, CYNTHIA LA NETTE | 21-OCT-2021 12:28:50 |  |  | CUSA BACK ORDER |  |  | 83.34 | 2021-10-18 12:21:18
 |  |  |  | C06 | 11014156 |  | 6 |  | B = BACKORDERED | 1972V064 | ESP NEXT GEN PCS POWER FILTER 120VOLTS 15 AMP XG-PCS-15D |  | 1 |  | HOMEWOOD SUITES | 3701 TANACROSS DR | FORT WORTH | TX | 20 | CRUMPTON, CYNTHIA LA NETTE | 10-NOV-2021 16:10:44 | 30-DEC-22 |  | TO BE SCHEDULED |  |  | 147.79 | 2021-10-18 12:21:18
 |  |  |  | C41 | 11026091 |  | 2238 |  | B = BACKORDERED | 4056C002 | IMAGERUNNER ADVANCE DX 4725I |  | 1 |  | NFI INDUSTRIES INC | 5564 ALAN B SHEPARD ST | TRENTON | OH | 10 | POLAND, MARCELLUS C. | 14-JUN-2022 11:25:02 | 31-DEC-23 |  | ROLL OUT SCHEDULE |  |  | 2152.77 | 2022-01-06 15:09:10
 |  |  |  | C41 | 11026091 |  | 2239 |  | B = BACKORDERED | 1419C002 | CASSETTE FEEDING UNIT-AN1 |  | 1 |  | NFI INDUSTRIES INC | 5564 ALAN B SHEPARD ST | TRENTON | OH | 20 | POLAND, MARCELLUS C. | 14-JUN-2022 11:25:07 | 31-DEC-23 |  | ROLL OUT SCHEDULE |  |  | 605.51 | 2022-01-06 15:09:10
 |  |  |  | C41 | 11026091 |  | 2240 |  | B = BACKORDERED | 1423C002 | INNER FINISHER-J1 |  | 1 |  | NFI INDUSTRIES INC | 5564 ALAN B SHEPARD ST | TRENTON | OH | 20 | POLAND, MARCELLUS C. | 14-JUN-2022 11:25:14 | 31-DEC-23 |  | ROLL OUT SCHEDULE |  |  | 559.6 | 2022-01-06 15:09:10
 |  |  |  | C41 | 11026091 |  | 2241 |  | B = BACKORDERED | 3813C001 | DADF-BA1 |  | 1 |  | NFI INDUSTRIES INC | 5564 ALAN B SHEPARD ST | TRENTON | OH | 20 | POLAND, MARCELLUS C. | 14-JUN-2022 11:25:20 | 31-DEC-23 |  | ROLL OUT SCHEDULE |  |  | 372.8 | 2022-01-06 15:09:10