Spreadsheet: 167918d1342157047-problem-calculating-a-cell-based-on-the-specific-content-of-another-cell-test-order-form
Sheet: Sheet1

MORTON-CLARKE ORDER FORM |  |  |  |  | LAST UPDATED |  | 2012-01-03 00:00:00
THIS ORDER MUST MEET THE MINIUM ORDER REQUIREMENTS OF $1000.00
ONLY COMPLETE COLUMN K (CURRENT CASE OH) TO POPULATE BALANCE OF ORDER AUTOMATICALLY
FAX ORDER TO DOLLAR TREE MERCHANDISE CONTROL DEPARTMENT AT |  |  |  | [PHONE]
FOR QUESTIONS RELATED TO ORDERING OR RECEIVING EMAIL OR CALL [PHONE] OPTION 2 THEN 13020
STORE # |  |  | ORDER TOTAL RETAIL | ORDER DATE |  | PREPARED BY
40106 |  |  |  | 2012-06-28 00:00:00 |  | MIKE
DEPT | SDEPT | SKU | [NAME] | VENDOR PART | CASE PACK | UNIT RETAIL | STORE ORDER QTY (UNITS) | [NAME] | MIN O.H. BOX REQ | CURRENT FULL BOX O.H. | TILL 1 |  | TILL 2 |  | TILL 3 |  | TILL 4 |  | TILL 5 |  | TILL 6 |  | TILL 7 |  | ISLE                         Q LINE |  | ISLE          9 |  | ISLE            10 |  | ISLE       13
10 | 10 | 133491 | MAYNARDS ORIGINAL GUMMIES | 554032 | 18 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 0 |  |  |  |  | have data validation in cell AC 13
10 | 10 | 133493 | MAYNARDS WINE GUM ROLLS | 554002 | 18 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  |  |  |  |  | click data - validation on the menu look at custom validation...
10 | 10 | 133495 | MAYNARDS FUZZY PEACH | 554026 | 18 | 0.79 |  |  |  |  | 1 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 2
10 | 10 | 133497 | MAYNARDS JUICY [NAME] | 554061 | 18 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 10 | 133499 | MAYNARDS SOUR PATCH KIDS | 554672 | 18 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 10 | 133501 | DG GOOD & PLENTY 170G | 591308 | 12 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  | 16
10 | 20 | 133515 | [NAME] 39G | 550117 | 36 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
10 | 20 | 133533 | [NAME] ALMOND 43G | 551242 | 36 | 0.79 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 133551 | DG REESE PNUT BTR CUPS 51G | 552166 | 48 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 133553 | DG REESES PIECES 51G | 552364 | 36 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
10 | 20 | 133576 | [NAME] DUDS 141G | 591281 | 12 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  | 16
10 | 20 | 139539 | [NAME] DRK W/ALMND | 550312 | 36 | 0.79 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 139541 | DG HERSHEY EATMORE 56G | 550848 | 48 | 0.79 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  |  |  |  |  |  | 2
10 | 20 | 139567 | DG KIT KAT CHNKY [NAME] KNG SZ | 552026 | 24 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 3
10 | 20 | 133585 | DG HERSHEY COOKIES & CRM 43G | 551317 | 36 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 133590 | DG NESTLE COFFEE CRISP KING SZ | 551820 | 24 | 1 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 3
10 | 20 | 133592 | DG OH HENRY 62.5G | 552131 | 24 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 133599 | DG WHOPPERS 113G | 591292 | 12 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
10 | 20 | 834401 | SNICKERS 2.07Z | 552646 | 48 | 0.79 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
10 | 10 | 139584 | DG MAYNARDS SOUR WINE GUMMIES | 554020 | 18 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 10 | 139586 | MAYNARDS SOUR CHERRY [NAME] | 554038 | 18 | 0.79 |  |  |  |  | 1 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 2
10 | 10 | 139590 | DG MAYNARDS SWEDISH BERRIES | 554044 | 18 | 0.79 |  |  |  |  | 1 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 2
10 | 10 | 139592 | [NAME] CHILLERS | 554693 | 18 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 133511 | DG AERO CHOCOLATE NESTLE 42G | 550046 | 48 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 133513 | BUTTER FINGER BAR NESTLE 59 | 550053 | 36 | 0.79 |  |  |  |  |  |  |  |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 133517 | BIG TURK NESTLE 60G | 550327 | 36 | 0.79 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 133521 | CADBURY CARAMILK 52G | 550483 | 48 | 0.79 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 133535 | CADBURY JERSEY MILK 45G | 551408 | 24 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | 3
10 | 20 | 133549 | CADBURY MR BIG 60G | 552056 | 24 | 0.79 |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 133555 | CADBURY SWEET MARIE | 552521 | 24 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 133557 | SMARTIES NESTLE 50G | 552562 | 48 | 0.79 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 133559 | CADBURY WUNDERBAR 58G | 553012 | 24 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 2
10 | 20 | 133565 | CADBURY DAIRY MILK BAR 42G | 555412 | 24 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
10 | 20 | 133567 | CADBURY HAZELNUT 42G | 555422 | 24 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
10 | 20 | 133579 | CADBURY CRISPY CRUNCH 48G | 550406 | 24 | 0.79 |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
10 | 20 | 133581 | COFFEE CRISP NESTLE 50G | 550640 | 48 | 0.79 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 133583 | CADBURY CRUNCHIE 44G | 550687 | 24 | 0.79 |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 133589 | NESTLE KIT KAT 45G | 551481 | 48 | 0.79 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 137592 | NESTLE KIT KAT CHUNKY 50G | 551440 | 24 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 2
10 | 20 | 133523 | SNICKERS KNGSZ EFFEM 104G | 550616 | 24 | 1 |  |  |  |  |  |  | 2 |  |  |  |  |  | 1 |  |  |  | 1 |  |  |  |  |  | 3
10 | 20 | 133569 | MARS KNG SZ EFFEM 95G | 558156 | 24 | 1 |  |  |  |  |  |  | 1 |  | 2 |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 3
10 | 20 | 133514 | MARS DARK EFFEM 50G | 550095 | 24 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 133529 | BOUNTY EFFEM 57G | 551150 | 24 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
STORE # |  |  | ORDER TOTAL RETAIL | ORDER DATE |  | PREPARED BY
DEPT | SDEPT | SKU | [NAME] | VENDOR PART | CASE PACK | UNIT RETAIL | STORE ORDER QTY (UNITS) | [NAME]
10 | 20 | 133537 | M&M PLAIN EFFEM 48G | 551804 | 48 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 133543 | [NAME] 49G | 551846 | 48 | 0.79 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 133545 | MARS SINGLE BAR EFFEM 58G | 552001 | 48 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 133561 | TWIX EFFEM 57G | 553363 | 36 | 0.79 |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
10 | 20 | 133563 | NESTLE MIRAGE BAR 41G | 553487 | 36 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 137530 | BOUNTY DARK CHOC EFFEM | 551162 | 24 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
10 | 20 | 139537 | NESTLE AERO PEPPERMINT 41G | 550089 | 24 | 0.79 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 139559 | [NAME] 30G | 551549 | 24 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 139579 | SNICKERS ALMOND SZ 50G | 552652 | 24 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 139583 | THREE MUSKETEERS BAR 60G | 552760 | 36 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
10 | 20 | 139593 | [NAME] DAIRY FRT&NUT 42G | 555418 | 24 | 0.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
10 | 30 | 133604 | CLORETS ORIGINAL | 572404 | 12 | 0.79 |  |  |  |  | 2 |  |  |  | 4
10 | 30 | 133605 | CLORETS SUGARLESS | 572419 | 12 | 0.79 |  |  |  |  | 2 |  | 4 |  | 4
10 | 30 | 133606 | [NAME] CINNAMON | 573294 | 12 | 0.79 |  |  |  |  | 4 |  |  |  | 4
10 | 30 | 133607 | [NAME] ICE INTENSE | 573299 | 12 | 0.79 |  |  |  |  | 2 |  | 4 |  |  |  | 4
10 | 30 | 133609 | [NAME] ICE [NAME] | 573304 | 12 | 0.79 |  |  |  |  | 2 |  | 4 |  | 4 |  | 4
10 | 30 | 133611 | [NAME] ICE SHIVER | 573334 | 12 | 0.79 |  |  |  |  |  |  |  |  |  |  | 4
10 | 30 | 133613 | [NAME] SHINE PEPPERMINT | 573339 | 12 | 0.79 |  |  |  |  | 4 |  |  |  |  |  | 4
10 | 30 | 133615 | [NAME] SHINE GUM SPEARMINT | 573347 | 12 | 0.79 |  |  |  |  | 4 |  |  |  |  |  | 4
10 | 30 | 139617 | [NAME] ICE PEPPERMINT GUM | 573303 | 12 | 0.79 |  |  |  |  | 4 |  | 4 |  | 4
10 | 30 | 139622 | [NAME] ICE SPEARMINT | 573311 | 12 | 0.79 |  |  |  |  | 4 |  |  |  |  |  | 4
14 | 20 | 133617 | UB HMSTYL CHX FLV & WLD RICE | 402243 | 12 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
14 | 20 | 133621 | UB GARDEN VEG STYLE RICE | 402254 | 12 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
14 | 20 | 133623 | UB FST & FCY RICE CNTRY CHX | 402266 | 12 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
14 | 20 | 133627 | UB FST & FCY HERB WILD RICE | 402278 | 12 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
14 | 20 | 133631 | UB FST & FNCY RC CHINSE FRIED | 402288 | 12 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
14 | 20 | 133633 | UB FST & FNCY RC BROC & CHDDR | 402299 | 12 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
80 | 10 | 139533 | DG WHISKAS W/REAL TUNA | 404633 | 24 | 1.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
80 | 10 | 133634 | WHISKAS W/REAL CHIX N SAUCE | 404479 | 24 | 0.62 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
80 | 10 | 133635 | WHISKAS W/REAL BF CUTS GRVY | 404501 | 24 | 0.62 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
80 | 10 | 133637 | WHISKAS W/REAL SALMON N JCE | 404534 | 24 | 0.62 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
80 | 10 | 133638 | WHISKAS W/REAL BF BITE GRVY | 404578 | 24 | 0.62 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
80 | 10 | 133640 | WHISKAS W/REAL TUNA N JUICE | 404611 | 24 | 0.62 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
80 | 10 | 133643 | WHISKAS BEEF | 404645 | 24 | 1.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
80 | 10 | 133645 | [NAME] | 404656 | 24 | 1.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
80 | 10 | 133646 | WHISKAS CHC CUTS BF N CHX | 404667 | 24 | 1.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
80 | 10 | 133647 | WHISKAS CHC CUT CHX N LVR | 404678 | 24 | 1.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
80 | 10 | 133648 | PEDIGREE CHICKEN | 404424 | 24 | 1.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
80 | 10 | 133649 | PEDIGREE BEEF | 404435 | 24 | 1.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
80 | 10 | 133653 | PEDIGREE VARIETY PACK | 404457 | 24 | 1.25
80 | 10 | 139531 | WHISKAS CAT FOOD TURKEY 85GR | 404600 | 24 | 0.62 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
80 | 30 | 138211 | WHISKAS W/REAL CHX N SAUCE | 404556 | 24 | 0.62 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  | OREDER TOTAL RETAIL