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

Priority | Month | Whse | Order# | Delivery# | Line# | Subinventory | Delivery Status | Item Number | Description | Serial | Qty | Ship To Party | Ship Address 1 | Ship City | State | Merch | Salesrep | Pick Confirm Date | Schedule Delivery Date | Delivery Comments Date | [NAME] | Latest Comments | Delivery Comments Employee | Line Selling Price | Ordered Date
 |  | A01 | 9017024 |  | 6 |  | R = READY TO RELEASE | 6986B069 | THEREFORE SAL CAPTURE LICENSE (1 UNIT / 1 YEAR) |  | 100 | GEA SYSTEMS NORTH AMERICA LLC | 100 FAIRWAY CT | NORTHVALE | NJ | 59 | ABDO, [NAME] |  |  |  |  |  |  | 57906 | 2021-03-31 10:08:51
 |  | A01 | 11003618 | 46666343 | 1 |  | S = RELEASED | 2861V998 | HID MICROPROX TAG 1391LSSMN H10301 FC 30 - BDG-1391 |  | 2000 | CAMPBELL SOUP COMPANY FM | 1 CAMPBELL PL | CAMDEN | NJ | 20 | FM - 60016 CAMPBELL SOUP | 16-AUG-2021 14:14:23 |  | 2021-12-28 18:30:17 | SCHEDULED | this is interfaced in oracle, tracking # [PHONE] shipped 8/17/2021. have escalated to Nitin 3 times | STRATTON, [NAME] | 6660 | 2021-08-05 15:06:41
 |  | A01 | 11004790 |  | 2 |  | B = BACKORDERED | 8002A017 | X-RITE I1PRO 3 SPECTROPHOTOMETER |  | 1 | BRIDGEWATER ASSOCIATES LP FM | 1 GLENDINNING PL | WESTPORT | CT | 20 | LEWIS, [NAME] | 25-OCT-2021 15:54:15 |  |  | CUSA BACK ORDER |  |  | 0 | 2021-08-16 11:00:38
 |  | A01 | 11004790 |  | 2 |  | B = BACKORDERED | 8985B023 | CABLE, C13 US (N5/15)(POS) |  | 1 | BRIDGEWATER ASSOCIATES LP FM | 1 GLENDINNING PL | WESTPORT | CT | 20 | LEWIS, [NAME] | 25-OCT-2021 15:54:25 |  |  | CUSA BACK ORDER |  |  | 0 | 2021-08-16 11:00:38
 |  | A01 | 11004790 |  | 2 |  | B = BACKORDERED | 3656C010 | IPR SVR H350 V2.0 (POS) |  | 1 | BRIDGEWATER ASSOCIATES LP FM | 1 GLENDINNING PL | WESTPORT | CT | 20 | LEWIS, [NAME] | 26-OCT-2021 09:14:34 |  |  | CUSA BACK ORDER |  |  | 0 | 2021-08-16 11:00:38
 |  | A01 | 11004790 |  | 3 |  | B = BACKORDERED | 3217V467 | INTEGRATED INTERFACE & STAND-NX GL |  | 1 | BRIDGEWATER ASSOCIATES LP FM | 1 GLENDINNING PL | WESTPORT | CT | 20 | LEWIS, [NAME] | 26-OCT-2021 09:15:09 |  |  | CUSA BACK ORDER |  |  | 0 | 2021-08-16 11:00:38
 |  | A01 | 11004790 |  | 4 |  | B = BACKORDERED | 1498V944 | HAMMERMILL REAM COLOR COPY LASER PRINT 11 X 17 28#  98 BRIGHT 500 SHEETS - HAM102541 |  | 1 | BRIDGEWATER ASSOCIATES LP FM | 1 GLENDINNING PL | WESTPORT | CT | 30 | LEWIS, [NAME] | 25-OCT-2021 15:54:36 |  |  | CUSA BACK ORDER |  |  | 0 | 2021-08-16 11:00:38
 |  | A01 | 11004790 |  | 9 |  | B = BACKORDERED | 3077B137 | FIERY JOBMASTER IMPOSE SET (WITHOUT ACROBAT AND ENFOCUS EDIT) |  | 1 | BRIDGEWATER ASSOCIATES LP FM | 1 GLENDINNING PL | WESTPORT | CT | 53 | LEWIS, [NAME] | 29-MAR-2022 15:53:33 |  |  | CUSA BACK ORDER |  |  | 0 | 2021-08-16 11:00:38
 |  | A01 | 11004790 |  | 9 |  | B = BACKORDERED | 3077B116 | FIERY JOBMASTER-­-IMPOSE ANNUAL SUPPORT & MAINTENANCE POP AND RENEWAL |  | 1 | BRIDGEWATER ASSOCIATES LP FM | 1 GLENDINNING PL | WESTPORT | CT | 54 | LEWIS, [NAME] | 27-OCT-2021 11:21:30 |  |  | CUSA BACK ORDER |  |  | 0 | 2021-08-16 11:00:38
 |  | A01 | 11004790 |  | 12 |  | B = BACKORDERED | 3243C001 | STACK BYPASS ALIGNMENT TRAY-D1 |  | 1 | BRIDGEWATER ASSOCIATES LP FM | 1 GLENDINNING PL | WESTPORT | CT | 20 | LEWIS, [NAME] | 26-OCT-2021 09:15:30 |  |  | CUSA BACK ORDER |  |  | 0 | 2021-08-16 11:00:38
 |  | A01 | 11004790 |  | 13 |  | B = BACKORDERED | 8930B001 | [NAME] |  | 1 | BRIDGEWATER ASSOCIATES LP FM | 1 GLENDINNING PL | WESTPORT | CT | 20 | LEWIS, [NAME] | 25-OCT-2021 15:55:20 |  |  | CUSA BACK ORDER |  |  | 0 | 2021-08-16 11:00:38
 |  | A01 | 11004790 |  | 14 |  | B = BACKORDERED | 0118C002 | [NAME] |  | 1 | BRIDGEWATER ASSOCIATES LP FM | 1 GLENDINNING PL | WESTPORT | CT | 20 | LEWIS, [NAME] | 29-MAR-2022 14:48:47 |  |  | CANCELLED |  |  | 0 | 2021-08-16 11:00:38