+ Reply to Thread
Results 1 to 8 of 8

four level dependent drop down

  1. 02-28-2022, 10:55 AM #1
    MCDERMOTT5588
    MCDERMOTT5588 is offline
    Registered User
    Join Date
    09-06-2021
    Location
    Northern Ireland
    MS-Off Ver
    365
    Posts
    20

    four level dependent drop down

    Hi,

    I am trying to create a 4 level drop down. I have each of the dropdown lists coded level 1-4 in name manager.

    I have tried to use index match to link first level to second etc but this isn't working.

    =INDEX(List!$G$2:$L$113,MATCH(Level1Code,List!$I$2:$I$113,0),1):INDEX(List!$G$2:$L$113,SUM(MATCH(Level1Code,List!$I$2:$I$113,0),COUNTIF(List!$I$2:$I$113,Level1Code),-1),5)

    Please can you help, it will be very much appreciated!

    Frances
    Reply With QuoteRegister To Reply
  2. 02-28-2022, 01:38 PM #2
    Limor_OP
    Limor_OP is offline
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: four level dependent drop down

    Hi,
    Fast answers need clear examples.
    See the yellow banner at the top of the page for instructions.
    Reply With QuoteRegister To Reply
  3. 02-28-2022, 02:21 PM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: four level dependent drop down

    To reference the info in your DD, you need to use INDIRECT()
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  4. 02-28-2022, 10:31 PM #4
    menem
    menem is offline
    Forum Expert
    Join Date
    09-30-2019
    Location
    Chiangmai, Thailand
    MS-Off Ver
    Office 2016, Excel 2019
    Posts
    1,234

    Re: four level dependent drop down

    Please review in

    https://www.excelforum.com/excel-for...ml#post5625764

    it's may help.

    Regards.
    My English is very poor, so please be patient >_<"

    My Dynamic Related Dropdown post:
    https://www.excelforum.com/excel-for...ml#post5657376
    https://www.excelforum.com/excel-for...ml#post5655711
    https://www.excelforum.com/excel-for...ml#post5655762
    Reply With QuoteRegister To Reply
  5. 03-01-2022, 05:27 AM #5
    MCDERMOTT5588
    MCDERMOTT5588 is offline
    Registered User
    Join Date
    09-06-2021
    Location
    Northern Ireland
    MS-Off Ver
    365
    Posts
    20

    Re: four level dependent drop down

    Thank you for your reply, can you help me with the INDIRECT formula?
    Reply With QuoteRegister To Reply
  6. 03-01-2022, 07:16 AM #6
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,193

    Re: four level dependent drop down

    Please post a w/book as requested.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  7. 03-01-2022, 09:24 AM #7
    MCDERMOTT5588
    MCDERMOTT5588 is offline
    Registered User
    Join Date
    09-06-2021
    Location
    Northern Ireland
    MS-Off Ver
    365
    Posts
    20

    Re: four level dependent drop down

    Thank you John.

    Attached zip file was to large otherwise Is it possible to create dynamic dropdown for:
    Region
    County
    Local authority district
    Ward

    Is there a way that the dropdown only displays unique values?

    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 03-02-2022, 07:43 AM #8
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,193

    Re: four level dependent drop down

    I don't have 365 but you can use the UNIQUE function to get the various drop downs.

    Having selected a Region you need to have second list (dynamic) to extract Counties for the Region. And hence similar for the other drop downs.

    I suggest you post a a much smaller file 9as recommended in the yellow banner)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] multi level dependent drop down list
    By (T_T) in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-16-2020, 06:02 AM
  2. 3 level dependent drop-down list in excel
    By TJ7009 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-01-2020, 04:57 AM
  3. [SOLVED] Multi Level Dependent Drop Down Lists
    By mysticmoron109 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-03-2015, 03:35 PM
  4. [SOLVED] 3 Level Dependent Data Validation
    By ChristianZags in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-17-2014, 01:17 AM
  5. Multi Level Dependent Drop-down list, Explanation required
    By Shoieb.arshad in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-31-2012, 11:36 AM
  6. Mulitple Level Dependent Lists.
    By excelkeechak in forum Excel General
    Replies: 8
    Last Post: 04-12-2011, 04:18 AM
  7. Multi-level dependent lists
    By aussiemate in forum Excel General
    Replies: 6
    Last Post: 02-25-2010, 04:02 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1