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

 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year:
 |  |  |  |  |  |  |  | 41701
 |  |  |  | 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 |  | 00055872000016 | EMPTY CASE MILK |  |  |  |  |  |  |  |  | N/A |  | 1 |  | UN |  |  | 3 | -5 | -15 |  |  | NATREL INC.
 |  |  | 2 |  | 00055872220872 | 10LT 18%EIGHTEEN CR.NAT.F.S |  |  |  |  |  |  |  |  | NATREL |  |  |  |  |  |  | 31.5 | 69 | 2173.5 |  |  | NATREL INC.
 |  |  | 3 |  | 00055872220971 | 10L CREME 18% NFS WHITE TUBE |  |  |  |  |  |  |  |  | NATREL |  |  |  |  |  |  | 31.5 | 0 | 0 |  |  | NATREL INC.
 |  |  | 4 |  | 00064420000798 | 1LT 2% SEALTEST |  |  |  |  |  |  |  |  | SEALTEST |  |  |  |  |  |  | 1.62 | 623 | 1009.26 |  |  | NATREL INC.
 |  |  | 5 |  | 00064420006349 | 3.5L SOUR CREME 14% SEALTEST |  |  |  |  |  |  |  |  | SEALTEST |  |  |  |  |  |  | 14.9 | 4 | 59.6 |  |  | NATREL INC.
 |  |  | 6 |  | 00064420006707 | 500GR COTTAGE CHEESE 1% SEALT. |  |  |  |  |  |  |  |  | SEALTEST |  |  |  |  |  |  | 2.6 | 36 | 93.6 |  |  | NATREL INC.
 |  |  | 7 |  | 00064420100818 | 237ML MILK 2% SEALTEST |  |  |  |  |  |  |  |  | SEALTEST |  |  |  |  |  |  | 0.44 | 240 | 105.6 |  |  | NATREL INC.
 |  |  | 8 |  | 00064420100832 | 473ML MILK 2% SEALTEST |  |  |  |  |  |  |  |  | SEALTEST |  |  |  |  |  |  | 0.87 | 196 | 170.52 |  |  | NATREL INC.
 |  |  | 9 |  | 00064420101471 | 237ML SKIM MILK SEALTEST |  |  |  |  |  |  |  |  | SEALTEST |  |  |  |  |  |  | 0.44 | 144 | 63.36 |  |  | NATREL INC.
 |  |  | 10 |  | 00064420103185 | [NAME] STRAWBERRY MILK SEALTEST |  |  |  |  |  |  |  |  | SEALTEST |  |  |  |  |  |  | 0.88 | 140 | 123.2 |  |  | NATREL INC.
 |  |  | 11 |  | 00064420123077 | NATREL 160x9mL 2% BAG |  |  |  |  |  |  |  |  | NATREL |  |  |  |  |  |  | 4.61 | 13 | 59.93 |  |  | NATREL INC.
 |  |  | 12 |  | 00064420123275 | NATREL 160x9mL 18% BAG |  |  |  |  |  |  |  |  | NATREL |  |  |  |  |  |  | 6.55 | 16 | 104.8 |  |  | NATREL INC.
 |  |  | 13 |  | 00064420201713 | 473ML CHOCOLATE MILK SEALTEST |  |  |  |  |  |  |  |  | SEALTEST |  |  |  |  |  |  | 0.88 | 1092 | 960.96 |  |  | NATREL INC.
 |  |  | 14 |  | 00064420201775 | 237ML CHOCOLATE MILK SEALTEST |  |  |  |  |  |  |  |  | SEALTEST |  |  |  |  |  |  | 0.44 | 624 | 274.56 |  |  | NATREL INC.
 |  |  | 15 |  | 00629025410054 | ORIGINAL [NAME] |  |  |  |  |  |  |  |  | IOGO |  |  |  |  |  |  | 0.65 | 54 | 35.1 |  |  | NATREL INC.
 |  |  | 16 |  | 00629025410061 | ORIGINAL [NAME] |  |  |  |  |  |  |  |  | IOGO |  |  |  |  |  |  | 0.65 | 54 | 35.1 |  |  | NATREL INC.
 |  |  | 17 |  | 00629025410078 | ORIGINAL Peach |  |  |  |  |  |  |  |  | IOGO |  |  |  |  |  |  | 0.65 | 54 | 35.1 |  |  | NATREL INC.
 |  |  | 18 |  | 00629025410122 | ORIGINAL [NAME] |  |  |  |  |  |  |  |  | IOGO |  |  |  |  |  |  | 8.16 | 3 | 24.48 |  |  | NATREL INC.
 |  |  | 19 |  | 00629025410139 | ORIGINAL [NAME] |  |  |  |  |  |  |  |  | IOGO |  |  |  |  |  |  | 8.16 | 3 | 24.48 |  |  | NATREL INC.
 |  |  | 20 |  | 00629025420152 | 0% Strawberry |  |  |  |  |  |  |  |  | IOGO |  |  |  |  |  |  | 0.65 | 46 | 29.9 |  |  | NATREL INC.
 |  |  | 21 |  | 00629025420169 | 0% Raspberry |  |  |  |  |  |  |  |  | IOGO |  |  |  |  |  |  | 0.65 | 46 | 29.9 |  |  | NATREL INC.
 |  |  | 22 |  | 00629025420176 | 0% Blueberry |  |  |  |  |  |  |  |  | IOGO |  |  |  |  |  |  | 0.65 | 46 | 29.9 |  |  | NATREL INC.