Spreadsheet: 110758d1307377702-completing-ship-to-dates-based-on-customers-name-and-table-of-values-excel-problem
Sheet: Sheet1

Order # | Part # |  |  |  |  |  | Customer | Order Date |  | [NAME] | Shipping Date
ORD000000061840 | AT6508SP |  |  | 1 | FGATV | CATVD | A | 2011-03-14 00:00:00 |  | 1 |  |  |  | Customer | A | 21 Days
[NAME] | S6126409 |  |  | 1 | FGD40S | RTL08C | B | 2011-03-16 00:00:00 |  | 1 |  |  |  |  | B | 14 Days
[NAME] | SPECIAL1 |  |  | 1 | FGPCUS | RTL08C | B | 2011-03-16 00:00:00 |  | 1 |  |  |  |  | C | 30 Days
[NAME] | SPECIAL1 |  |  | 1 | FGPCUS | RTL08C | B | 2011-03-16 00:00:00 |  | 1 |  |  |  |  | D | 30 Days
[NAME] | SPECIAL1 |  |  | 1 | FGPCUS | RTL08C | B | 2011-03-16 00:00:00 |  | 1 |  |  |  |  | E | 30 Days
ORD000000062047 | S6126409 |  |  | 1 | FGD40S | P1001C | C | 2011-03-16 00:00:00 |  | 1 |  |  |  |  | F | 30 Days
[NAME] | S5214AL |  |  | 1 | FGGALD | SPLUS | D | 2011-03-18 00:00:00 |  | 2 |  |  |  |  | G | 21 Days
ORD000000062223 | T5053XDP |  |  | 1 | TIPS | SPLUS | E | 2011-03-21 00:00:00 |  | 250 |  |  |  |  | All Others | 7 days
ORD000000062240 | S6240AL |  |  | 1 | FGDALS | P1001U | F | 2011-03-21 00:00:00 |  | 2
ORD000000062287 | B1660BLK |  |  | 1 | FGBLK | SPLUS | E | 2011-03-22 00:00:00 |  | 1
ORD000000062398 | SPECIAL1 |  |  | 1 | FGPCUS | RTL08C | B | 2011-03-24 00:00:00 |  | 2
 | SPECIAL1 |  |  | 1 | FGPCUS | RTL08C | B | 2011-03-24 00:00:00 |  | 2
 | SPECIAL1 |  |  | 1 | FGPCUS | RTL08C | B | 2011-03-24 00:00:00 |  | 6
 | SPECIAL1 |  |  | 1 | FGPCUS | RTL08C | B | 2011-03-24 00:00:00 |  | 1
ORD000000062719 | GM8424 |  |  | 1 | FGPAL | SPLUS | G | 2011-03-31 00:00:00 |  | 9
 | S6116AL |  |  | 1 | FGD5AL | SPLUS | G | 2011-03-31 00:00:00 |  | 4
 | S6126BLK |  |  | 1 | FGBLK | SPLUS | G | 2011-03-31 00:00:00 |  | 1
 | GM8424 |  |  | 1 | FGPAL | SPLUS | G | 2011-03-31 00:00:00 |  | 3
ORD000000062728 | S5200409 |  |  | 1 | FGG40S | SPLUS | G | 2011-03-31 00:00:00 |  | 2
ORD000000062730 | B1540BLK |  |  | 1 | FGBLK | SPLUS | G | 2011-03-31 00:00:00 |  | 4
 | S7106304 |  |  | 1 | [NAME] | SPLUS | G | 2011-03-31 00:00:00 |  | 1
ORD000000062733 | S6006AL |  |  | 1 | FGDALD | SPLUS | C | 2011-03-31 00:00:00 |  | 1
 | B1660BLK |  |  | 1 | FGBLK | SPLUS | C | 2011-03-31 00:00:00 |  | 2
 | C6258409 |  |  | 1 | FGD40C | SPLUS | C | 2011-03-31 00:00:00 |  | 2
 | C6266AL |  |  | 1 | FGDALC | SPLUS | C | 2011-03-31 00:00:00 |  | 6
 | C6270409 |  |  | 1 | FGD40C | SPLUS | C | 2011-03-31 00:00:00 |  | 8
 | C6270AL |  |  | 1 | FGDALC | SPLUS | C | 2011-03-31 00:00:00 |  | 15
 | C6262409 |  |  | 1 | FGD40C | SPLUS | C | 2011-03-31 00:00:00 |  | 5
 | C6262AL |  |  | 1 | FGDALC | SPLUS | C | 2011-03-31 00:00:00 |  | 15
 | C6264409 |  |  | 1 | FGD40C | SPLUS | C | 2011-03-31 00:00:00 |  | 5
 | C6278AL |  |  | 1 | FGDALC | SPLUS | C | 2011-03-31 00:00:00 |  | 6
ORD000000062799 | S6204409 |  |  | 1 | FGD40S | SPLUS | C | 2011-04-01 00:00:00 |  | 1
 | C6258409 |  |  | 1 | FGD40C | SPLUS | C | 2011-04-01 00:00:00 |  | 5
 | C6266AL |  |  | 1 | FGDALC | SPLUS | C | 2011-04-01 00:00:00 |  | 8
 | C6270409 |  |  | 1 | FGD40C | SPLUS | C | 2011-04-01 00:00:00 |  | 8
 | C6270AL |  |  | 1 | FGDALC | SPLUS | C | 2011-04-01 00:00:00 |  | 18
 | C6262409 |  |  | 1 | FGD40C | SPLUS | C | 2011-04-01 00:00:00 |  | 6
 | C6262AL |  |  | 1 | FGDALC | SPLUS | C | 2011-04-01 00:00:00 |  | 20
 | C6264409 |  |  | 1 | FGD40C | SPLUS | C | 2011-04-01 00:00:00 |  | 8
 | C6278AL |  |  | 1 | FGDALC | SPLUS | C | 2011-04-01 00:00:00 |  | 8
ORD000000062847 | S6126409 |  |  | 1 |  |  | H | 2011-04-04 00:00:00 |  | 3
ORD000000062853 | S6218AL |  |  | 1 | FGD40S | P1001C | C | 2011-04-04 00:00:00 |  | 2
 | S6112AL |  |  | 1 |  |  | C | 2011-04-04 00:00:00 |  | 2
 | S6026AL |  |  | 1 |  |  | C | 2011-04-04 00:00:00 |  | 2
 | C6258409 |  |  | 1 | FGDALS | SPLUS | C | 2011-04-04 00:00:00 |  | 3
 | C6266AL |  |  | 1 | FGD5AL | SPLUS | C | 2011-04-04 00:00:00 |  | 4
 | C6270409 |  |  | 1 | FGDALS | SPLUS | C | 2011-04-04 00:00:00 |  | 6
 | C6270AL |  |  | 1 | FGD40C | SPLUS | C | 2011-04-04 00:00:00 |  | 10
 | C6262409 |  |  | 1 | FGDALC | SPLUS | C | 2011-04-04 00:00:00 |  | 5
 | C6262AL |  |  | 1 | FGD40C | SPLUS | C | 2011-04-04 00:00:00 |  | 8
 | C6264409 |  |  | 1 | FGDALC | SPLUS | C | 2011-04-04 00:00:00 |  | 4
 | C6278AL |  |  | 1 | FGD40C | SPLUS | C | 2011-04-04 00:00:00 |  | 5
[NAME] | S6212PLM |  |  | 1 | FGDALC | SPLUS | C | 2011-04-04 00:00:00 |  | 5
[NAME] | S6212PLM |  |  | 1 | FGD40C | SPLUS | C | 2011-04-04 00:00:00 |  | 4
ORD000000062918 | S6218P |  |  | 1 |  |  | J | 2011-04-05 00:00:00 |  | 10
 | C6280SLM |  |  | 1 |  |  | J | 2011-04-05 00:00:00 |  | 1
 | C6280PLM |  |  | 1 |  |  | J | 2011-04-05 00:00:00 |  | 1
 | C6278AL |  |  | 1 |  |  | J | 2011-04-05 00:00:00 |  | 1
 | C6276SLM |  |  | 1 |  |  | J | 2011-04-05 00:00:00 |  | 1
 | C6276PLM |  |  | 1 |  |  | J | 2011-04-05 00:00:00 |  | 1
 | C6274AL |  |  | 1 | FGDALP | SPLUS | J | 2011-04-05 00:00:00 |  | 1
 | C6270P |  |  | 1 | FGD40C | SPLUS | J | 2011-04-05 00:00:00 |  | 1
 | C6270AL |  |  | 1 | FGDALC | SPLUS | J | 2011-04-05 00:00:00 |  | 1
 | C6270409 |  |  | 1 | FGDALC | SPLUS | J | 2011-04-05 00:00:00 |  | 1
 | C6268SLM |  |  | 1 | FGD40C | SPLUS | J | 2011-04-05 00:00:00 |  | 1
 | C6268PLM |  |  | 1 | FGDALC | SPLUS | J | 2011-04-05 00:00:00 |  | 1
 | C6266AL |  |  | 1 | FGDALC | SPLUS | J | 2011-04-05 00:00:00 |  | 1
 | C6264409 |  |  | 1 | FGDALC | SPLUS | J | 2011-04-05 00:00:00 |  | 1
 | C6262AL |  |  | 1 | FGDALC | SPLUS | J | 2011-04-05 00:00:00 |  | 1
 | C6262409 |  |  | 1 | FGD40C | SPLUS | J | 2011-04-05 00:00:00 |  | 1
 | C6260SLM |  |  | 1 | FGD40C | SPLUS | J | 2011-04-05 00:00:00 |  | 1
 | C6260PLM |  |  | 1 | FGDALC | SPLUS | J | 2011-04-05 00:00:00 |  | 1
 | C6258409 |  |  | 1 | FGDALC | SPLUS | J | 2011-04-05 00:00:00 |  | 1
 | C6254SLM |  |  | 1 | FGD40C | SPLUS | J | 2011-04-05 00:00:00 |  | 1
 | C6254PLM |  |  | 1 | FGDALC | SPLUS | J | 2011-04-05 00:00:00 |  | 1
ORD000000062920 | B1610BLK |  |  | 1 | FGD40C | SPLUS | C | 2011-04-05 00:00:00 |  | 10
 | S5514AL |  |  | 1 | FGD40C | SPLUS | C | 2011-04-05 00:00:00 |  | 2
 | S5312409 |  |  | 1 | FGDALC | SPLUS | C | 2011-04-05 00:00:00 |  | 1
 | C6258409 |  |  | 1 | FGD40C | SPLUS | C | 2011-04-05 00:00:00 |  | 5
 | C6266AL |  |  | 1 | FGD40C | SPLUS | C | 2011-04-05 00:00:00 |  | 8
 | C6270409 |  |  | 1 | FGDALC | SPLUS | C | 2011-04-05 00:00:00 |  | 10
 | C6270AL |  |  | 1 |  |  | C | 2011-04-05 00:00:00 |  | 20
 | C6262409 |  |  | 1 |  |  | C | 2011-04-05 00:00:00 |  | 6
 | C6262AL |  |  | 1 | FGBLK | SPLUS | C | 2011-04-05 00:00:00 |  | 20
 | C6264409 |  |  | 1 | FGGALS | SPLUS | C | 2011-04-05 00:00:00 |  | 6
 | C6278AL |  |  | 1 | FGG40D | SPLUS | C | 2011-04-05 00:00:00 |  | 8
ORD000000062963 | S6116AL |  |  | 1 | FGD40C | SPLUS | K | 2011-04-06 00:00:00 |  | 1
ORD000000062980 | SPECIAL1 |  |  | 1 |  |  | K | 2011-04-06 00:00:00 |  | 2
 |  |  |  |  | FGDALC | SPLUS
ORD000000063139 | S6026AL |  |  | 1 | FGDALS | P1001C | L | 2011-04-11 00:00:00 |  | 2
ORD000000063183 | S5502AL |  |  | 1 | FGGALS | P1001U | D | 2011-04-12 00:00:00 |  | 1
 | S5514AL |  |  | 1 | FGGALS | P1001U | D | 2011-04-12 00:00:00 |  | 1
ORD000000063332 | AT6404SP |  |  | 1 | FGATV | CATVD | M | 2011-04-14 00:00:00 |  | 3
 | AT6508SP |  |  | 1 | FGATV | CATVD | M | 2011-04-14 00:00:00 |  | 2
 | AT7109 |  |  | 1 | FGATV | CATVD | M | 2011-04-14 00:00:00 |  | 4
ORD000000063350 | S6020AL |  |  | 1 |  |  | A | 2011-04-15 00:00:00 |  | 2
 | S6026AL |  |  | 1 |  |  | A | 2011-04-15 00:00:00 |  | 1
 | GM8424 |  |  | 1 |  |  | A | 2011-04-15 00:00:00 |  | 5
ORD000000063367 | B1530BLK |  |  | 1 | FGBLK | SPLUS | N | 2011-04-15 00:00:00 |  | 6
 | B1550BLK |  |  | 1 | FGBLK | SPLUS | N | 2011-04-15 00:00:00 |  | 5
 | C1329AL |  |  | 1 | FGPAL | SPLUS | N | 2011-04-15 00:00:00 |  | 5
 | C1348409 |  |  | 1 | FGP409 | SPLUS | N | 2011-04-15 00:00:00 |  | 5
 | C6278AL |  |  | 1 | FGDALC | SPLUS | N | 2011-04-15 00:00:00 |  | 2
 | DAL417 |  |  | 1 | FGPAL | SPLUS | N | 2011-04-15 00:00:00 |  | 10
 | S6000409 |  |  | 1 | FGD40S | SPLUS | N | 2011-04-15 00:00:00 |  | 2
 | S6000AL |  |  | 1 | FGDALS | SPLUS | N | 2011-04-15 00:00:00 |  | 2
 | S6026BLK |  |  | 1 | FGBLK | SPLUS | N | 2011-04-15 00:00:00 |  | 3
 | S6204409 |  |  | 1 | FGD40S | SPLUS | N | 2011-04-15 00:00:00 |  | 3
 | S6210AL |  |  | 1 | FGDALD | SPLUS | N | 2011-04-15 00:00:00 |  | 1
 | B1610BLK |  |  | 1 | FGBLK | SPLUS | N | 2011-04-15 00:00:00 |  | 4
 | S6100P |  |  | 1 | FGDALP | SPLUS | N | 2011-04-15 00:00:00 |  | 5
 | S9200409 |  |  | 1 | FGDSTK | SPLUS | N | 2011-04-15 00:00:00 |  | 1
ORD000000063378 | C6254PLM |  |  | 1 | FGDALC | P1001U | F | 2011-04-15 00:00:00 |  | 3
 | C6254SLM |  |  | 1 | FGD40C | P1001U | F | 2011-04-15 00:00:00 |  | 2
 | C6260PLM |  |  | 1 | FGDALC | P1001U | F | 2011-04-15 00:00:00 |  | 2
 | C6260SLM |  |  | 1 | FGD40C | P1001U | F | 2011-04-15 00:00:00 |  | 2
 | C6268PLM |  |  | 1 | FGDALC | P1001U | F | 2011-04-15 00:00:00 |  | 2
 | C6268SLM |  |  | 1 | FGD40C | P1001U | F | 2011-04-15 00:00:00 |  | 3
 | C6270P |  |  | 1 | FGDALC | P1001U | F | 2011-04-15 00:00:00 |  | 2
 | C6276PLM |  |  | 1 | FGDALC | P1001U | F | 2011-04-15 00:00:00 |  | 2
 | C6276SLM |  |  | 1 | FGD40C | P1001U | F | 2011-04-15 00:00:00 |  | 2
 | C6280PLM |  |  | 1 | FGDALC | P1001U | F | 2011-04-15 00:00:00 |  | 2
 | C6280SLM |  |  | 1 | FGD40C | P1001U | F | 2011-04-15 00:00:00 |  | 2
 | S5010409 |  |  | 1 | FGG40D | P1001U | F | 2011-04-15 00:00:00 |  | 1
 | S5300409 |  |  | 1 | FGG40D | P1001U | F | 2011-04-15 00:00:00 |  | 1
 | S5302AL |  |  | 1 | FGGALD | P1001U | F | 2011-04-15 00:00:00 |  | 1
 | S5512409 |  |  | 1 | FGG40S | P1001U | F | 2011-04-15 00:00:00 |  | 1
 | S5514AL |  |  | 1 | FGGALS | P1001U | F | 2011-04-15 00:00:00 |  | 1
ORD000000063380 | GM8424 |  |  | 1 |  |  | C | 2011-04-15 00:00:00 |  | 15
 | T5052 |  |  | 1 |  |  | C | 2011-04-15 00:00:00 |  | 10
 | S7022409 |  |  | 1 |  |  | C | 2011-04-15 00:00:00 |  | 2
 | S6218AL |  |  | 1 |  |  | C | 2011-04-15 00:00:00 |  | 2
 | S6206AL |  |  | 1 |  |  | C | 2011-04-15 00:00:00 |  | 1
 | S6100AL |  |  | 1 |  |  | C | 2011-04-15 00:00:00 |  | 8
 | B1660BLK |  |  | 1 |  |  | C | 2011-04-15 00:00:00 |  | 2