Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)

Thanks a lot Leila for the video, awesome support!

Update this to take advantage of the newest excel formulas.

How can this be done with the filter function

How to make the same thing on Google Sheets? =)

Thanks. It helps me a lot.

plz let me know how to get around data validation dynamic

i have a question to ask. if i have a customers name and some repeated ones, so if i use the table, convert into table, then i can use unique function to get right amount of customer name, so i add any new name in a list it will appear in unique as well. ok now the question is if i use drop down data validation and create a drop down of names. but trouble is if a new name added it will appear in unique section but not on drop down. any help to make dynamic drop down which automatically update data validation

how to disable the second dependend dropdown list if the selcetion in the first is X

Excellent tutorial. Thank you. Thumbs up.

Is this office 365 formula, or can i use it in earlier versions too?

r u excel scientist ??

Where to start if one wants to learn all of this Office wizardry? I have basic knowledge and concepts of math/coding, everything you teach is understandable and easy to follow but do you have a course or something or one need to pay to Microsoft to get a certificate for Office Wizard 101?

Hey, when i paste special "Data validation" my drop down button doesn't work, it shows the formula in data validation but doesn't work and neither show any errors, when i paste the formula one by one, it works, any idea how to fix it? thanks

when I create the OFFSET and MATCH formula, I get a formula error.

Thank you for an informative tutorial! I had one issue and the issue was that if I selected "Productiviy Div" and then selected "Wen Cal" in Apps. After that if I changed "Productivy .." to "Utility ..", the apps cell did not become empty. Here's a VBA code to solve the problem
Dim previousValue As Variant

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
previousValue = Me.Range("K3").Value
End Sub

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Me.Range("K3")) Is Nothing Then
If Me.Range("K3").Value <> previousValue Then
Me.Range("V3").Value = ""
End If
End If
End Sub


Just replace K3 with A5 and V3 with B5

Why this is more hard than I can handle.

thanks. Very usefull

Thank you, This video is very useful.

please tell how to make this as searchable multiple dependent drop down list in excel

Thank you extremely Helpful

Hello, thanks for this but it's not working for me since my source data have space and i am getting error during data validatiin. Excel asking me tonuse delinted list

thank you very much for your amazing clear explanations.

I am really in love with you! can I have your contact address?

Hey Leila, top content but would need a third level :D

You're the best! I've learned so much from you, and I'm very grateful! Cheers from Costa Rica.

This is amazing! Thanks a lot!

How can you automatically search in a list of data based on the result of multiple dropdown lists?

amazing

Is there a better approach to this in 2023?
wheels churning

Watched a few videos and this was the first that worked, thanks!

Is there a good Excel vocabulary terms list . Say Refferance, Array, Match. Is there a practical source making these terms easier to digest?🤔

You are our Excel National Treasure. Apreciate you so much. Sometimes these formulas are so mentally overwhelming.

what would be the best way to get dependent list if the data is in tabular format
Personnel Level Position
Senior E8 CEO
Senior E9 VP Ops
Other E7 Program Director
Senior E8 CFO
Other E6 Manager

first drop down will be Senior/Other
based on our selection it should give a second drop down with E8,E9 or E6,E7 for senior and other respectively
and on selection of level E8 on third drop down it should give a list of CEO and CFO

thanks in advance

Great! However... I receive an error box in the data validation. It will not let me proceed. It asks me if I want to continue, but will not give me a yes box or apply box. 😡

Hi, I liked your tutorial on multiple dependent drop-down lists. I have a question. If I have two or more column's, can I copy the same formula for the other series of column's as well or is there another formula required?

Leila, Thank you! Using the Offset formula was the most clever way to solve the dependent drop-down lists issue I was struggling with. I even used Xmatch nested in the formula. Awesome!

WHY ARE YOU SO BEAUTIFUL LEILA..?!

There was a mass lay-off that happened in our company last month. Fortunately I was retained and the reason for sure is that I am better at Excel now and Learned Power Query and Power BI (for the last 8months) that I was able to create Dashboards which are appreciated by the management. Thank you Leila, your videos helped me A LOT! Next up, I am trying to learn SQL so I can access our SAP Data. I think I am going to pursue a career as Data Analyst/Engineer. If you can read this Leila, can you advise me of where should I focus on and what other things I should learn to achieve my goal - I am an engineering graduate but I found data analytics as a fitting job for me as I enjoy it. Thanks again Leila, God Bless You!

WOW - Leila - Thank you - you are an amazing educator and have helped me immensely - all the best to you in your life

IT IS NOT WORKING

You are a witch! 😄Thank you!

Very helpful, and now it's easy to grasp.
Many thanks. I enjoy how you educate and use your technique.

Hi, great video, thanks! Everything works for me except one thing: when I enter my function as MATCH($A2,$D$1:$D$4,0) the data validation prompt shows an error. When i input it as MATCH($A$2,$D$1:$D$4,0) it works just fine. This allows me for everything except the updated data validation dragdowns in column B as I need the dropdown in B3 to reference A3, not A2.

Any idea on how to fix this?

If we have dublicate Apllication for example Cell under Strex has the same value - Strex. It will appear in dropdown list two times. How can show only once Strex in dropdown

This seems to not work with tables, it works using the formula and F9, but when attempting do the dropdown list, it shows the value of the source info.

How about the same in google sheet? It didn't allow to paste formula in data validation

can you make a video on a dropdown list that works like this. If we select the division we must get the app, if we select the app we must get the division. What I mean is it should work both ways dependent.

great video! exactly what i needed. One question: currently if you input a value in one of the dependent cells, but change the independent cell, the value remains in the dependent cell, even if it no longer is "allowed" due to the new cell value in the independent cell. Is there someway to add a prompt or something to alert the user that it now must be changed..? cheers!