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

 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year:
 |  |  |  |  |  |  |  | 364106
 |  |  |  | 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 |  | BB00001S | BLACKBERRY |  |  |  |  |  |  |  |  | IMPORT |  |  |  |  |  |  | 3.72 | 3 | 11.16 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 2 |  | BB00002S | BLUEBERRY |  |  |  |  |  |  |  |  | IMPORT |  |  |  |  |  |  | 4.16 | 5 | 20.8 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 3 |  | BB00007S | [NAME] |  |  |  |  |  |  |  |  | IMPORT |  |  |  |  |  |  | 3.94 | 9 | 35.46 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 4 |  | BB00016S | [NAME] |  |  |  |  |  |  |  |  | IMPORT |  |  |  |  |  |  | 4.75 | 4 | 19 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 5 |  | FF00031S | Lemons 140 count |  |  |  |  |  |  |  |  | IMPORT |  |  |  |  |  |  | 2.14 | 6 | 12.84 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 6 |  | FF00050S | Orange Navel 72 count |  |  |  |  |  |  |  |  | IMPORT |  |  |  |  |  |  | 3.74 | 14 | 52.36 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 7 |  | FF00058S | [NAME] Pear 100 count |  |  |  |  |  |  |  |  | IMPORT |  |  |  |  |  |  | 3.69 | 10 | 36.9 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 8 |  | FF00071S | Grape Green Seedless 11 - 3/16 |  |  |  |  |  |  |  |  | IMPORT |  |  |  |  |  |  | 5.26 | 10 | 52.6 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 9 |  | FF00072S | Grape Red Seedless 11 - 3/16 |  |  |  |  |  |  |  |  | IMPORT |  |  |  |  |  |  | 5.11 | 8 | 40.88 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 10 |  | FF00078S | Golden Delicious 100 count |  |  |  |  |  |  |  |  | USA |  |  |  |  |  |  | 3.9 | 9 | 35.1 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 11 |  | FF00081S | 100'S APPLES GRANNY SMITH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.4 | 10 | 44 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 12 |  | FF00088S | 100'S APPLES E.F. RED DEL. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.52 | 15 | 52.8 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 13 |  | FF00129S | 40LB BANANAS SEMI #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.04 | 29 | 117.16 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 14 |  | PF00002S | 12 LITRE FRUIT SALAD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48.4 | 3 | 145.2 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 15 |  | PV00018F | Shredded Lettuce |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 30.03 | 5 | 150.15 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 16 |  | PV00018S | Shredded Lettuce |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 8.94 | 15 | 134.1 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 17 |  | PV00022F | Separate Salad / Tossed Salad |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 31.12 | 4 | 124.48 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 18 |  | PV00022S | Separate Salad / Tossed Salad |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 9.29 | 11 | 102.19 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 19 |  | PV00028F | [NAME] |  |  |  |  |  |  |  |  | Local |  |  |  |  |  |  | 15.81 | 13 | 205.53 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 20 |  | PV00059F | Chop Romaine |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 35.92 | 2 | 71.84 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 21 |  | PV00059S | Chop Romaine |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 7.13 | 25 | 178.25 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 22 |  | PV00150S | [NAME] |  |  |  |  |  |  |  |  | Grimway |  |  |  |  |  |  | 1.76 | 44 | 77.44 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 23 |  | VE00018F | English Cucumbers |  |  |  |  |  |  |  |  | Ontario |  |  |  |  |  |  | 22.91 | 8 | 183.28 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 24 |  | VE00035S | 60'S PARSLEY CURLEY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 2 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 25 |  | VE00036S | 60'S PARSLEY ITALIAN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 26 |  | VE00103S | 48'S ONIONS GREEN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.61 | 12 | 7.32 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 27 |  | VE00107S | 50LB ONIONS SPANISH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.32 | 7 | 23.24 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 28 |  | VE00160F | Tomatoes 5 x 6 |  |  |  |  |  |  |  |  | USA |  |  |  |  |  |  | 42.71 | 15 | 640.65 |  |  | BAMFORD PRODUCE CO. LTD.
 |  |  | 29 |  | VE00183F | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 16.4 | 9 | 147.6 |  |  | BAMFORD PRODUCE CO. LTD.