Spreadsheet: 192970d1352662084-data-validation-list-that-can-be-updated-both-way-price-book12
Sheet: Data

 |  |  |  |  |  |  |  |  | X = Completed Range | Yellow = Bread | Categorys | Store | Type | Weight
Bakery | Brands |  |  |  |  |  |  |  |  | Orange = Bakery | Bakery | Carrefour | bag | Gram
Baking.Powder | [NAME] | fosters |  |  |  |  |  |  | x |  | Beverages | ADH Co op | bottle | [NAME]
Baking.Soda |  |  |  |  |  |  |  |  | x |  | Breakfast | [NAME] | can | Oz
Bread | [NAME] | Modern Bakery | [NAME] | [NAME] | [NAME] | [NAME] |  |  | x |  | Canned_Goods | EMKE | pack | ml
Burger.Buns | Modern bakery | [NAME] |  |  |  |  |  |  | x |  | Cleaning_Supplies | Adil | piece
Cake | La Briouche | [NAME] | [NAME] | Mr baker | ceasers |  |  |  | x |  | Condiments | Spinneys | 6 Tray
Croissant | issant | Carrefour | [NAME] | [NAME] | modern |  |  |  | x |  | Dairy | [NAME] | 12 Tray
Food Coloring | Madras | Naveen |  |  |  |  |  |  | x |  | Ethnic_Food |  | 30 Tray
Hot.Dog.Buns | [NAME] | [NAME] | [NAME] | Modern |  |  |  |  | x |  | Fresh_Produce
Pastries | ceaser | [NAME] | [NAME] | La Briouche | carrefour |  |  |  | x |  | Frozen
Quiche | ceasre | [NAME] | Spinneys |  |  |  |  |  | x |  | Kitchen_supplies
Flavoring.essence | peacock | MDH | LND |  |  |  |  |  | x |  | Meat
Yeast | fosters | mr cook |  |  |  |  |  |  | x |  | Nuts
Custurd | Fosters | [NAME] | [NAME] |  |  |  |  |  | x |  | Packaged_Dry_Goods
Jelly | Jelly o | [NAME] | Fosters |  |  |  |  |  | x |  | Snacks
Choco.Chips | Lindt | cadbury | No 1 | heinz |  |  |  |  | x |  | Spices
Muffins | americana |  |  |  |  |  |  |  | x |  | Toiletries
Swiss.Rolls | americana |  |  |  |  |  |  |  | x
Beverages
Cola | [NAME] | Glucose | Rasna | Rooh Afza |  |  |  |  | <<< Start here | Select all the yellow and name the Range Powder_Juice
Energy | Pepsi | Coca Cola | 7 up |  |  |  |  |  |  | I added the underscore for you. But remember to replace any
Juice | Lacnor |  |  |  |  |  |  |  |  | spaces with an Underscore.
Powder.Juice | Lacnor | SunFeast | Ceres | [NAME] | [NAME] | [NAME]
Soup.Mix | Maggi | Cup a soup | Knorr | [NAME] | [NAME]
Breakfast
Coffee | [NAME] | Sultan | alpine | NO 1
Corn.Flakes | [NAME] | Sultan | alpine | NO 1
Fruit.Loops | [NAME] | Sultan | alpine | NO 1
Granola.Bars | [NAME] | Sultan | alpine | NO 1
Hot.Choclate | Captain | White Flower
Milk.Mix | Red Label | Soceity | Taj Mahal
Milk.Powder | Nescaffe | Ikea | Davidooff
Museli | Nido | pediasure
Oats | Horlicks | Bourvita | [NAME] | Oval | complan
Tea | Heinz | Cadbury | Hershey
Canned Goods
Cooking.Oil | century | [NAME] | MKP | [NAME]
Corned.Beef | americana | Mexican | century
Fish.Sauce | [NAME] | Nanak | Indana | Milk food | GKV
Fruits | Maggi | Heinz | Thai Chili | Sondos
[NAME].Paste | Kraft | Leisure | Knorr
Ghee | Mama sita | Sibling | ching Ming | sazuku
Ginger.Paste | Mama sita | Sibling | ching Ming | sazuku
[NAME] | Hunts | Delmonte | [NAME] | Saada | Ragu
Mayonaise | Hunts | Delmonte | [NAME] | Saada | Ragu
Mushrooms | [NAME]
Musturd.Oil | Figaro | Palestinian | Seja
Oyster.sauce | Mama sita | Sibling | ching Ming | sazuku
Pasta.Sauce | americana | [NAME]
Pizza.sauce | Delmonte | [NAME] | P & G
Salad.Dressing | P & G | [NAME]
Sesame.Oil | [NAME] | [NAME] | Lacnor | Dabur
Soy.Sauce | Shan | KDM | Priya
Tomato.paste | Shan | KDM | Priya
Tuna | Seja | Kachi ghani
Worchester.sauce | KDR
Vinegar
Cleaning Supplies
Bleach | Omo | [NAME] | Surf | [NAME]
Brushes | Lux | Fairy | [NAME]
Detergent | Downy | Freshca
Dish.Washing | Dish | [NAME]
Disinfectant | Mr [NAME] | 509 | normal
Fabric.softner | Mr [NAME] | 509
General.Purpose.[NAME] | 123 | Xyz
[NAME].[NAME] | Domex | Clorox | [NAME]
Gloves | general
Mops | general
Naptha.Balls | general
Sponges | Veola
Condiments
Jam | [NAME] | Tamilnadu
Lemon.Juice | Mothers recepie | shan
Musturd | General
Papad | Kissan | Hero
Peanut.Butter | Americana
Pickle | americana
Relish | English
Dairy
Butter | [NAME] | [NAME] | Al rawabi | Milco
Cheese.Feta | [NAME] | [NAME] | Al rawabi | Milco
Cheese .others | [NAME] | [NAME] | Al rawabi | Milco | Greek
Cheese.Cheddar | Kraft | Anchor | [NAME]
Cheese.Gouda | 3 cows | Puck | [NAME] | [NAME]
Cheese.Mont [NAME] | Puck | [NAME]
Cheese.Mozzrella
Cheese.spread | american
Eggs
Flavored.Milk | [NAME] | [NAME] | Al rawabi | Milco | Activia
Fresh.Cream
Laban | [NAME] | [NAME]
Laban.Flavored | Philadelphia | Puck
Milk | [NAME] | [NAME] | [NAME] | Milco
Paneer | Paneer | Oman | Saudi | Super Six
Puddings | [NAME] | Lurpak | Sunflower | Anchor
Sour.Cream | [NAME] | Milco | [NAME] | Danone
Yoghurt.Flavored | [NAME] | Milco | [NAME]
Yoghurt.Plain | Danoone | [NAME] | Yakut
Ethnic Food
Gucamole | [NAME]
Instant.Noodles | [NAME]
Pasta.Assorted | Indo mie | Maggi | [NAME]
Ready.Meals | Italiano
Salsa
Fresh Produce
artichoke
aspargus
avocado
bell pepper-green
bell pepper-red
broccoli-crowns
broccoli-whole
cabbage
carrots
cauliflower
celery
corn
cucumber
garlic
green beans
green chili
green onions
lettuce- red leaf
lettuce-butter
lettuce-iceburg
lettuce-romaine
mushrooms
[NAME]
onions
peaches
pepper-jalapeno
potato
radish
red onions
scallions
snow peas
spaghetti squash
spinach
sprouts
squash
[NAME] dried tomatoes
tomato-hothouse
tomato-large
tomato-roma
tomato-vine ripened
yams
yellow squash
zucchini
Frozen
Chapati | [NAME] | Swatties | [NAME] | XYZ
Corn | [NAME] | Swatties | [NAME] | XYZ
[NAME].Chicken.Burger | [NAME] | Swatties | [NAME] | XYZ
French.Fries | Doux | [NAME] | [NAME] | Saadia | Rose
Mix.Vegetables | Doux | [NAME] | [NAME] | Saadia | Rose
Nuggets | Doux | [NAME] | [NAME] | Saadia | Rose
Parotta | Doux | [NAME] | [NAME] | Saadia | Rose
Pastry.Sheets | Mc Cain | schmuger | ABCD
Peas | Ashoka | anumma | AnnaPurna
Sausages.Beef | [NAME] | Jennan | Ashoka | Annapurna
Sausages.Chicken
Shrimps | American Garden | Sadia | Doux | [NAME]
White.Fish | American Garden | Sadia | Doux | [NAME]
Kitchen supplies
Aluminium.Foil | Masafi | Kleenex | Softie | cool cool
Baking.Sheet | Masafi | Kleenex | Softie | cool cool
Cling.Film | Diamond | eagle | [NAME]
Paper.Towel | Diamond | eagle | [NAME]
Sandwhich.Wrapper | Diamond | eagle | [NAME]
Tissues | Diamond | eagle | [NAME]
Toilet.Paper | Masafi | Kleenex | Softie | cool cool
Trash.Bags | Diamond | eagle | [NAME]
wet.wipes | Masafi | Kleenex | Softie | cool cool
Meat
chicken.breast.bone.in | [NAME] | [NAME] | Saudia
Chicken.Mortedella | [NAME] | [NAME] | Saudia
[NAME] | [NAME] | [NAME] | Saudia
chicken.boneless.breast | [NAME] | [NAME] | Saudia
chicken.whole | [NAME] | [NAME] | Saudia
Drumsticks | [NAME] | [NAME] | Saudia
Indian.Beef.Cube | [NAME] | [NAME] | Saudia
Indian.[NAME]
Indian.Veal
Leg.Quarters
Mutton.Mince | Mutton.Mince
Pork.Ham
Thighs
Turkey.Thigh.[NAME]
Wings
Nuts
[NAME] | [NAME]
Cashew.Nuts | [NAME]
Dhydrated.Fruits | [NAME]
Peanuts | [NAME]
Pine.Nuts | [NAME]
Pista | [NAME]
Raisins | [NAME]
walnuts | [NAME]
Packaged_Dry_Goods
Atta | Pills Bury | Jennan | [NAME] | Abu dhabi Mills
[NAME] | Kohinoor | [NAME] | [NAME] | India Gate
Corn.[NAME]
Chole | Red Horse | [NAME] | [NAME]
Dry.Peas | Red Horse | [NAME] | [NAME]
Kaale.Chane | Red Horse | [NAME] | [NAME]
Kaali.Malka.Sabut | Red Horse | [NAME] | [NAME]
[NAME].Malka | [NAME] | No 1 | Jenan | Peacock
Maida | [NAME] | No 1 | Jenan | Peacock
Moong.split | [NAME] | No 1 | Jenan | Peacock
Moong.Dhuli | [NAME] | No 1 | Jenan | Peacock
Moong.Sabut | [NAME] | No 1 | Jenan | Peacock
Moth | [NAME] | No 1 | Jenan | Peacock
Raagi | [NAME] | No 1 | Jenan | Peacock
Rajma | [NAME] | No 1 | Jenan | Peacock
[NAME] | [NAME] | No 1 | Jenan | Peacock
Soya.Bean | [NAME] | No 1 | Jenan | Peacock
Soya.wadi | [NAME] | No 1 | Jenan | Peacock
Suji | [NAME] | No 1 | Jenan | Peacock
Toor.Chikni | [NAME] | No 1 | Jenan | Peacock
Urad.Split | [NAME] | No 1 | Jenan | Peacock
Urad.Dhuli | [NAME] | No 1 | Jenan | Peacock
Urad.Sabut | [NAME] | No 1 | Jenan | Peacock
white.Bean | [NAME] | No 1 | Jenan | Peacock
Snacks
Bhujia | Tiffany | Britania | Nutro | Parle | Mc Vities | Panda | Butter cookies
Biscuits.Cream | Tiffany | Britania | Nutro | Parle | Mc Vities | Panda | Butter cookies
Biscuits-.Salty | Haldi Ram | Bikano | Open
Bounty | Haldi Ram | Bikano | Open
Candies | Haldi Ram | Bikano | Open
Chips
Dal
Kinder
Mars
Mixture
Popcorn
Snickers
Spices
Balck.Cardomon | Nezo | Tata | [NAME]
Black.Pepper | Sis | [NAME]
Black.pepper.powder | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
Cardomon | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
Corriander | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
Garam.Masala | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
[NAME].Salt | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
Javitri | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
Kosher.Salt | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
[NAME] | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
Oregano | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
Prepared.Masala | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
Prepared.Masala | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
Prepared.Masala | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
Prepared.Masala | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
Prepared.Masala | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
Prepared.Masala | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
Prepared.Masala | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
Prepared.Masala | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
Red.Chillies | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
Salt | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
Sugar | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
Tej.Patta | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
Thyme | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
[NAME] | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
White.Pepper | [NAME] | [NAME] | Eastern | Madras | Shan | [NAME]
Toiletries
Bath.Salts | Lux | Camay | Honey | Olive branch
Bath.Soap | Nivea | [NAME] | Life Boy
Chap.Sticks | Dabur | Pantene | Pert
Conditioner | Loreal | Pantene | Pert | Head & Shoulder | Dabur
Cotton.[NAME] | Cotton.[NAME]
Deodrant | Super Max | Gillete
Floss | Oil Of Olay | Nivea | Jhonson & Jhonnson
Hair.Color | Hair.Color | Glycol | Jhonson & Jhonnson
Hair.Creams | Loreal | [NAME] | Bigen
hair.Oil
Hand.Wash | Close Up | Crest | Pepsodent | Sensodyne | colgate
Moisteriser | Oral B | Jordan | colgate
Mouth.Wash | Jordan | Oral B
Razor | Plax | Listrine | colgate
Shampoo | Axe | Dove | Fa
Shaving.Foam | lip
Shower.gel
Thooth.Brush | [NAME] | Life Boy
Thooth.Paste | Emami | Parachute | Dabur | Hair & Care
Vaselin | Parachute | Palmer | Brylcream