list of countries, states and cities

[apgmin]

Can please anyone help me.

In column A the person needs to select the country ( I have the list of the countries in column X, so simply it is a question of data validation )

Depending on the value selected in cell say A2, the dropdown in B2 should have the list of states to select ( I have in column Y the list of the state of India, For other countries, state / province list I do not have as 99% of my students are from India)

1. Here my problem is, the dropdown in B2 should show the list if country selected is India or allow the user to fill his state if he is from any other country

SIMILARLY depending on the value selected in cell say B2, the dropdown in C2 should have the list of cities to select ( I have in column Z and AA the list of the cities statewise of India, other country's city list I do not have)

State	Name of City
Andaman and Nicobar Islands	Port Blair
Andhra Pradesh	Adoni
Andhra Pradesh	Amalapuram
Arunachal Pradesh	Naharlagun
Arunachal Pradesh	Pasighat
Assam	Barpeta
Assam	Bongaigaon City
Assam	Dhubri
Assam	Dibrugarh
Bihar	Araria
Bihar	Arrah
Bihar	Arwal

2. Here my problem is the dropdown in C2 should show the list if state selected is from India in B2 or allow the user to fill his city

 

[eduzs]

See if this helps:

Dependant data validation dropdown list

My worksheet has a range like (hypothetical, just an example): Type: Name: 1 Orange 1 Blue 2 White 2 Green 2 Black What I want to do is, when A1 value is "1" or "2" the dropdown/data validation in B1 will show only the correpondent names. A1="1", shows "Orange, Blue" A2="2", shows "White...

www.mrexcel.com

 

[apgmin]

No sir,

this will allow the user to select the entry from the list base on the earlier selection, but not allow him to enter a new state or new city if the appropriate data is not in the list
Like say if he is from any other country except india