+ Reply to Thread
Results 1 to 3 of 3

Drop Down List Dependent on Previous Drop Down List

  1. #1
    Registered User
    Join Date
    03-29-2017
    Location
    Dallas, TX
    MS-Off Ver
    2010
    Posts
    3

    Drop Down List Dependent on Previous Drop Down List

    Hello,

    I am trying to make a selection sheet for my company. I currently have a drop down list to choose different level front doors that can be installed. I need a second cell in yellow to show in a drop down list the options for the level door that was chosen in the previous cell. Attached are a couple pictures showing what I have done. Any help would be greatly appreciated. I tried to do a vlookup and a drop down list and tried to combine them but haven't been able to get them to work. I would attach my current worksheet but the post is not letting me.

    Thanks for all the help. I really appreciate it.

    Front Page.JPGOptions.JPG

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Drop Down List Dependent on Previous Drop Down List

    Hi matt,

    The topic is called Cascading Dropdown list. See if searching on that helps.

    http://analystcave.com/excel-cascading-drop-down/ or
    https://www.excelcampus.com/tables/d...nt-drop-lists/
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    03-29-2017
    Location
    Dallas, TX
    MS-Off Ver
    2010
    Posts
    3

    Re: Drop Down List Dependent on Previous Drop Down List

    That looks like it is what I am looking for. Thanks a bunch for the quick response. I really appreciate it.

+ 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. Drop down dependent on previous filtered list - NOT SORTED ALPHABETICALLY
    By K Cooper in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-25-2018, 06:38 PM
  2. [SOLVED] Clear up to three dependent drop down lists based on selection in superior drop down list
    By theletterh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-04-2016, 09:31 PM
  3. Dependent Drop Down list to autofill next drop down with selective choices
    By MitchellHydro1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-08-2015, 01:18 PM
  4. [SOLVED] Suppress drop-down list dependent on value chosen in another drop-down list
    By ptmald in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2013, 07:17 PM
  5. Populate Drop-down list based on selection from previous drop-down list
    By Diventus in forum Excel - New Users/Basics
    Replies: 14
    Last Post: 01-11-2013, 10:55 AM
  6. Populate Drop-down list based on selection from previous drop-down list
    By poison_stone in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 12-11-2012, 06:10 PM
  7. [SOLVED] Column B drop down list with 2 options, columns C & E with dependent drop down lists
    By betic in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-26-2012, 03:47 PM

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