Spreadsheet: 140934d1328970091-excel-2007-multiple-indentical-lookups-required-from-table-array-excel-forum-help
Sheet: Sheet1

 |  |  |  |  |  |  |  | Mfg | Q u a n t i t y |  |  |  |  |  | S t a t u s
Required |  | Order No. | Type |  | Est.# | Container ID | PO# | Plt | Order | Mfg | Inven | Shpd |  | [NAME] | Mfg | Shpd
2012-01-20 00:00:00 | EDMW | Y9346001 | R |  | 69517201 | 10K |  | CAL | 3000 | 3035 | 1440 | 2075 |  | 15:37:00 | CP | SHP
2012-01-20 00:00:00 | EDMW | Y9574601 | R |  | 69241101 | BACON MASTER LID (AL |  | CAL | 1500 | 1410 | 660 | 750 |  | 2012-01-25 00:00:00 | CP | SHP
2012-01-23 00:00:00 | EDMW | [NAME] | R |  | A4428301 | 158 E (VMI) |  | CAL | 10000 | 9615 | 7815 | 3000 |  | 15:37:00 | CP | SHP
2012-01-23 00:00:00 | EDMW | Y9593901 | R |  | A4372401 | 169 A (VMI) |  | CAL | 18000 | 8920 | 11340 | 7920 |  | 15:38:00 | MC60 | SHP
2012-01-24 00:00:00 |  | Y9756401 | R |  | 68916801 | *** 148 U (20KG.MSM) |  | CAL | 7500 | 5600 |  |  |  |  | MC82
2012-01-27 00:00:00 | EDMW | Y9378501 | R |  | 80109101 | 504 A (PALLET SHEET) |  | CAL | 2880 | 3150 | 3120 |  |  |  | CP
2012-01-27 00:00:00 | EDMW | [NAME] | R |  | A3632701 | 161 L (SOUTH) (VMI) |  | CAL | 12250 | 10150 | 8925 | 1225 |  | 2012-01-31 00:00:00 | MC60 | SHP
2012-01-30 00:00:00 | EDMW | Y9577201 | R |  | 69773001 | 118 A |  | CAL | 1600 | 1450 | 1450 |  |  |  | CP
2012-01-30 00:00:00 | EDMW | Y9594001 | R |  | 69242401 | BACON MASTER BODY (A |  | CAL | 1500 | 1586 | 1586 |  |  |  | CP
2012-01-30 00:00:00 | EDMW | Y9821801 | T |  | 68916801 | *** 148 U (20KG.MSM) |  | CAL | 3840 |  |  | 640 |  | 2012-02-03 00:00:00 | CP | SHP
2012-01-31 00:00:00 |  | [NAME] | T |  | 68187201 | <<>>*** 235 A (ALTA/ |  | CAL | 1000 |  |  |  |  |  | CP
2012-02-01 00:00:00 | EDMW | Y9593801 | R |  | A3366701 | 542 D(BULK PEPPERONI |  | REG | 6400 | 6620 | 2800 | 3820 |  | 15:38:00 | CP | SHP
2012-02-02 00:00:00 | EDMW | Y9702501 | R |  | A2625101 | 172 E (VMI) |  | CAL | 10500 | 9720 | 5980 | 4540 |  | 2012-02-07 00:00:00 | CP | SHP
2012-02-03 00:00:00 | EDMW | Y9594101 | R |  | A2746901 | 502 C (SANDWICH OPEN |  | WPG | 8000 | 7974 | 7974 |  |  |  | CP
2012-02-06 00:00:00 | EDMW | [NAME] | R |  | A1668401 | 153 F (LID 8-2P FAST |  | REG | 10000 | 10134 |  |  |  |  | MC80
2012-02-06 00:00:00 | EDMW | Y9768501 | R |  | A1668402 | 153 F (BODY 8-2P FAS |  | REG | 12000 | 12390 |  |  |  |  | MC80
2012-02-07 00:00:00 | EDMW | Y9702601 | R |  | 68469901 | 173 E (VMI) |  | WPG | 14000 | 13902 | 13902 |  |  |  | CP
2012-02-07 00:00:00 | EDMW | Y9748801 | R |  | 69598301 | 116A GROUND TURKEY ( |  | CAL | 10000 | 10975 | 8725 | 2250 |  | 15:37:00 | CP | SHP
2012-02-07 00:00:00 | EDMW | Y9752501 | R |  | 69572301 | 117 A |  | CAL | 5000 | 6725 | 6725 |  |  |  | CP
2012-02-08 00:00:00 | EDMW | Y9702701 | R |  | 69426301 | 175 SUB |  | CAL | 10000 | 9150 | 9150 |  |  |  | CP
2012-02-08 00:00:00 | EDMW | Y9767101 | R |  | A2999901 | 134 H (BODY HEN)(VMI |  | CAL | 10000 | 9410 | 7250 | 2160 |  | 15:37:00 | CP | SHP
2012-02-08 00:00:00 | EDMW | [NAME] | R |  | A2999902 | 134 H (LID HEN) (VMI |  | CAL | 10000 | 10938 | 10438 | 500 |  | 08:47:00 | CP | SHP
2012-02-09 00:00:00 | EDMW | Y9702301 | R |  | A1925001 | 164 P (FOOD SERVICE/ |  | CAL | 12000 | 12614 |  |  |  |  | MC01
2012-02-09 00:00:00 | EDMW | Y9768101 | R |  | [NAME] | 135 G (BODY HEN/TOM |  | CAL | 10000 |  |  |  |  |  | NEW
2012-02-09 00:00:00 | EDMW | Y9768201 | R |  | A3000302 | 135 G (LID HEN/TOM) |  | CAL | 10000 | 5058 |  |  |  |  | MC01
2012-02-10 00:00:00 | EDMW | Y9766201 | R |  | A2999701 | 133 I (BODY) (BROILE |  | CAL | 3000 |  |  |  |  |  | NEW
2012-02-10 00:00:00 | EDMW | Y9766301 | R |  | A2999702 | 133 I (LID)(BROILER) |  | CAL | 3000 | 1517 |  |  |  |  | MC01
2012-02-13 00:00:00 | EDMW | Y9378201 | R |  | A4428301 | 158 E (VMI) |  | CAL | 10000 |  |  |  |  |  | NEW
2012-02-15 00:00:00 | EDMW | Y9769601 | R |  | A3366701 | 542 D(BULK PEPPERONI |  | REG | 6400 | 1750 |  |  |  |  | MC01
2012-02-17 00:00:00 | EDMW | [NAME] | R |  | A2625101 | 172 E (VMI) |  | WPG | 10500 | 10655 |  |  |  |  | MC01
2012-02-21 00:00:00 | EDMW | Y9702101 | R |  | A4372401 | 169 A (VMI) |  | CAL | 18000 |  |  |  |  |  | NEW
2012-02-21 00:00:00 | EDMW | Y9769401 | R |  | 68469901 | 173 E (VMI) |  | CAL | 14000 |  |  |  |  |  | NEW
2012-02-21 00:00:00 | EDMW | Y9769801 | R |  | 69628401 | 6 X 1KG CMI |  | REG | 10000 |  |  |  |  |  | NEW
2012-02-21 00:00:00 | EDMW | Y9846201 | R |  | 69517201 | 10K |  | CAL | 3000 |  |  |  |  |  | NEW
2012-02-21 00:00:00 | EDMW | Y9874801 | R |  | 67985701 | 239 A/BODY 4 BLOCK T |  | CAL | 7500 |  |  |  |  |  | NEW
2012-02-21 00:00:00 |  | Y9874901 | R |  | 67985801 | 239 A/LID 4 BLOCK TR |  | CAL | 5000 |  |  |  |  |  | NEW
2012-02-21 00:00:00 | EDMW | [NAME] | R |  | C6039601 | 103 G BODY (ROASTER) |  | REG | 4000 |  |  |  |  |  | NEW
2012-02-21 00:00:00 | EDMW | Y9912101 | R |  | C6039602 | 103 G LID (ROASTER) |  | REG | 4000 |  |  |  |  |  | NEW
2012-02-22 00:00:00 | EDMW | Y9768701 | R |  | A1925001 | 164 P (FOOD SERVICE/ |  | CAL | 15000 |  |  |  |  |  | NEW
2012-02-23 00:00:00 | EDMW | Y9766101 | R |  | 69598301 | 116A GROUND TURKEY ( |  | CAL | 10000 |  |  |  |  |  | NEW
2012-02-23 00:00:00 | EDMW | [NAME] | R |  | A3632701 | 161 L (SOUTH) (VMI) |  | CAL | 12250 |  |  |  |  |  | NEW
2012-02-29 00:00:00 | EDMW | Y9769701 | R |  | A3366701 | 542 D(BULK PEPPERONI |  | REG | 6400 |  |  |  |  |  | NEW
2012-03-01 00:00:00 | EDMW | Y9901701 | R |  | A1925001 | 164 P (FOOD SERVICE/ |  | CAL | 15000 |  |  |  |  |  | NEW
2012-03-05 00:00:00 | EDMW | Y9892101 | R |  | 69598301 | 116A GROUND TURKEY ( |  | CAL | 10000 |  |  |  |  |  | NEW