Dependent Drop-Down Lists

[King_Louie]

Currently have a series of dependent drop lists using Tables and indirect formulas using the below formulas. It works perfectly but I would like to find a way to maintain a single table as per the below versus have to create multiple tables to ease with data modification such as, (1) new variant (e.g., EV), modify name (e.g., Sport i/o Performance) and/or want to add additional dependent drop-down lists (e.g., column for Color)?

Manufacturer=ManufacturerList (named table reference)
Style: =INDIRECT(SUBSTITUTE(A1," ","_"))
Model: =INDIRECT(SUBSTITUTE(B1," ","_"))

	A	B	C
1​	Manufacturer	Style	Model
2​	BMW	SUV	X5
3​	BMW	Sedan	3 Series
4​	Ford	Truck	F-150
5​	Ford	Performance	Mustang
6​	Dodge	Performance	Challenger
7​	Dodge	Truck	RAM

 

[Akuini]

It works perfectly but I would like to find a way to maintain a single table as per the below versus have to create multiple tables to ease with data modification

If you're willing to use macro then please check this:

3 or More Dependent Data Validation, with VBA, easy to set up

I want to share a macro to set up multi dependent data validation with vba. Some versions of dependent data validation use formulas to set them up, usually with indirect functions. For 2 or 3 dependent data validation & small data set, it's pretty easy to set it up, but for more than 3, it might...

www.mrexcel.com

 

[King_Louie]

Thanks for the reply. I think you have the solution in your last post! There is a follow up question but I'll move to the other thread.