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.
Attached is a sample file.
Thanking you all in advance.
Bookmarks