+ Reply to Thread
Results 1 to 2 of 2

Filter a data validation list from a table

  1. #1
    Registered User
    Join Date
    08-13-2010
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    11

    Filter a data validation list from a table

    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.
    Attached Files Attached Files
    Last edited by JackyJ; 08-19-2010 at 06:38 AM.

  2. #2
    Registered User
    Join Date
    08-13-2010
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Filter a data validation list from a table

    Somehow I post the wrong file. Sample.xlsx is incomplete. This is the correct one. 2nd Sample.xlsx
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1