Hello,
I am trying to create a spreadsheet which includes some geographical data so that I can collect stats based on regions, counties, towns etc. To ensure correct information is inputted I want to include dropdown lists in the data validation. Easy enough but I also want to prevent people from accidentally putting locations in the wrong Region or County. For example:
Region: North
County: North Yorkshire
Town/City: Leeds
Leeds should come within West Yorkshire. So basically I am trying to filter the dropdown list dependent on the previous cell's input. Once a person enters North Yorkshire in the county cell, only towns within North Yorkshire can be entered in the next cell. Is this possible? If so can anybody perhaps give me a link to a guide explaining how?
Bookmarks