Spreadsheet: 266980d1379887899-vlookup-for-finding-value-that-may-only-appear-on-one-of-seven-worksheets-supplier-pricing-sept-2013-jacc
Sheet: Pepsi 14720

 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year:
 |  |  |  |  |  |  |  | 14720
 |  |  |  | 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 |  | 102067 | Aquafina Plus Pomegranate Cherry 12/591 Ml |  |  |  |  |  |  |  |  | AQUAFINA |  |  |  |  |  |  | 18.89 | 2 | 37.78 |  |  | PEPSI-COLA CANADA
 |  |  | 2 |  | 105266 | 591ML PL AQ PLS STW KW 1/12 |  |  |  |  |  |  |  |  | PEPSI |  | 1 |  | EA |  |  | 18.89 | 3 | 56.67 |  |  | PEPSI-COLA CANADA
 |  |  | 3 |  | 106654 | Gatorade G2 Fruit Punch 12/591 Ml |  |  |  |  |  |  |  |  | GATORADE |  |  |  |  |  |  | 14.89 | 2 | 29.78 |  |  | PEPSI-COLA CANADA
 |  |  | 4 |  | 109732 | 591ML PL GAT G2 GRP 1/12 |  |  |  |  |  |  |  |  | PEPSI |  | 1 |  | EA |  |  | 14.89 | 1 | 14.89 |  |  | PEPSI-COLA CANADA
 |  |  | 5 |  | 109951 | Lipton Brisk Lemonade [NAME] |  |  |  |  |  |  |  |  | LIPTON |  |  |  |  |  |  | 20.62 | 1 | 20.62 |  |  | PEPSI-COLA CANADA
 |  |  | 6 |  | 120980 | 473ML CN RKSTR ENRG 1/12 |  |  |  |  |  |  |  |  | PEPSI |  | 1 |  | EA |  |  | 25.6 | 2 | 51.2 |  |  | PEPSI-COLA CANADA
 |  |  | 7 |  | 120982 | 473ML CN RKSTR SF 1/12 |  |  |  |  |  |  |  |  | PEPSI |  | 1 |  | EA |  |  | 25.6 | 1 | 25.6 |  |  | PEPSI-COLA CANADA
 |  |  | 8 |  | 121951 | Aquafina Plus Blueberry 12/591 Ml 121951 |  |  |  |  |  |  |  |  | AQUAFINA |  |  |  |  |  |  | 18.89 | 3 | 56.67 |  |  | PEPSI-COLA CANADA
 |  |  | 9 |  | 125200 | Aquafina Fuji Apple Pear Low Calorie 12/591 Ml |  |  |  |  |  |  |  |  | AQUAFINA |  |  |  |  |  |  | 18.89 | 3 | 56.67 |  |  | PEPSI-COLA CANADA
 |  |  | 10 |  | 125202 | 591ML PL AQ PL YMBR PM LC 1/12 |  |  |  |  |  |  |  |  | PEPSI |  | 1 |  | EA |  |  | 18.89 | 3 | 56.67 |  |  | PEPSI-COLA CANADA
 |  |  | 11 |  | 127731 | 591ML PL AQ PL STW LMND LC 1/1 |  |  |  |  |  |  |  |  | PEPSI |  | 1 |  | EA |  |  | 18.89 | 3 | 56.67 |  |  | PEPSI-COLA CANADA
 |  |  | 12 |  | 129032 | Dr Pepper [NAME] |  |  |  |  |  |  |  |  | DR. PEPPER |  |  |  |  |  |  | 20.83 | 2 | 41.66 |  |  | PEPSI-COLA CANADA
 |  |  | 13 |  | 133511 | [NAME] 1/24 |  |  |  |  |  |  |  |  | PEPSI |  | 1 |  | EA |  |  | 20.83 | 3 | 62.49 |  |  | PEPSI-COLA CANADA
 |  |  | 14 |  | 137430 | Starbucks Refresher Energy Drink Orange Melon 12/355 Ml 00069000147207 |  |  |  |  |  |  |  |  | STARBUCKS |  |  |  |  |  |  | 24.48 | 2 | 48.96 |  |  | PEPSI-COLA CANADA
 |  |  | 15 |  | 137444 | Starbucks Refresher Energy Drink Raspberry Pomegrante 12/355 Ml |  |  |  |  |  |  |  |  | STARBUCKS |  |  |  |  |  |  | 24.48 | 2 | 48.96 |  |  | PEPSI-COLA CANADA
 |  |  | 16 |  | 137531 | Starbucks Refresher Energy Drink Strawberry Lemonade 12/355 Ml 00069000147221 |  |  |  |  |  |  |  |  | STARBUCKS |  |  |  |  |  |  | 24.48 | 2 | 48.96 |  |  | PEPSI-COLA CANADA
 |  |  | 17 |  | 137851 | [NAME] 12/405 Ml 00069000147702 |  |  |  |  |  |  |  |  | Frappuccino |  |  |  |  |  |  | 22.01 | 2 | 44.02 |  |  | PEPSI-COLA CANADA
 |  |  | 18 |  | 137852 | Vanilla Frappuccino [NAME] |  |  |  |  |  |  |  |  | Frappuccino |  |  |  |  |  |  | 22.01 | 2 | 44.02 |  |  | PEPSI-COLA CANADA
 |  |  | 19 |  | 64263 | 355ML CN PEPSI 1/24 |  |  |  |  |  |  |  |  | PEPSI |  | 1 |  | EA |  |  | 10.29 | 21 | 216.09 |  |  | PEPSI-COLA CANADA
 |  |  | 20 |  | 64264 | Pepsi Diet 00690000142901 24/355 Ml |  |  |  |  |  |  |  |  | PEPSI |  |  |  |  |  |  | 10.29 | 19 | 195.51 |  |  | PEPSI-COLA CANADA
 |  |  | 21 |  | 64277 | Ginger Ale 24/355 Ml 642771000166005110010001660019002 |  |  |  |  |  |  |  |  | SCHWEPPES |  |  |  |  |  |  | 10.29 | 8 | 82.32 |  |  | PEPSI-COLA CANADA
 |  |  | 22 |  | 64320 | Ginger Ale Diet 12/355 Ml |  |  |  |  |  |  |  |  | SCHWEPPES |  |  |  |  |  |  | 5.25 | 6 | 31.5 |  |  | PEPSI-COLA CANADA
 |  |  | 23 |  | 64489 | Aquafina Water W/ Shell 24/591 Ml |  |  |  |  |  |  |  |  | AQUAFINA |  |  |  |  |  |  | 10.2 | 61 | 622.2 |  |  | PEPSI-COLA CANADA
 |  |  | 24 |  | 84998 | Aquafina 24/500 Ml |  |  |  |  |  |  |  |  | AQUAFINA |  |  |  |  |  |  | 7.65 | 11 | 84.15 |  |  | PEPSI-COLA CANADA
 |  |  | 25 |  | 86326 | 591ML PL GAT BLU 1/12 |  |  |  |  |  |  |  |  | PEPSI |  | 1 |  | EA |  |  | 14.89 | 2 | 29.78 |  |  | PEPSI-COLA CANADA
 |  |  | 26 |  | 86331 | 591ML PL GAT ORG 1/12 |  |  |  |  |  |  |  |  | PEPSI |  | 1 |  | EA |  |  | 14.89 | 2 | 29.78 |  |  | PEPSI-COLA CANADA
 |  |  | 27 |  | 89629 | 591ML PL PEPSI 1/24 |  |  |  |  |  |  |  |  | PEPSI |  | 1 |  | EA |  |  | 20.83 | 8 | 166.64 |  |  | PEPSI-COLA CANADA
 |  |  | 28 |  | 92386 | 591ML PL DT PEPSI 1/24 |  |  |  |  |  |  |  |  | PEPSI |  | 1 |  | EA |  |  | 20.83 | 8 | 166.64 |  |  | PEPSI-COLA CANADA
 |  |  | 29 |  | 92407 | 591ML PL 7UP CDN 1/24 |  |  |  |  |  |  |  |  | PEPSI |  | 1 |  | EA |  |  | 20.83 | 1 | 20.83 |  |  | PEPSI-COLA CANADA
 |  |  | 30 |  | 92408 | 591ML PL DT 7UP CDN 1/24 |  |  |  |  |  |  |  |  | PEPSI |  | 1 |  | EA |  |  | 20.83 | 2 | 41.66 |  |  | PEPSI-COLA CANADA
 |  |  | 31 |  | 92410 | [NAME] 86809 24/591 Ml |  |  |  |  |  |  |  |  | MUG |  |  |  |  |  |  | 20.83 | 2 | 41.66 |  |  | PEPSI-COLA CANADA
 |  |  | 32 |  | 92412 | Dr Pepper 86789 & 92412 10005490000215 24/591 Ml |  |  |  |  |  |  |  |  | DR. PEPPER |  |  |  |  |  |  | 20.83 | 2 | 41.66 |  |  | PEPSI-COLA CANADA
 |  |  | 33 |  | 92414 | Ginger Ale 92414 92403 & 86806 10001660001099 24/591 Ml |  |  |  |  |  |  |  |  | SCHWEPPES |  |  |  |  |  |  | 20.83 | 1 | 20.83 |  |  | PEPSI-COLA CANADA
 |  |  | 34 |  | 92418 | Crush Cream Soda 24/591 Ml 86819 86832 |  |  |  |  |  |  |  |  | CRUSH |  |  |  |  |  |  | 20.83 | 2 | 41.66 |  |  | PEPSI-COLA CANADA
 |  |  | 35 |  | 92683 | Crush Grape 24/591 Ml 86787 |  |  |  |  |  |  |  |  | CRUSH |  |  |  |  |  |  | 20.83 | 2 | 41.66 |  |  | PEPSI-COLA CANADA
 |  |  | 36 |  | 92700 | Dr Pepper Diet 92684 & 92700 24/591 Ml |  |  |  |  |  |  |  |  | DR. PEPPER |  |  |  |  |  |  | 20.83 | 3 | 62.49 |  |  | PEPSI-COLA CANADA
 |  |  | 37 |  | 96793 | 591ML PL LIT GT CIT 1/24 |  |  |  |  |  |  |  |  | PEPSI |  | 1 |  | EA |  |  | 21.14 | 1 | 21.14 |  |  | PEPSI-COLA CANADA