How to Create Multi-level Dependent Drop Down Lists

In this video, we learn how to combine Tables, Pivot Tables, and Data Validation to create a series of dependent drop down lists. This solution allows for the creation of multiple independent sets of drop down lists. By using drop down lists, you can improve the consistency and integrity of your data while also improving the user experience.

TIMESTAMPS:
====================
0:00 Introduction
0:20 Outline
1:12 Pivot Table Creation
5:55 Drop Down Creation
12:25 Finished Example
14:43 Additional Example
15:04 Wrap Up

MICROSOFT LINKS:
====================



UNSPLASH IMAGE:
====================
Photo by Laura Ockel on Unsplash

[ikemeneke]

Thank you very much for this information
I have been looking for something like this for long

[Mohamed.GadAllah]

Hi, Thanks for the video; if I have a Microsoft 365 license, what would be the process!?

[RodrigodeAraujo-vg]

I can`t see the formula of the data validation. Its blurry.
Is there any chance to post the formula?
it`s from 11:40 min.

[anthonyliang]

Hi really appreciate this video, one issue i had when emulating this with my project is that it wont update new data due to overlapping pivot tables, i have the same spacing as you and nothing underneath each pivot table. what should i do?

[natalianatalia]

Thank you so much for that video; I have been looking for this for so long. I have followed your instructions step by step, and it is working well. I have one question, though – not really an error, just an annoying thing. For example, the division I chose is Div 07, and when I expand the dropdown of Salespeople, it shows me the names of salespeople assigned to that Div 07. However, at the top of the dropdown, it is displaying Div 07 as the first Salesperson option. I'm not sure where I made a mistake, and I would appreciate information if you know what I should correct. Thank you.

[jasoneaton]

I have been searching for a way to do this for way too long. I'm not an office guy. I will work on this method but how do I do it the easier way you suggested is available with 365?

[jackaryan]

Hey I loved your video. But I couldn’t find your formula you used in video because the video was blurry. It would be really great if you could share the excel file..

Please Please 🙏

Please

[Abdulaziz-dhrt]

Thanks for the great work and great video. I made it to reach up to aligning all the data using the pivot table, what stopped me is the If function in which I couldn’t do. I faced an issue with using @Region or in my case @Description and couldn’t make it to appear in light blue font as in the formula. I couldn’t do the whole function with the true and false statements as well. I would really appreciate it If you could help me by any mean to get through this.

[reddyfrench]

Is there any method to do this for drop down menus below each other

[rf-supra]

Hi, thank you for a great information. I have a question how it can be done with triple drop down list? For example I have to lookup from three columns. Lets say I'v got A, B, C drop list and in B will be two same text for example "Person1 and "Person1" but "A"will have different text (example A:Group1 for B:person1 and A:Group2 for B:Person1) for both persons in B. My point is, when I want to show in C list for person1 fromm group2, the formula shows everything included group1 person1 too. I want to have C list to be matched from A and B so it will show correct list for person1 matched on group1. I hope I did explained what I am searching :)

[ikemeneke]

Please how can we use this method on vba userform combo box?

[garrettdennard]

Is the same version of this video available for 365?

[kalebdickson]

Can not for the life of me figure out my COUNTA formula (matches your exactly) is returning K1, while my data goes to K37. It is returning $K$2:K1

[mirama]

Hello Smith!
Please make the same content for 365! My drop-down isn't working on 365 :-(

[ABellaLuna]

The first part, making the pivot tables was great - user friendly, simple.
The second part though, good grief - no real help for building the equations, too much assumption that you already understand what he is talking about. And the video is too blurry for me to read it to be able to make my own inferences.