A way to autofill sub-categories in this dataset?

[parvezs27]

Hi everyone!

I created this food dataset below but I forgot to add food sub-categories. I am now adding sub-categories but looking for a way to autofill the sub-categories based on the values in Column D "Item". For example, if Item is "Plain Naan", the sub-category value throughout the whole sheet should be "Naans".

I tried using the IF function, =IF(D14="Non Vegetarian Tiffin","Tiffin Packs",""), but the issue was that I couldn't find a way to leave the false values unchanged when dragging the formula down the column. Everything else would get affected.

How would you guys recommend to go abouts this rather than having to input all the sub-categories one by one?

Any help would be appreciated, thank you!

Doordash Items CSV.csv
	A	B	C	D	E	F	G	H	I
1	ORDER_ID	DATE	NAME	ITEM	CATEGORY	SUB_CATEGORY	SIZE	QUANTITY	PRICE
2	696EEE6C	1/06/2022	Chris P	Plain Naan	Breads	Naans	N/A	1	2.5
3	696EEE6C	1/06/2022	Chris P	Lamb Vindaloo	Curries	Lamb Curries	Large	1	15
4	696EEE6C	1/06/2022	Chris P	Saffron Rice	Rice	Plain Rice	N/A	1	4
5	FFC58DCA	1/06/2022	Priyanka J	Tava Roti	Breads	Rotis	N/A	1	1.5
6	FFC58DCA	1/06/2022	Priyanka J	Chicken Curry With Rice	Curry Rice Pack	Chicken Curry Rice Pack	N/A	1	10
7	FFC58DCA	1/06/2022	Priyanka J	Vegetarian Tiffin	Packs	Tiffin Packs	N/A	1	12
8	4965A11A	1/06/2022	Aabiskar B	Non Vegetarian Tiffin	Packs	Tiffin Packs	N/A	1	14
9	4965A11A	1/06/2022	Aabiskar B	Tandoori Chicken	Entrée	Tandoor Entrée	Half	1	11
10	49FDAF27	1/06/2022	Andrew H	Beef Vindaloo	Curries	Beef Curries	Large	1	15
11	49FDAF27	1/06/2022	Andrew H	Peas Pulao	Rice	Pulao Rice	N/A	1	5
12	49FDAF27	1/06/2022	Andrew H	Pappadums	Sides	Crunchy Sides	N/A	1	1
13	49FDAF27	1/06/2022	Andrew H	Butter Chicken	Curries	Chicken Curries	Large	1	15
14	81B3D270	2/06/2022	Lili M	Non Vegetarian Tiffin	Packs	Tiffin Packs	N/A	1	14
15	81B3D270	2/06/2022	Lili M	Non Vegetarian Tiffin	Packs	Tiffin Packs	N/A	1	14
16	81B3D270	2/06/2022	Lili M	Chicken Samosa	Entrée	Fried Entrée	N/A	1	3
17	81B3D270	2/06/2022	Lili M	Gulab Jamun	Dessert	Dumpling Desserts	N/A	1	4
18	DD1B8F51	2/06/2022	Marco L	Saffron Rice	Rice		N/A	1	4
19	DD1B8F51	2/06/2022	Marco L	Lamb Rogan Josh	Curries		Large	1	15
20	DD1B8F51	2/06/2022	Marco L	Butter Chicken With Rice	Curry Rice Pack		N/A	1	10
21	3801217D	2/06/2022	Priyanka J	Vegetarian Tiffin	Packs		N/A	2	24
22	A7404B6B	3/06/2022	Priyanka J	Vegetarian Tiffin	Packs		N/A	2	24
23	7AB78F00	3/06/2022	Ann S	Tava Roti	Breads		N/A	1	1.5
24	7AB78F00	3/06/2022	Ann S	Boondi Raita	Sides		N/A	1	3
25	7AB78F00	3/06/2022	Ann S	Tandoori Chicken	Entrée		Half	1	11
26	7AB78F00	3/06/2022	Ann S	Dahi Bhalle	Desi Specials		N/A	1	7
27	7AB78F00	3/06/2022	Ann S	Non Vegetarian Tiffin	Packs	Tiffin Packs	N/A	1	14
28	7AB78F00	3/06/2022	Ann S	Pistachio Kulfi	Dessert		N/A	1	4
29	89FD504C	3/06/2022	Marco L	Onion Bhaji	Entrée		N/A	1	2
30	89FD504C	3/06/2022	Marco L	Tava Roti	Breads		N/A	1	1.5
31	89FD504C	3/06/2022	Marco L	Saffron Rice	Rice		N/A	1	4
32	89FD504C	3/06/2022	Marco L	Chicken Korma	Curries		Large	1	15
33	89FD504C	3/06/2022	Marco L	Beef Curry With Rice	Curry Rice Pack		N/A	1	12
34	80CB6345	4/06/2022	Ravi R	Paneer Pakora	Entrée		N/A	1	3
35	80CB6345	4/06/2022	Ravi R	Saag Paneer	Curries		Small	1	6
36	80CB6345	4/06/2022	Ravi R	Kadhai Paneer	Curries		Small	1	7
37	80CB6345	4/06/2022	Ravi R	Onion Bhaji	Entrée		N/A	1	2
38	80CB6345	4/06/2022	Ravi R	Vegetarian Thali	Packs		N/A	1	11
Doordash Items CSV

Cell Formulas
Range	Formula
F14:F15,F18:F38	F14	=IF(D14="Non Vegetarian Tiffin","Tiffin Packs","")

 

[gargamalebarbosa]

Hi,
Create a new table with 2 columns. Add all categories and sub categories. Than use VLOOKUP in main table for match values.

 

[parvezs27]

Hi,
Create a new table with 2 columns. Add all categories and sub categories. Than use VLOOKUP in main table for match values.

Thanks for the response! Would there be an issue here because some categories contain multiple sub-categories? e.g. The category bread has "Naans" and "Rotis".

 

[parvezs27]

Hi,
Create a new table with 2 columns. Add all categories and sub categories. Than use VLOOKUP in main table for match values.

All good it is now working. Thank you!