limit Drop down data

[Beingakg]

in the attached excel/below table, in cell (F2)- drop down reflects all data in column A and in cell (F4)- "second drop down" list have all data from column B. Is it possible that "second drop down" show only states of India (as per result from first drop down)

Country	State
India	Delhi	Dropdown - 1 --->	India
India	Haryana
India	Chandigh	Dropdown - 2 --->	AK
India	MP
India	UP
India	AP
US	AL
US	OK
US	PA
US	NY
US	NJ
US	AK

 

[awoohaw]

this uses a 'helper' range:

Mr Excel 8.xlsm
	A	B	C	D	E
1	Country	State
2	India	Delhi	Dropdown - 1 --->	US	AL
3	India	Haryana			OK
4	India	Chandigh	Dropdown - 2 --->	AK	PA
5	India	MP			NY
6	India	UP			NJ
7	India	AP			AK
8	US	AL
9	US	OK
10	US	PA
11	US	NY
12	US	NJ
13	US	AK
14
Sheet5

Cell Formulas
Range	Formula
E2:E7	E2	=FILTER(B2:B13,A2:A13=D2)
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
D2	List	=$A$5:$A$13
D4	List	=E2#