Drop Down Lists

[Geek Girl 007]

Good Morning all,
From a drop down list in B4, if I select A can that determine what list will be available in C4??

 

[Georgiboy]

One option is with tables:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1								MLIST		A	B	C
2								A		1	4	7
3		LIST 1	LIST 2					B		2	5	8
4		B	6					C		3	6	9
5
6	Validation formula	=INDIRECT("MLIST")	=INDIRECT("_"&B4)				Table Names	MLIST		_A	_B	_C
Sheet1

Cells with Data Validation
Cell	Allow	Criteria
B4	List	=INDIRECT("MLIST")
C4	List	=INDIRECT("_"&B4)

 

[Geek Girl 007]

One option is with tables:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1								MLIST		A	B	C
2								A		1	4	7
3		LIST 1	LIST 2					B		2	5	8
4		B	6					C		3	6	9
5
6	Validation formula	=INDIRECT("MLIST")	=INDIRECT("_"&B4)				Table Names	MLIST		_A	_B	_C
Sheet1

Cells with Data Validation
Cell	Allow	Criteria
B4	List	=INDIRECT("MLIST")
C4	List	=INDIRECT("_"&B4)

SORRY for the delay.
This is GREAT Thank you

 

[Georgiboy]

No probs and you're welcome. Thanks for the feedback.

 

[smozgur]

This is GREAT Thank you

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.