linking drop down lists

  • Thread starter Thread starter reading2004
  • Start date Start date
R

reading2004

hi, im trying to create a user friendly spreadsheet. i have 2 columns
need help with.

in the first column i have created a drop down list containing
continents of the world. in the second column i want another drop dow
list to display only the countries from the continent selected. fo
instance. in the first column i have selected africa. how can i make i
so that when i have selected africa from the continents drop down list
to make the cell next to it (the countries drop down list)( only giv
the option of selecting a country from africa instead of all th
countries of the world
 
Hello
Here's a suggestion:
Name your range of continents "Continents"
Name each range containing countries starting with the prefix of the
continent (eg "Asia") followed by "Countries" (eg "AsiaCountries")
Use data validation for both lists
Refer to the defined name "Continents" for the continents drop down list (in
A1 in this example)
Refer to the following formula to to retrieve the relevant countries of the
selected continent :
=INDIRECT($A$1 & "Countries")
Where in A1 you would have the drop down list of continents

HTh
Cordially
Pascal
 
Back
Top