+ Reply to Thread
Results 1 to 2 of 2

Create a dependent drop down list with dynamic list

  1. #1
    Registered User
    Join Date
    02-11-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    27

    Create a dependent drop down list with dynamic list

    Hi

    I need to create a 2-stage dependent drop down list.

    Stage 1:
    In cell G7 (on a tab called 'Data'), I have created a drop down list based on a range name called 'Region' - no help needed here

    Stage 2:
    In cell G8, I need to create a drop down list which is dependent on the value chosen in G7.

    Problem is, I will need to create a dynamic range name here which needs to vlookup or match the value from G7 in a dynamic list of data (the data is on different tab called 'RCA Data' and is spread over columns A:E with row A for headings - the data will go down an undetermined number of rows)

    Every time the value in G7 matches a value in the 'RCA data' (the potential matches are stored in column D) I need the corresponding cell value in column C to be added to the dynamic list. This list then needs to be available to choose from a drop down list in G8.

    Thanks

  2. #2
    Registered User
    Join Date
    02-11-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: Create a dependent drop down list with dynamic list

    If absoluteley necessary, I can switch around the columns so that vlookup works to the right (i.e. searches to column E from D instead of C from D) because I know there are problems searching left of a match

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dynamic dependent drop-down list with cascading queries?
    By amieamieamie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-16-2013, 09:44 AM
  2. Way to create a dynamic drop down list.
    By jensca in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-17-2013, 10:55 AM
  3. Create a sheet with content dependent on the selection of a drop-down list
    By bbaumgardner22 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2013, 04:25 PM
  4. [SOLVED] Trying to make multiple dependent drop down list with dynamic ranges
    By Gwen@YouWantWhat? in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-01-2012, 12:55 AM
  5. Create Default for Dependent Drop Down List
    By moskealy in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-14-2010, 03:11 PM

Tags for this Thread

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