How to make sure all item names have the correct category, price etc?

[parvezs27]

Hi!
Hope you're all doing well.

I've got a restaurant data set below and I want to make sure that the Item Name, such as "Plain Naan", is categorized as "Breads", the item size is "N/A" and the Price is "$2.50" throughout the whole sheet. As a beginner, I'm manually going through the rows one by one to make sure all the item names are categorised, sized and priced the same throughout the sheet, however, I'd like to ask if there is a quicker way to achieve this?

I have some experience with basic formula's but a complete beginner with VBA and Macros, willing to learn though!

Would appreciate any help here, thank you!

Doordash Items CSV.csv
	A	B	C	D	E	F	G	H
1	Order Number	Order Date	Customer Name	Item Name	Item Category	Item Size	Quantity	Item Price
2	696EEE6C	1/06/2022	Chris P	Plain Naan	Breads	N/A	1	2.50
3	696EEE6C	1/06/2022	Chris P	Lamb Vindaloo	Curries	Large	1	15.00
4	696EEE6C	1/06/2022	Chris P	Saffron Rice	Rice	N/A	1	4.00
5	FFC58DCA	1/06/2022	Priyanka J	Tava Roti	Breads	N/A	1	1.50
6	FFC58DCA	1/06/2022	Priyanka J	Chicken Curry With Rice	Curry Rice Pack	N/A	1	10.00
7	FFC58DCA	1/06/2022	Priyanka J	Vegetarian Tiffin	Packs	N/A	1	12.00
8	4965A11A	1/06/2022	Aabiskar B	Non Vegetarian Tiffin	Packs	N/A	1	14.00
9	4965A11A	1/06/2022	Aabiskar B	Tandoori Chicken	Entrée	Half	1	11.00
10	49FDAF27	1/06/2022	Andrew H	Beef Vindaloo	Curries	Large	1	15.00
11	49FDAF27	1/06/2022	Andrew H	Peas Pulao	Rice	N/A	1	5.00
12	49FDAF27	1/06/2022	Andrew H	Pappadums	Sides	N/A	1	1.00
13	49FDAF27	1/06/2022	Andrew H	Butter Chicken	Curries	Large	1	15.00
14	81B3D270	2/06/2022	Lili M	Non Vegetarian Tiffin	Packs	N/A	1	14.00
15	81B3D270	2/06/2022	Lili M	Non Vegetarian Tiffin	Packs	N/A	1	14.00
16	81B3D270	2/06/2022	Lili M	Chicken Samosa	Entrée	N/A	1	3.00
17	81B3D270	2/06/2022	Lili M	Gulab Jamun	Dessert	N/A	1	4.00
18	DD1B8F51	2/06/2022	Marco L	Saffron Rice	Rice	N/A	1	4.00
19	DD1B8F51	2/06/2022	Marco L	Lamb Rogan Josh	Curries	Large	1	15.00
20	DD1B8F51	2/06/2022	Marco L	Butter Chicken With Rice	Curry Rice Pack	N/A	1	10.00
21	3801217D	2/06/2022	Priyanka J	Vegetarian Tiffin	Packs	N/A	2	12.00
22	A7404B6B	3/06/2022	Priyanka J	Vegetarian Tiffin	Packs	N/A	2	12.00
23	7AB78F00	3/06/2022	Ann S	Tava Roti	Breads	N/A	1	1.50
24	7AB78F00	3/06/2022	Ann S	Boondi Raita	Sides	N/A	1	3.00
25	7AB78F00	3/06/2022	Ann S	Tandoori Chicken	Entrée	Half	1	11.00
26	7AB78F00	3/06/2022	Ann S	Dahi Bhalle	Desi Specials	N/A	1	7.00
27	7AB78F00	3/06/2022	Ann S	Non Vegetarian Tiffin	Packs	N/A	1	14.00
28	7AB78F00	3/06/2022	Ann S	Pistachio Kulfi	Dessert	N/A	1	4.00
Doordash Items CSV

 

[alansidman]

I would do this by having a master list of items with the items and pertinent info. Then using either vlookup or Index/Match complete the missing data.

 

[parvezs27]

I would do this by having a master list of items with the items and pertinent info. Then using either vlookup or Index/Match complete the missing data.

@alansidman thank you for responding! I've created a master list of items, how can I utilise Index Match or Vlookup to achieve the task? Any advice/resources would be appreciated, thank you!

 

[alansidman]

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Order Number	Order Date	Customer Name	Item Name	Item Category	Item Size	Quantity	Item Price						Product	Category
2	696EEE6C	44713	Chris P	Plain Naan	Breads	N/A	1	2.5						Beef Vindaloo	Curries
3	696EEE6C	44713	Chris P	Lamb Vindaloo	Curries	Large	1	15						Boondi Raita	Sides
4	696EEE6C	44713	Chris P	Saffron Rice	Rice	N/A	1	4						Butter Chicken	Curries
5	FFC58DCA	44713	Priyanka J	Tava Roti	Breads	N/A	1	1.5						Butter Chicken with Rice	Curry Rice
6	FFC58DCA	44713	Priyanka J	Chicken Curry With Rice	Curry Rice	N/A	1	10						Chicken Curry with Rice	Curry Rice
7	FFC58DCA	44713	Priyanka J	Vegetarian Tiffin	Packs	N/A	1	12						Chicken Samosa	Entrée
8	4965A11A	44713	Aabiskar B	Non Vegetarian Tiffin	Packs	N/A	1	14						Dahi Bhalle	Desi Specials
9	4965A11A	44713	Aabiskar B	Tandoori Chicken	Entrée	Half	1	11						Gulab Jamun	Dessert
10	49FDAF27	44713	Andrew H	Beef Vindaloo	Curries	Large	1	15						Lamb Rogan Josh	Curries
11	49FDAF27	44713	Andrew H	Peas Pulao	Rice	N/A	1	5						Lamb Vindaloo	Curries
12	49FDAF27	44713	Andrew H	Pappadums	Sides	N/A	1	1						Non Vegetarian Tiffin	Packs
13	49FDAF27	44713	Andrew H	Butter Chicken	Curries	Large	1	15						Pappadums	Sides
14	81B3D270	44714	Lili M	Non Vegetarian Tiffin	Packs	N/A	1	14						Peas Pulao	Rice
15	81B3D270	44714	Lili M	Non Vegetarian Tiffin	Packs	N/A	1	14						Pistachio Kulfi	Dessert
16	81B3D270	44714	Lili M	Chicken Samosa	Entrée	N/A	1	3						Plain Naan	Breads
17	81B3D270	44714	Lili M	Gulab Jamun	Dessert	N/A	1	4						Saffron Rice	Rice
18	DD1B8F51	44714	Marco L	Saffron Rice	Rice	N/A	1	4						Tandoori Chicken	Entrée
19	DD1B8F51	44714	Marco L	Lamb Rogan Josh	Curries	Large	1	15						Tava Roti	Breads
20	DD1B8F51	44714	Marco L	Butter Chicken With Rice	Curry Rice	N/A	1	10						Vegetarian Tiffin	Packs
21	3801217D	44714	Priyanka J	Vegetarian Tiffin	Packs	N/A	2	12
22	A7404B6B	44715	Priyanka J	Vegetarian Tiffin	Packs	N/A	2	12
23	7AB78F00	44715	Ann S	Tava Roti	Breads	N/A	1	1.5
24	7AB78F00	44715	Ann S	Boondi Raita	Sides	N/A	1	3
25	7AB78F00	44715	Ann S	Tandoori Chicken	Entrée	Half	1	11
26	7AB78F00	44715	Ann S	Dahi Bhalle	Desi Specials	N/A	1	7
27	7AB78F00	44715	Ann S	Non Vegetarian Tiffin	Packs	N/A	1	14
28	7AB78F00	44715	Ann S	Pistachio Kulfi	Dessert	N/A	1	4
Sheet1

Cell Formulas
Range	Formula
E2:E28	E2	=INDEX($O$2:$O$20,MATCH(D2,$N$2:$N$20,0))

 

[Joe4]

Don't know if this helps, but if you simply wanted to see all the instances of "Plain Naan" in a single glance, you can simply add Data Filters to your data, and then filter your "Item Name" column to only show all instances of "Plain Naan". Then you could do a quick inspection/scan to make sure all instances look correct.