+ Reply to Thread
Results 1 to 5 of 5

Validation To Create Multiple Dependent Lists

  1. #1
    Registered User
    Join Date
    10-22-2009
    Location
    Saskatchewan, Canada
    MS-Off Ver
    Excel 2007
    Posts
    6

    Validation To Create Multiple Dependent Lists

    I am making a document for my cabinet shop.
    I have drop down lists so employees can select the cabinet wood (Cell A1), then the document using Indirect function only shows the door styles available in that wood type in the next drop down list (Cell A2).
    Now my problem is I want to use another indirect function to show only the finishes (colors) available in that wood type.
    How can I "link" my finishes (cell A3) to the wood type (Cell A1) when the door styles (Cell A2) is already linked to them?

    Clear like mud!
    Thanks!

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Validation To Create Multiple Dependent Lists

    use the same principle for the next validation, i.e. create range names that are the same as the door styles and list the finishes applicable to that door style in the named range, then use indirect for the door style to get the list of finishes.

    If that does not help, post a (small) sample workbook.

    hth

  3. #3
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Validation To Create Multiple Dependent Lists

    You can use a "trick" in the validation list. Let's say the "wood" that was chosen is Maple, you most likely have a named range called MAPLE for the door styles?

    Instead, name the range MapleDoors and use an indirect formula of:
    =INDIRECT(A1 & "Doors")

    Then do the same thing for MapleFinishes:
    =INDIRECT(A1 & "Finishes")
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  4. #4
    Registered User
    Join Date
    10-22-2009
    Location
    Saskatchewan, Canada
    MS-Off Ver
    Excel 2007
    Posts
    6

    Thumbs up Re: Validation To Create Multiple Dependent Lists

    Thankyou teylyn & JBeaucaire for the quick responses.
    I am using JBeaucaire's suggestions and it is working great!

    Thanks Again!

  5. #5
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Validation To Create Multiple Dependent Lists

    If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


    (Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)

+ 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