+ Reply to Thread
Results 1 to 2 of 2

3 levels independent drop down lists

  1. #1
    Registered User
    Join Date
    05-30-2012
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003
    Posts
    95

    3 levels independent drop down lists

    Hello All,

    Please find my attached excel 2003. I want to make 3 level independent drop down lists.

    On Sheet1 worksheet I have 3 drop down lists: 1st, 2nd and 3rd.

    - 1st drop down list is simple, just to lookup the list B2:B4 on worksheet "List1" (the name is given "Items").
    - 2nd drop down list depends on the chosen option of 1st drop down list. E.g. If I choose "Ballpen" in 1st drop down list, I will have options of Black, Red and Blue in 2nd drop down as shown on the worksheet "List2".
    - 3rd drop down list depends on the chosen option of 2nd drop down list. E.g. if I choose "Black" in 2nd drop down list, I will have options of Variant1, Variant2 and Variant3 as show on the worksheet "List2".

    But how can I do this? Thanks!!
    Attached Files Attached Files

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: 3 levels independent drop down lists

    See if this helps..

    You will need dynamic named ranges for the 2nd and 3rd level drop down lists

    http://www.excelforum.com/excel-gene...l-entries.html
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ 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