Show List Based on Drop Down Selections

[thelegazy]

Hi All,

I'm sure this is something that people on here are able to do, I just haven't been able to find anything after researching (maybe not using the right keywords).

Basically, I have to drop downs that are linked using "Data Validation". Based on the values that are selected I want to be able to show a list of associated roles based on the criteria selected. Presuming this would need to be done via VBA?

At the moment I have the lists, but the data isn't setup. I'm open to suggestions on how to model the data to best accomplish this.

Any help/direction would be greatly appreciated!

 

[easy2understandexcel]

Did you want 2 input drop down boxes and then a column populated with data, or 2 drop down boxes, and then a 3rd drop down that only contains the remaining relevant values

 

[thelegazy]

Did you want 2 input drop down boxes and then a column populated with data, or 2 drop down boxes, and then a 3rd drop down that only contains the remaining relevant values

Hey, I would like the first option

 

[FDibbins]

I think you want something like this?

	A​	B​	C​	D​	E​	F​	G​
1​	Name	header1	Header2		aa	1​
2​	aa	1​	10​		Name	header1	Header2
3​	bb	2​	20​		aa	1​	10​
4​	cc	1​	30​		aa	1​	70​
5​	aa	2​	40​
6​	bb	1​	50​
7​	cc	2​	60​
8​	aa	1​	70​
9​	bb	2​	80​
10​	cc	1​	90​

E1 and F1 would be your DD cells
E3=IFERROR(INDEX(A:A,SMALL(IF(($A$2:$A$10=$E$1)*($B$2:$B$10=$F$1),ROW($A$2:$A$10)),ROWS($A$1:A1))),"")
ARRAY entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try to enter the {} manually yourself.

Then copy down and across as needed

 

[thelegazy]

I think you want something like this?

	A​	B​	C​	D​	E​	F​	G​
1​	Name	header1	Header2		aa	1​
2​	aa	1​	10​		Name	header1	Header2
3​	bb	2​	20​		aa	1​	10​
4​	cc	1​	30​		aa	1​	70​
5​	aa	2​	40​
6​	bb	1​	50​
7​	cc	2​	60​
8​	aa	1​	70​
9​	bb	2​	80​
10​	cc	1​	90​

<tbody>
</tbody>

E1 and F1 would be your DD cells
E3=IFERROR(INDEX(A:A,SMALL(IF(($A$2:$A$10=$E$1)*($B$2:$B$10=$F$1),ROW($A$2:$A$10)),ROWS($A$1:A1))),"")
ARRAY entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try to enter the {} manually yourself.

Then copy down and across as needed

Worked perfectly!!! Thanks