Spreadsheet: 38334d1236456543-search-faciltity-and-h-vlookup-sampleworkbook
Sheet: Production

 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
Part Code | Description | Allergens | Warehouse | Area | Peanut | Nut | Milk | Eggs | Fish | Shellfish | Wheat | Soya | Sesame | Gluten | Rye | Barley | Malt | Oats | Maize | Celery | Mustard | [NAME] | HVP | Lupin | Sulphite >10mg/kg | Phenylalanine | Recipe
50000 | Apple |  | AB   02 | Fruit
50001
50003
50004
50006
50015 | [NAME]
50016
50016
50019 | Onion |  | AB   04 | Veg
50021 | Carrot
50023
50204 | Peas
50302 |  | [NAME] |  |  | n | n | n | n | n | n | [NAME] | n | n | n | n | n | n | n | [NAME] | n | n | n | n | n | n | n | ABC 123
50303 | Celery | [NAME] |  |  | n | n | n | n | n | n | [NAME] | n | n | n | n | n | n | n | [NAME] | n | n | n | n | n | n | n
50304
50307 | Fish | [NAME] | AB   05 | Meat | n | n | n | n | n | n | [NAME] | n | n | n | n | n | n | n | [NAME] | n | n | n | n | n | n | n
51001
51002
51003
51003
51017
51021
51021
51100
51105
51105
51113
51134
51129
51139 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | Waxy Corn Starch | n | n | n | n | n | n | n
51140 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | Novation 2700 | n | n | n | n | n | n | n
51152 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | Waxy Corn Starch | n | n | n | n | n | n | n
51512 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ABC123
51513 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | Dextrose | n | n | n | n | n | n | n | CBA123
51514 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BCA123
51641 |  |  |  |  | n | n | n | n | n | n | Wheat flour, Rusk | n | n | Wheat flour, Rusk | n | n | n | n | Dextrose IP maize | n | n | n | n | n | n | n
51643 |  |  |  |  | n | n | n | n | n | n | Wheat flour, wheat starch, wheat protein, [NAME] | n | n | Wheat flour, wheat starch, wheat protein, [NAME] | n | n | n | n | Dextrose IP maize | n | n | n | n | n | n | n | ABC124
51653 |  |  |  |  | n | n | Skimmed Milk Powder | Whole egg, Egg albumen, Egg in flavouring | n | n | Wheat [NAME], [NAME] | n | n | Wheat [NAME], [NAME] | n | n | n | n | n | n | n | n | n | n | n | n
51658 |  |  |  |  | n | n | n | n | n | n | Wheat [NAME] in [NAME] | n | n | Wheat [NAME] in [NAME] | n | n | n | n | n | n | n | n | n | n | Greater than 10mg/kg | n | ABC124
51659 |  |  |  |  | n | n | n | n | n | n | Wheat [NAME] in [NAME] | n | n | Wheat [NAME] in [NAME] | n | n | n | n | n | n | n | n | n | n | n | n | CBA124
51661 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | Dextrose and maltodextrin from maize | In Spices | n | n | n | n | n | n
51662
51662
51663 |  |  |  |  | n | n | n | n | n | n | wheat flour in Rusk | n | n | wheat flour in Rusk | n | n | n | n | n | n | n | n | n | n | 2.67 mg/kg Carry over | n
51673
51811 |  |  |  |  | n | n | n | n | Pollock | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | ABC123
52000
52001
52002
52005
52006
52007
52009
52012
52012
52013
52013
52014
52015
52017
52026 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n |  | n | n | n | n | n | n | ABC123 | BCA123 | CBA123 | ABC124 | [NAME] | ABD123 | ABD125
52027
52031 |  |  |  |  | n | n | n | n | n | n | seasoning | n | n | seasoning | n | n | n | n | seasoning | n | n | seasoning | n | n | n | n
52039
52040
52042
52044 |  |  |  |  | n | n | n | n | n | n | Dextrose | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | ABB234 | ABB345 | ABC123 | BCA123 | CBA123 | ABC124 | [NAME] | ABD123 | ABD125
52045
52046
52049
52054 |  |  |  |  | n | n | n | n | n | n | Wheatflour | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | ABB345
52056 |  |  |  |  | n | n | n | n | n | n | Wheatflour | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
52057 |  |  |  |  | n | n | n | n | n | n | Wheatflour | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
52062
52063
52067
52068
52071
52073
52077
52089
52108
52112 |  |  |  |  | n | n | n | n | n | n | Wheatflour | n | n | Wheatflour | n | n | n | n | n | n | n | n | n | n | n | n
52115 |  |  |  |  | n | n | n | n | n | n | Wheatflour | n | n | Wheatflour | n | n | n | n | n | n | n | n | n | n | n | n
52116 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | [NAME] dioxide added max 50 ppm | n
52117
52123 |  |  |  |  | n | n | n | n | n | n | Presence of dextrose derived from wheat starch | n | n | Presence of dextrose derived from wheat starch | n | n | n | n | n | n | n | n | n | n | n | n
52128 |  |  |  |  | n | n | Skimmed Milk Powder, [NAME] | n | n | n | n | [NAME] | n | n | n | n | n | n | n | n | n | n | n | n | n | n
52138 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | Presence in the potato flakes but < 10 ppm on endproduct | n
52166
52167
52168
52196 |  |  |  |  | n | n | n | n | n | n | Wheat [NAME] in batter coating | n | n | Wheat [NAME] in batter coating | n | n | n | n | n | n | n | [NAME] powder in batter | n | n | n | n
53000
53004
53005
53007 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | SODIUM  METABISULPHATE | n
53017
53018
53023 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n |  | n | n | n | n | ABC123 | BCA123 | CBA123 | ABC124 | [NAME] | ABD123 | ABD125
53024 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | SODIUM METABISULPHITE E223 | n
53028
53029
53030
53040 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | Celery | n | n | n | n | n | n
54000 |  |  |  |  | n | n | n | n | n | n |  | n | n |  | Trace | n | n | n | n | n | n | n | n | n | n | n | ABB234 | ABB345 | ABC123 | BCA123 | CBA123 | ABC124 | [NAME] | ABD123 | ABD125 | CHT605 | CHT607 | CWS944 | CWS945 | CWS947 | ICE901 | ICE906 | ICE912 | ICE913 | JSy769 | MOR808 | MOR809 | MOR812 | MOR813 | MOR814 | MOR815 | MOR817 | MOR818 | MOR819 | MOR820 | MOR823 | MOR828 | [NAME] | MOR917 | TSC931 | TSC932 | TSC933 | TSC934 | TSC935 | TSC936 | [NAME] | TSC940 | TSC941 | TSC942 | TSC944 | TSC945 | TSC947 | TSC948 | TSC950 | TSC951 | TSC953 | TSC954 | TSC955 | TSC956 | TSC957 | TSC958 | TSC960 | UNI802 | UNi805 | UNI809 | [NAME] | UNI814 | UNI815 | UNI817 | UNI818
54001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ABC123 | ABC124 | ABC125 | BCA123 | CBA123 | BBA111 | BBA112
54002 |  |  |  |  | n | n | Component | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
54006
54007
54009
54011 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | SULPHUR DIOXIDE | n
54016 |  |  |  |  | n | n | n | n | n | n | Wheatflour | n | n | Wheatflour | n | n | n | n | n | n | n | n | n | n | n | n
54017
54023
54024
54025 |  |  |  |  | n | n |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
54026 |  |  |  |  | n | n | n | n | n | n |  | n | n |  | n | n | n | n | n | n | n | n | n | n | n | n
54030 |  |  |  |  | n | n | n | n | n | n | Wheatflour | n | n | Wheatflour | n | n | n | n | May be in flour improver | n | n | n | n | n | n | n
54036 |  |  |  |  | n | n | Milk | Lizozyme | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
54039
54051 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | Modified Starch | n | n | n | n | n | n | n
54053 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | <50ppm | n
54055
54056 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n |  | n | n | n | n | n | <10ppm SO2  E220 | n
54064 |  |  |  |  | n | n | n | n | n | n | GLUCOSE SYRUP + MALTODEXTRIN | n | n |  | n | n | n | n | n | n | n | n | n | n | <20ppm | n
54070 |  |  |  |  | n | n | Component | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
54073 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | Maize Starch | n | n | n | n | n | [NAME] | n
54083 |  |  |  |  | n | n | n | Free Range Egg White | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
55001 |  |  |  |  | n | n |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
55002 |  |  |  |  | n | n |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
55004 |  |  |  |  | n | n | Dairy Product | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
55005 |  |  |  |  | n | n |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
55009 |  |  |  |  | n | n | FLAVOURINGS | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
55012 |  |  |  |  | n | n | Milk | n | n | n | n | n | n | n | n | n | n | n | Maize Starch | n | n | n | n | n | n | n
55013 |  |  |  |  | n | n |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
55016
55023 |  |  |  |  | n | n | Milk | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
55024
55026 |  |  |  |  | n | n | Milk | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
55029 |  |  |  |  | n | n | Milk | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
55031 |  |  |  |  | n | n |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
55036 |  |  |  |  | n | n | Milk | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
55043 |  |  |  |  | n | n | Milk | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
55048 |  |  |  |  | n | n | Milk |  | n | n | n | n | n | n | n | n | n | n | [NAME] is produced from Maize | n | n | n | n | n | n | n
55050 |  |  |  |  | n | n |  | Lysozyme E1105 | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
55051 |  |  |  |  | n | n |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
55053 |  |  |  |  | n | n |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
55063 |  |  |  |  | n | n |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
55069
56004 |  |  |  |  | n | n | n | n | n | n | n | n | n | From [NAME] <1250 PPM | n | From Malt Vinegar | n | n | n | n | n | [NAME] | n | n | n | n
56011 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | Mustard Seeds | n | n | n | n | n
56022 |  |  |  |  | n | n | n | n | n | n | n | n | n | WHEAT FLOUR IN SPICES | WHEAT FLOUR IN SPICES | WHEAT FLOUR IN SPICES | n | WHEAT FLOUR IN SPICES | n | n | n | PRESENT IN SPICE BLEND | n | n | n | n
56028 |  |  |  |  | n | n | SKIMMED MILK POWDER, CREAM POWDER | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
56030 |  |  |  |  | n | n | n | n | n | n | DEXTROSE, RUSK & WHEATFLOUR | n | n | RUSK & WHEATFLOUR | n | n | n | n | n | n | n | n | n | n | n | n
56031 |  |  |  |  | n | n | n | n | n | n | DEXTROSE | n | n | n | n | n | n | n | n | n | n | GARLIC EXTRACT | n | n | n | n
56032 |  |  |  |  | n | n | n | n | n | n | Maltodextrin | n | n | Maltodextrin | n | Malt extract, yeast extract | n | n | n | n | n | GARLIC EXTRACT | n | n | n | n
56033
56034
56040 |  |  |  |  | n | n | n | n | n | n | Wheat, [NAME] | n | n | Dextrose, [NAME] | n | n | n | n | n | n | n | n | n | n | n | n
56042 |  |  |  |  | n | n | n | n | n | n | Maltodextrin | n | n | [NAME] 110ppm by calculation | n | n | n | n | n | n | n | n | n | n | n | n
56055 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | Celery | n | n | n | n | n | n
56056 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | < 10ppm | n
56059 |  |  |  |  | n | n | Lactose | n | n | n | n | n | n | n | n | n | n | n | n | Celery, Celery Extract | n | n | n | n | n | n
56065 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
56067 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | <70 ppm | n
56069 |  |  |  |  | n | n | n | n | n | n | n | n | n |  | n |  | n | n | n | n | n | n | n | n | n | n
56070
56071 |  |  |  |  | n | n | n | n | n | n | Some wheat may be used in conjunction with barley as a raw ingredient | n | n | Barley/wheat used as raw materials in manufacture. Traces of gluten may be present (not suitable for coeliacs) | n | Malted barley used as raw ingredient | n | n | n | n | n | n | n | n | <5 ppm [NAME] (naturally occurring) | n
56074
56075
56080 |  |  |  |  | n | n | n | n | n | n | As maltodextrin | n | n | 0.001 | n | n | n | n | n | n | n | n | n | n | n | n
56086
56088
56090 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | E223 Sodium Metabisulphite present <100 ppm. | n
56098 |  |  |  |  | n | n | n | n | n | n |  | n | n | n | n | n | n | n | n | n | n |  | n | n | n | n
56114
56121 |  |  |  |  | n | n | n | n | n | n | Wheat | Soya | n | Wheat | n | n | n | n | n | n | n | n | n | n | n | n
56129 |  |  |  |  | n | n | n | n | n | n | [NAME] | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
56131 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | [NAME] | n | n | n | n
56135 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | SO2 <200 ppm | n
56138
56144 |  |  |  |  | n | n | n | n | n | n | Wheat flour | n | n | Wheat flour | n | n | n | n | n | n | [NAME] | n | n | n | n | n
56147 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n |  | n |  | n | n | E220 in Potato Starch <5ppm | n
56148
56149
56151
56152
56153
56154 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | Maize maltodextrin in flavouring | n | n | n | n | n | n | n
56155 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | Celery | n | [NAME] | n | n | n | n
56156 |  |  |  |  | n | n | n | n | Dried Cod | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | Present in the Potato Starch but <5ppm | n
56159 |  |  |  |  | n | n | n | n | n | n | n | n | n | [NAME] extract contains gluten, but level in the finished product is < 2 ppm | n | Roast Malt Extract is derived from Barley | n | n | n | n | n |  | n | n | <10 mg/Kg | n
56164 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | Malt Extract | n | n | n | n | n | n | n | n | n
56165 |  |  |  |  | n | n | Cheese Powder | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
56170 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | In Flavouring | Salt/ Seeds | n | n | n | n | n | n
56176
56188 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | <10ppm | n
56191 |  |  |  |  | n | n | n | n | n | n | Wheat | [NAME] | n | Wheat | n | n | n | n | n | n | n | n | n | n | n | n
56196
57000
57002
57006
57008
57009
57014
57017
57020
57021
57024
57025 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | Powder | Yes | n | n | 2.4ppm | n
57026
57029
57034
57035
57036
57037
57038
57039
57041
57042
57043 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | [NAME] | n | n | n | n
57044
57049
57050 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n |  | n | n | n | n | n
57051 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n |  | n | n | n | n
57052
57054
57055
57056
57058 |  |  |  |  | n | n | Cows milk | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
57072
57073 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | In Sun dried tomatoes @ 0.1% | n
57077
57083
57093
57100
57101
58005
58006
58012
58019
58020
58021
58022 |  |  |  |  | n | n | n | n |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
58028 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | Modified Maize Starch | n | n | Within Bean Seasoning | n | n | n | n
58029 |  |  |  |  | n | n | n | n |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
58034
58035 |  |  |  |  | n | n | n | n | Tuna /Oil | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n
59000 |  |  |  |  | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | n | [NAME] | n
59001
59004 |  |  |  |  | n | n | n | n | n | n | glucose syrup | n | n | glucose syrup | n | n | n | n | n | n | n | n | n | n | n | n
59013