Spreadsheet: 266978d1379885709-vlookup-for-finding-value-that-may-only-appear-on-one-of-seven-worksheets-supplier-pricing-sept-2013
Sheet: Coke 535263

 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year:
 |  |  |  |  |  |  |  | 535263
 |  |  |  | Vendor:
 |  |  |  | Calendar: |  |  |  | D |  |  |  |  |  |  |  |  |  | Period:
 |  |  |  | Date From: |  |  |  | 9/1/2013 |  |  |  | Date To: |  | 9/27/2013 |  |  |  | Week:
 |  |  |  | Item No.: |  |  |  |  |  |  |  | Item Description:
 |  |  |  | Reporting Level: |  |  |  | UnitNm
 |  |  |  | Reporting Entities: |  |  |  | 23143
 |  |  | Unit Name: VICTORIA HOSPITAL - FAYES - 23143
 |  |  | Row # |  | Item No. | Item Desc. |  |  |  |  |  |  |  |  | Brand |  | Pack Size |  | UOM |  |  | Item Price | Qty. Received | Total Item Amount |  |  | Vendor
 |  |  | 1 |  | 00059531002205 | A&W Rootbeer Fridge Pack 12/355 Ml |  |  |  |  |  |  |  |  | A&W |  |  |  |  |  |  | 5.33 | 2 | 10.66 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 2 |  | 00059531003202 | 355ML12PK A&W DT RB FRDG |  |  |  |  |  |  |  |  | Coca-Cola Bottling |  | 355 |  |  |  |  | 5.33 | 2 | 10.66 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 3 |  | 00059600160591 | Minute [NAME] 12/450 ml new graphics |  |  |  |  |  |  |  |  | MINUTE MAID |  |  |  |  |  |  | 12.36 | 9 | 111.24 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 4 |  | 00059600160607 | Minute [NAME] 12/450 ml new graphics |  |  |  |  |  |  |  |  | MINUTE MAID |  |  |  |  |  |  | 11.07 | 9 | 99.63 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 5 |  | 00059600160638 | Minute [NAME] 12/450 ml new graphics |  |  |  |  |  |  |  |  | MINUTE MAID |  |  |  |  |  |  | 11.07 | 4 | 44.28 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 6 |  | 00059600160645 | Minute [NAME] 12/450 ml new graphics |  |  |  |  |  |  |  |  | MINUTE MAID |  |  |  |  |  |  | 11.07 | 8 | 88.56 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 7 |  | 00059600160652 | Minute [NAME] 12/450 ml new graphics |  |  |  |  |  |  |  |  | MINUTE MAID |  |  |  |  |  |  | 11.07 | 5 | 55.35 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 8 |  | 00062100004098 | Canada Dry Ginger Ale 24/591 Ml |  |  |  |  |  |  |  |  | CANADA DRY |  |  |  |  |  |  | 20.37 | 9 | 183.33 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 9 |  | 00063211129953 | 354MLNRP12L V8 VEG CKTL |  |  |  |  |  |  |  |  | Coca-Cola Bottling |  | 354 |  |  |  |  | 15.39 | 3 | 46.17 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 10 |  | 00063211149029 | V8 V-Go Vegetable Cocktail 12/354 Ml |  |  |  |  |  |  |  |  | V8 |  |  |  |  |  |  | 15.39 | 1 | 15.39 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 11 |  | 00067000010118 | Coca-Cola Classic 24/355 Ml 00067000101663 |  |  |  |  |  |  |  |  | Coca-Cola |  |  |  |  |  |  | 10.65 | 19 | 202.35 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 12 |  | 00067000010125 | Sprite 24/355 Ml |  |  |  |  |  |  |  |  | SPRITE |  |  |  |  |  |  | 10.65 | 5 | 53.25 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 13 |  | 00067000010132 | Diet Coke 24/355 Ml |  |  |  |  |  |  |  |  | Diet Coke |  |  |  |  |  |  | 10.65 | 11 | 117.15 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 14 |  | 00067000103049 | Coca-Cola Classic 24/591 Ml |  |  |  |  |  |  |  |  | Coca-Cola |  |  |  |  |  |  | 20.37 | 18 | 366.66 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 15 |  | 00067000103056 | Diet Coke 24/591 Ml |  |  |  |  |  |  |  |  | Diet Coke |  |  |  |  |  |  | 20.37 | 12 | 244.44 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 16 |  | 00067000103117 | Fresca 24/591 Ml |  |  |  |  |  |  |  |  | FRESCA |  |  |  |  |  |  | 20.37 | 5 | 101.85 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 17 |  | 00067000103131 | Sprite Regular 24/591 Ml |  |  |  |  |  |  |  |  | SPRITE |  |  |  |  |  |  | 20.37 | 5 | 101.85 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 18 |  | 00067000106668 | Coke Zero Pet 24/591 Mil |  |  |  |  |  |  |  |  | COKE |  |  |  |  |  |  | 20.37 | 12 | 244.44 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 19 |  | 00067000107498 | Coke Zero 24/355 Ml |  |  |  |  |  |  |  |  | COKE |  |  |  |  |  |  | 10.65 | 5 | 53.25 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 20 |  | 00067000109225 | [NAME] |  |  |  |  |  |  |  |  | POWERADE |  |  |  |  |  |  | 29.42 | 1 | 29.42 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 21 |  | 00067000109232 | Powerade Fruit Punch Ion [NAME] |  |  |  |  |  |  |  |  | POWERADE |  |  |  |  |  |  | 29.42 | 1 | 29.42 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 22 |  | 00083900003777 | Nestea Zero 12/341 Ml |  |  |  |  |  |  |  |  | NESTEA |  |  |  |  |  |  | 5.79 | 4 | 23.16 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 23 |  | 00083900106263 | Nestea Tea Iced Sweetened W/Lemon 12/500 Ml |  |  |  |  |  |  |  |  | NESTEA |  |  |  |  |  |  | 9.8 | 15 | 147 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 24 |  | 00083900106270 | Nestea Tea Iced Zero 12/591 Ml |  |  |  |  |  |  |  |  | NESTEA |  |  |  |  |  |  | 9.8 | 8 | 78.4 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 25 |  | 00083900106287 | 500MLPET12L NT LEM GRN T |  |  |  |  |  |  |  |  | Coca-Cola Bottling |  | 500 |  |  |  |  | 9.8 | 8 | 78.4 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 26 |  | 00786162103628 | [NAME] 12/591 ml |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 15.23 | 1 | 15.23 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 27 |  | 00786162103635 | Glaceau Vitaminwater Zero Resilient 12/591 ml |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 15.23 | 1 | 15.23 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 28 |  | 00786162103642 | Glaceau Vitaminwater Zero XOXOXO 12/591 ml |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 15.23 | 1 | 15.23 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 29 |  | 00786162650047 | Glaceau Essential 12/591 Ml |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 15.23 | 3 | 45.69 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 30 |  | 00786162650085 | [NAME] Vitamin Water Multi V 12/591 Ml |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 15.23 | 3 | 45.69 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 31 |  | 00786162650122 | [NAME] Vitamin XXX 12/591 Ml |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 15.23 | 2 | 30.46 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY
 |  |  | 32 |  | 00786162650269 | Glaceau Defense 12/591 Ml |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 15.23 | 3 | 45.69 |  |  | COCA-COLA REFRESHMENTS CANADA COMPANY