Drop down menu Autofill

[alifihri]

Hey I need help on this:

I first solved the proplem of showing the correct cities based on the what was selected in the first drop menu by using this formulas in data validation: (coutry and city are named ranges for countries and cities).
IF($E$3="US",OFFSET(city, 0, 0, 2, 1),city)
But the problem is that drop down values are not autofilled for example If I pick international and click on Paris, paris will stay there even if I changed to E3 to us.

What I want to achive here to make drop down values dynamic change values after changing value of the controlling drop down or at least make the first value as default I whish you got me. Thanks

 

[awoohaw]

This is auto fill drop down i did a while back. It is for three, but you can just cut out the 3rd one.
I think you have the functions that can build these lists, etc.
(I just rechecked, 2019 has filter but not unique - sorry)

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Column A	Column B	Column C		COL A SELECTION		COL B SELECTION		COL C SELECTION			COLADROP	COLBDROP	COLCDROP
2	A	D	N		B		I		AG			A	H	AE
3	A	D	O		^^for ease and reference here, these will be							B	I	AF
4	A	D	P		where the drop downs are placed on your processing								J	AG
5	A	E	Q		worksheet									AH
6	A	E	R
7	A	E	S
8	A	F	T
9	A	F	U
10	A	F	V
11	A	G	W
12	A	G	X
13	A	G	Y
14	A	G	Z
15	B	H	AA
16	B	H	AB
17	B	H	AC
18	B	H	AD
19	B	I	AE
20	B	I	AF
21	B	I	AG
22	B	I	AH
23	B	J	AI
24	B	J	AJ
25	B	J	AK
26	B	J	AL
27	B	J	AM
28	C	K	AN
29	C	K	AO
30	C	K	AP
31	C	K	AQ
32	C	L	AR
33	C	L	AS
34	C	L	AT
35	C	L	AU
36	C	L	AV
37	C	M	AW
38	C	M	AX
39	C	M	AY
40	C	M	AZ
41	BA	BB	BC
Sheet1

Cell Formulas
Range	Formula
L2:L3	L2	=SORT(UNIQUE(TBL_LOOKUPS[Column A]))
M2:M4	M2	=SORT(UNIQUE(FILTER(TBL_LOOKUPS[Column B],TBL_LOOKUPS[Column A]=E2,"")))
N2:N5	N2	=FILTER(TBL_LOOKUPS[Column C],(TBL_LOOKUPS[Column A]=E2)*(TBL_LOOKUPS[Column B]=G2),"")
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
E2	List	=L2#
G2	List	=$M$2#
I2	List	=$N$2#