Hi all,
I’m wanting to filter a Data Validation list.

I have a dynamic Table with 3 columns. ‘City’(‘Sheet1’!$C2), ‘Suburb’ (‘Sheet1’!$D2)& ‘Distance from GPO’ (‘Sheet1’!$E2). In this table, the ‘City’ column utilizes a data validation dropdown list. The other 2 columns are entered manually. I have a named range called ‘Cities’ (‘Sheet1’!A1:A5) for the ‘City’ column.

On another sheet, in the same book, I select the data from this Table. There are 3 columns, the same as the table.

My problem has 2 parts.
I’m using data validation to select the city in the first column (‘Sheet2’!$A2). (Data Validation List =’Cities’)

My problem is the ‘Suburb’ column (‘Sheet2’!$B2). Using data validation, I want only the suburbs of the city selected in the first column to show up in the dropdown menu.

Secondly, after selecting the suburb, it’s ‘Distance from the GPO’ needs to populate the third column via Vlookup.

Thanking you all in advance.

Hi,

This is making my head spin.

You could have a list of over 100 Cities, each with over 20 Suburbs, and you want the cells in the Suburb column to have Data Validation based on the City selected in the city column??

Now, if you have even just 100 rows with each city different you will need 100 different (and dynamic) suburb validation sets.

Not really on.

Suggest you have some type of input sheet or form which carries the input boxes/data validation needed, and the selected value pairs are passed TO the data sheet.

That will be MUCH easier and more efficient.

Educo