Make Multiple Dependent Dropdown Lists in Excel (Easiest Method)

Easily Create Multiple dependend dropdown lists in Excel.

In this video you'll learn how to create multiple dependent dropdown lists in Excel. This will include an XLOOKUP and data validation. Once this is clear, we'll also use the autopopulate feature that will change depending on your dropdown answers. We'll do this by combining the TRANSPOSE funcion with the XLOOKUP. FInally, we'll create an error check so the dropdown choices make sense. For example, if you select Europe as the region, it should only allow you to select European countries. For this we'll use the COUNTIFS and the XLOOKUP to make an error check, alongside a conditinal formatting to make it stand out.

LEARN:

SOCIALS:

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Single Dependent Dropdown
3:38​ - Multiple Dependent Dropdowns
5:50​ - Autopopulate Dropdown Results
7:51​ - Bonus: Error Check for Dropdown Choice

[musamaiza]

Your videos makes excel easier for me.
Thanks kenji

[putrakamangpu]

Thank you for the very useful knowledge🙏🙏

[foxyturbine]

This was super helpful, and a much easier way! Thank you so much!!

[vsrkvaraprasadraju]

I'm Becoming Pro by learning through your videos 👍

[Iriponpal]

I have learned alot from your videos ❤

[m.m.basetolimishkat]

Hello Kenji. This is a very helpful video. I am wondering if can we use spin button from the developer tab instead of drop down list. For example: the first spin button will spin Region and the second spin button will spin only those Countries of a Region selected by first spin. Thanks

[colewest]

How would you do a dropdown but with different formulas ?

[coastalb]

Word of caution. I updated a file with validations for drop downs and used a transpose formula. The file is used by a team in 3 geographically different places, soon to be 4 and must be shared. The transpose formula “breaks” the validation in one column because it is a shared file. Will update it with one of your suggestions to select horizontal selection for the validation. Thanks!

[michele_alioto]

by far, this is actually the easiest and fastest way.

[ENDTIMEHOLINESSREVIVALMO-dfxx]

Hi iam using excel 2016 and always having trouble when making dropdowns instead of words in dropdown go down one by one but instead they are all in one place

[chidinduuwaeziozi]

We could use a custom data validation formula to ensure the right list is always shown instead of simply marking the wrong one

[EMiller]

That error check will only work for one particular cell, is that correct? How can I have conditional formatting based on a formula that checks each row, based on the XLOOKUP? In other words, how can I make that "XLOOKUP(D2, E2)" in the conditional formatting formula apply to each of many rows? In your example, it only works on that one cell.

[NANSOESOESOEKAY]

My Xlook up correlated data doesn't appear as shown, and it only appears for one data in a cell, not all of its data in a table.

[EffigyOfAdam]

Doesn't work on 365. As soon as I get to the second Data Validation list it errors out "This entry leads to an error. Try entering different values to continue."

[MrNicho]

I have office 2016, =XLOOKUP(... ) isnt availlable, what can i do ?

[AbdulAbdul-bulr]

Why must we download a file to practice?
Why don't you teach us from scratch?

[abhaymundhra]

i am trying to do .this thing in excel online it not happening there like adding new formula to existing one trasnpose is not working help @kenji explains

[gwbqffo]

I have a question Kenji. Is there any such formula which can automatically separate the amounts of multiple items in one order id in the total amount column?
Order ID Product Qty Product Price Payment Mode Cash Amount Card Amount Total Amount
20240520213102 1 995 Card 0 8500 8500
20240520213102 1 799 Card 0 8500 8500
20240520213102 1 6795 Card 0 8500 8500