Spreadsheet: 275619d1383589348-collate-lookup-multiple-orders-at-the-same-time-based-on-date-range-in-a-table-orders
Sheet: OPEN ORDERS

ITEM | ItemCode | ItemCodeDesc | QuantityOrdered | QuantityShipped | UDF_SCHED_DATE | SalesOrderNo | OrderStatus | PromiseDate | CustomerNo | BillToName | OrderDate | Net OO | PROD AREA
^100971 | 100971 | [NAME] | 500 | 0 | 2013-11-08 00:00:00 | 0126033 | O | 2013-11-01 00:00:00 | 0010940 | ARRO ARCHERY | 2013-10-31 00:00:00 | 500 | 1
^20002 | 20002 | Medium Deer Antlers (A-1) | 1 | 0 | 2013-11-01 00:00:00 | 0126031 | O | 2013-11-01 00:00:00 | 0021333 | BLUE LAKE SPORTS INC | 2013-10-31 00:00:00 | 1 | 1
^20004 | 20004 | 3D, Drop Tine Antlers | 1 | 0 | 2013-11-04 00:00:00 | 0126036 | O | 2013-11-04 00:00:00 | 9999998 | REPLACEMENTS | 2013-10-31 00:00:00 | 1 | 2
^20125 | 20125 | 3D, Aim-Rite Bear - 2012 | 1 | 0 | 2013-01-01 00:00:00 | 0126035 | H | 2013-11-08 00:00:00 | 0060010 | SCHOOL DISTRICT OF MAPLE | 2013-10-31 00:00:00 | 1 | 2
^20125 | 20125 | 3D, Aim-Rite Bear - 2012 | 1 | 0 |  | 0124912 | O | 5999-12-31 00:00:00 | 0020298 | BOONE'S BOW SHOP | 2013-09-12 00:00:00 | 1 | 2
^20170 | 20170 | 3D, SD Series Lil Mack | 3 | 0 |  | 0125978 | N | 2013-10-28 00:00:00 | 0012459 | WAL-MART DIRECT TO STORE | 2013-10-28 00:00:00 | 3 | 2
^20180 | 20180 | 3D, 2012 Mack Daddy | 1 | 0 |  | 0124912 | O | 5999-12-31 00:00:00 | 0020298 | BOONE'S BOW SHOP | 2013-09-12 00:00:00 | 1 | 2
^20181 | 20181 | 3D, Mack Daddy Vital | 3 | 0 | 2013-11-02 00:00:00 | 0126043 | O | 2013-11-02 00:00:00 | 0049000 | DM TARGETS.COM | 2013-10-31 00:00:00 | 3 | 2
^20198 | 20198 | 3D, [NAME] Bear | 19 | 0 | 2013-10-02 00:00:00 | 0125488 | N | 2013-10-02 00:00:00 | 0010903 | BASS PRO SHOPS | 2013-10-01 00:00:00 | 19 | 2
^20201 | 20201 | 3D, [NAME] | 38 | 0 | 2013-10-02 00:00:00 | 0125488 | N | 2013-10-02 00:00:00 | 0010903 | BASS PRO SHOPS | 2013-10-01 00:00:00 | 38 | 2
^20340 | 20340 | Climbing Bear | 1 | 0 | 2013-11-15 00:00:00 | 0124157 | O | 2013-11-15 00:00:00 | 0020293 | BUGGS ISLAND ARCHERY | 2013-08-20 00:00:00 | 1 | 2
^20390 | 20390 | Turkey | 1 | 0 |  | 0124912 | O | 5999-12-31 00:00:00 | 0020298 | BOONE'S BOW SHOP | 2013-09-12 00:00:00 | 1 | 2
^20540 | 20540 | [NAME], 20542, & 20543 | 1 | 0 | 2013-11-04 00:00:00 | 0125956 | O | 2013-10-28 00:00:00 | 0012459 | WAL-MART DIRECT TO STORE | 2013-10-28 00:00:00 | 1 | 2
^20543 | 20543 | [NAME] | 1 | 0 | 2013-10-28 00:00:00 | 0125903 | O | 2013-10-24 00:00:00 | 9999998 | REPLACEMENTS | 2013-10-24 00:00:00 | 1 | 2
^20820 | 20820 | Alligator | 1 | 0 | 2013-11-15 00:00:00 | 0124157 | O | 2013-11-15 00:00:00 | 0020293 | BUGGS ISLAND ARCHERY | 2013-08-20 00:00:00 | 1 | 2
^20820 | 20820 | Alligator | 1 | 0 |  | 0125307 | N | 5999-12-31 00:00:00 | 0080016 | GOLDEN ARROW ARCHERY | 2013-09-26 00:00:00 | 1 | 2
^20850 | 20850 | SB, Bowhunter 18x18x14 | 40 | 33 | 2013-01-02 00:00:00 | 0123670 | O | 2013-08-07 00:00:00 | 0080049 | [NAME] | 2013-08-07 00:00:00 | 7 | 3
^20850 | 20850 | SB, Bowhunter 18x18x14 | 10 | 0 | 2013-01-02 00:00:00 | 0125608 | O | 2013-10-12 00:00:00 | 0080015 | OZ HUNTING AND BOWS | 2013-10-12 00:00:00 | 10 | 3
^20890 | 20890 | SB, Travel Pro 18x16x11 | 240 | 0 | 2013-01-29 00:00:00 | 0126049 | O | 2014-02-05 00:00:00 | 0012295 | [NAME] | 2013-10-24 00:00:00 | 240 | 3
^20890 | 20890 | SB, Travel Pro 18x16x11 | 325 | 110 | 2013-10-28 00:00:00 | 0125829 | N | 2013-10-28 00:00:00 | 0012069 | MILLS FLEET FARM | 2013-10-21 00:00:00 | 215 | 3
^20890 | 20890 | SB, Travel Pro 18x16x11 | 1270 | 0 | 2013-10-31 00:00:00 | 0125906 | O | 2013-10-31 00:00:00 | 0012295 | [NAME] | 2013-10-24 00:00:00 | 1270 | 3
^20890 | 20890 | SB, Travel Pro 18x16x11 | 1 | 0 | 2013-11-04 00:00:00 | 0126070 | N | 2013-11-04 00:00:00 | 0020501 | SPORTSMAN'S GUIDE | 2013-11-02 00:00:00 | 1 | 3
^20890 | 20890 | SB, Travel Pro 18x16x11 | 2 | 0 | 2013-11-06 00:00:00 | 0126046 | O | 2013-11-07 00:00:00 | 0010114 | WAYFAIR LLC | 2013-11-01 00:00:00 | 2 | 3
^20890 | 20890 | SB, Travel Pro 18x16x11 | 50 | 0 | 2013-11-06 00:00:00 | 0124309 | N | 2013-11-06 00:00:00 | 0019025 | BLAINS FARM FLEET | 2013-08-23 00:00:00 | 50 | 3
^20890 | 20890 | SB, Travel Pro 18x16x11 | 240 | 0 | 2013-12-05 00:00:00 | 0125907 | O | 2013-12-05 00:00:00 | 0012295 | [NAME] | 2013-10-24 00:00:00 | 240 | 3
^20890 | 20890 | SB, Travel Pro 18x16x11 | 240 | 0 | 2013-12-27 00:00:00 | 0125908 | O | 2013-12-27 00:00:00 | 0012295 | [NAME] | 2013-10-24 00:00:00 | 240 | 3
^20890 | 20890 | SB, Travel Pro 18x16x11 | 240 | 0 | 2014-02-25 00:00:00 | 0126050 | O | 2013-03-03 00:00:00 | 0012295 | [NAME] | 2013-10-24 00:00:00 | 240 | 3