Multiple Drop Down Menus Dependent on First Drop down

[Hoss991476]

I'm Working on a way to quote out jobs easier, and ran in to something that no one has the answer too.

I'm trying to make multiple drop down menus dependent of one drop down

This is the example of what i'm trying to do. column b is the drop down. rows 3,4,5 i'm trying to make dependent of b1 but show only the products related to that row. i have the rest of the excel sheet in name ranges, and prefer if i can do this using name ranges and data validations for simplicity sake

https://u32960789.dl.dropboxusercontent.com/u/32960789/excel/test.xlsx

 

[mart37]

do you mean for B3: =INDIRECT(B1&"_COM")

 

[FDibbins]

Cannot access your file, but see if this will help?

for the DD's

	B​	C​	D​
3​	Type​	Category​	Breed​
4​	Fish	Marine	Shark
5​
6​
7​	1. create a range name for the main category
8​	2. create a range name for each sub-category, based on what it is
9​
10​	for mine, the main category is called Type (A2)
11​	for the sub categories I give them the same name as in Type (B2:E2)
12​	(if you have another level, you would repeat this for eacg subcategory, to get sub-sub-categries)
13​
14​	To get the DD's to work...
15​
16​	DD for B4 =TYPE
17​	DD for C4 =INDIRECT(SUBSTITUTE(B4," ","_"))

for your data...

	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​	K​
1​	Level 1		Level 2					Level 3
2​	Type		Mammal	Bird	Fish	Bug		Dog	Cat	Fresh Water	Marine
3​	Mammal		Dog	Domestic	Fresh Water	Insect		Doberman	Lion	Trout	Shark
4​	Bird		Cat	Wild	Marine	Arachnid		Poodle	Tiger	Minow	Barracuda
5​	Fish		Cow					bulldog	House	Pike
6​	Bugs

 

[Hoss991476]

do you mean for B3: =INDIRECT(B1&"_COM")

That would work.... didn't think of that.... Just have to keep in mind of if i changed the name of the name range then i would have to change the formulas as well

Thank you sooo much!