Two *Separate* Dependent Dropdown Lists

[lkc]

I'd like to create two independently dependent dropdown lists. To clarify--

I have three dropdown lists: #1, #2, and #3 (created using the INDIRECT function and named table ranges)
Dropdown list #2 is dependent on Dropdown list #1
I would like Dropdown list #3 to *also* be dependent on Drop Down List #1 (not #2, as in a normal "cascading" dropdown list setup).

Anyone have any ideas?

 

[ExceLoki]

something like this?
-------------

multiple dependant dropdowns-simple.xlsx
	A	B	C	D	E	F	G	H	I	J
1	Letter	Number	Region		Letters	Numbers		Letter	Number	Region
2	A	3	East		A	1		A	3	East
3	A	2	East		B	2		B	3	North
4	B	2	North		C	3		C
5	B	2	North		D	4		D
6	B	3	North		E			E
7	B	4	North
8	C	1	North
9	C	4	North
10	C	4	North
11	D	1	West
12	D	2	West
13	D	3	West
14	D	3	West
15	E	1	North
16	E	2	North
17	E	2	North
18
19
20								FORMULAS
21								$E$2:$E$6	OFFSET(A1,MATCH(H2,A2:A17,0)*1,1,COUNTIF(A2:A17,H2),1)	OFFSET(A1,MATCH(H2,A2:A17,0)*1,2,COUNTIF(A2:A17,H2),1)
Sheet2

Cells with Data Validation
Cell	Allow	Criteria
H2:H17	List	=$E$2:$E$6
I2:I17	List	=OFFSET(A1,MATCH(H2,A2:A17,0)*1,1,COUNTIF(A2:A17,H2),1)
J2:J17	List	=OFFSET(A1,MATCH(H2,A2:A17,0)*1,2,COUNTIF(A2:A17,H2),1)