👋 3 ways I can help you! 1) Free 30-minute Excel course (100,000+ students) spreadsheeto.com 2) Need to learn Excel, fast? Check out "Zero to Hero" (paid course) spreadsheeto.com/zero-to-hero/ 3) Busy? Hire me! spreadsheeto.com/excel-consultant/
Dude I saw one lady do this with a ridiculous compound match formula, then I saw another guy say that we had to use "xlookup" which doesn't even exist in excel 2016 or 2019. This video is the only one that makes sense. Thanks!
AMAZING!! Thankyou. I watched 3 other videos before this one and they didn't even mention naming the lists and they had a "filtered list" and I didn't need any of that! Thankyou!
Hi, I learn a lot from your tutorial thanks, man. but I have a problem I hope you can solve, is it possible to remove an item from the data validation list once used in the indirect method?
Thanks. I'm just having an issue cause the drop list I have has multiple words in cell, and with "," and spaces, which it doesn't allow me to do. Seems I have to simplify, or do something else. But this video does give a way better explanation than other videos. Thanks again.
Good Explanation. Thank you. I found that Excel can be broken into two or more views. IF you did that then you could put the info on a second sheet and show both at the same time further enhancing a student's ability to take your tutorial information and apply it in their real world. QUESTION: What about when you are inserting a Dependent Drop-Down List into an existing Table?
Dear Spreadsheeto. REgarding the multiple dependent dropdown list, can we do it for by row instead of column? if we see your video, you put the country name side by side, and the assistant name below the country. can we do the assistant names beside the relating country, and the countries in a single column? thank you
Thanks for showing me the easier option but here if we choose the second dependent drop and if I delete the first drop down, then it should delete the second dependent drop-down as well but it is not deleted automatically
this is helpful without using lot of formula....other videos were helpful too in another channel but problem there was XLOOKUP formula.....if we're using older version of window we do not have XLOOKUP so this video is very helpful if you do not have XLOOKUP or if you do not want to use lot of formula...simple technique to get same result..
Thank You for this short, but very informative and useful video, my Friend! Subscribed and liked!!! Tried out and it works good! I got, however, an issue where the sheets content not really so simple is. The range name has various limitation as i see, as well as the value can be quiet long. '0 - L4-CCI-01-00-Master Process' is the value for example i need to see as a value in dropdown. The named range prohibits whitespaces inside, to begin with digiti and else... It looks like according to video it works only if Value in indirect lookup range is 1:1 same as the related column name and no other way, for example column is UK and the indirect value in related range is also UK, but in reality it is never as easy as it is here. Sheet values may include symbols like ?, '' '', ' and so on, where formula is then complaining its wrong format. How would You suggest to deal with such names? Needs to be indexed? Thank You so much.
Can you please share how to do a dropdown that will change the values on the column ? Say Column A have diff number values and you wanted to have Selection 1, 2 ,3 on dropdown that each has a formula that affects those numbers in a column?
@Spreadsheeto if I wanted to remove the option already selected above how do I do it? For example in minute 06:28, you chose UK and when you were selecting the staff name you had the 3 options again instead of 2
How do I sync two drop down lists? I want to select one option from one list, and have the corresponding cell in the other list automatically populate. For example, if I select the common plant name, I need the scientific plant name to autopopulate in the other drop down list. Is this possible?
What if when someone change the first column's input, the select value has not reset. If there is a solution that help to reset the selected value when first dropdown changed, that will be absolutely fantastics. Thanks for your sharing anyway.
Hi! Is it possible to create a tutorial for my case? Where in multiple tabs (Finance, Marketing, HR, Legal let's say) I have the same Header list (People, Assets, Contracts, Systems), but with different data each list in every tab. I have tried using your method and it works in the first tab, Finance. But when I move to Marketing and trying to follow the same steps, when I am trying to rename the list, it will take the data existing under Finance: People, Assets etc. And not the new list under these categories. Is there a way to create multiple dependent drop down list for several tabs, where the header list is the same, but information under each of it is different?
But I have two columns Like Product1 Name1 Product2 Name1 Product1 Name2 Another sheet user select product, & I want to search all matches of names that belong to particular product. No names ranges allowed. Data validation acceptable formula only. Thanks ❤
How would you update values? For example, if I add new items to the range, dependent cells don't show anything. Most of the people in the comments judge other people's complicated procedures while this simple has a lot of problems and is not flexible at all.
Was hopeful this would work, but the INDIRECT for the second column doesn't seem to work. I'm wondering if its because I'm in Office 365 or something. Just cannot get it to want to read the adjacent cell, it only ever reads one cell in particular.
Hi, I followed this video for a project I am working for a local charity. My problem is that it doesn't work in every row it misses some and then starts again. I have 15 names in the first column dropdown and then say 20 items per selection in the first column. some seem to work fine and others don't bring up anything. Any idea? thanks
Has a more recent version deleted $ and replaced with r and c for row and column? I get R4C1. I tried deleting column and it gave me a warning but I got nothing in drop down..
What about for words more than 1word? I can’t get it right. For the 3rd range since the 2nd range has more than 6 words. Please help me with my project. Thank you
Please I need help, because I'm having a problem setting up a name range for a group if data , it works for some ranges but in other ranges it does not work , why would this happen????
This works for the first row only... but not when I try to apply it to other rows! I've tried SO MANY tutorials and formulas and methods and nothing is working!! I'm so frustrated
This is not working for me. Each time I try to do the Data Validation for the =INDIRECT($E2) I get an error. I have also tried this with Xlookup which I was able to get that to work, but it would not carry down the column.
👋 3 ways I can help you!
1) Free 30-minute Excel course (100,000+ students) spreadsheeto.com
2) Need to learn Excel, fast? Check out "Zero to Hero" (paid course) spreadsheeto.com/zero-to-hero/
3) Busy? Hire me! spreadsheeto.com/excel-consultant/
but how can we get rid of BLANKS? for instance @03:26
U are the only one who actualy explained that u need to delete the second dollar sign in order to work! Thanks man!
You are the only one who gave me the answer I need. All were using Excel 2021 and Excel 365
I was looking for how to drag the dependent drop down for many days, but you solved it in a very simple way. Thanks 👍
Amazing video. I searched multiple drop-down lists on UA-cam. Literally, this is the simplest and most useful one. Thank you very much.
ya, this is the easiest way.
Exactlyyy!!
Dude I saw one lady do this with a ridiculous compound match formula, then I saw another guy say that we had to use "xlookup" which doesn't even exist in excel 2016 or 2019. This video is the only one that makes sense. Thanks!
Bless this, I’ve watched so many explanation videos and this was the only one that did it
Noone showed this in such an easy way! Thanks!
Wow! You taught the easiest and simplest way to create dependent dropdown lists among all the videos I watched. Thank you so very much.
OMG this is so easy! I watched so many videos that make it horribly complicated and they just don't work! Thank you! Got it the first time!
AMAZING!! Thankyou. I watched 3 other videos before this one and they didn't even mention naming the lists and they had a "filtered list" and I didn't need any of that! Thankyou!
perfect. quick and easy. pay attention to the details
Detailed explanation of the hierarchy selection. Very useful.
Thank you.
Glad it was helpful!
Such a lifesaver, out of all the videos I was trying to search for, glad I found yours, with clear and easier explanation. I appreciate, thank you~
This was an excellent tutorial ...clearly explained. Well done! works on Mac too.
I'm happy to hear that :)!
Is there a solution if there is more than one word to describe the range? The naming of ranges is limited to one word only
Saved my life bro, thanks a lot 😍😍
you made it incredibly easy, thank you!
Excellent tutorial, exactly what I needed.
Hi, I learn a lot from your tutorial thanks, man. but I have a problem I hope you can solve, is it possible to remove an item from the data validation list once used in the indirect method?
Thanks. I'm just having an issue cause the drop list I have has multiple words in cell, and with "," and spaces, which it doesn't allow me to do. Seems I have to simplify, or do something else. But this video does give a way better explanation than other videos. Thanks again.
Thanks alot. May Allah bless you.
Fan from Malaysia
Thanks, man, You just made it too simple!
Thankyou your way of teaching is very easy
Awesome function! This is going to help me tremendously
Very simple and easy.😊
Good Explanation. Thank you.
I found that Excel can be broken into two or more views. IF you did that then you could put the info on a second sheet and show both at the same time further enhancing a student's ability to take your tutorial information and apply it in their real world.
QUESTION: What about when you are inserting a Dependent Drop-Down List into an existing Table?
Bro... thanks a whole lot for this. Easy and straight forward.
Excellent, Excellent and only Excellent .Great Respected Sirs.
Simple, easy and useful. Happy to subscribe your channel. LOVE
Thank you very much
Its working and you made it very simple
Great video, it saved me a lot of time.
I used the =INDIRECT($A2) just like you did but it's not bringing the drop down for the staff. What could be wrong?
Were you able to figure out what was wrong
For some reason, you need to select cells from top do bottom. When I tried to do it from bottom to top id didn't work.@@jasmohitwaraich4873
Was there a solution for this? Mine also does not work when I used the =INDIRECT($A2)
Dear Spreadsheeto. REgarding the multiple dependent dropdown list, can we do it for by row instead of column? if we see your video, you put the country name side by side, and the assistant name below the country. can we do the assistant names beside the relating country, and the countries in a single column? thank you
This is exactly what I was looking for. Thanks a lot for this tutorial sir!
THANK YOU!
You're welcome 😊
Thanks!
The second part isn't working for me I'm doing it exactly the same way but not working
Thank you very much :-) It's working and very helpful.
This is excellent. But I have 3 dropdowns and I need the second one to be not affected by drop down 3
Thanks for showing me the easier option but here if we choose the second dependent drop and if I delete the first drop down, then it should delete the second dependent drop-down as well but it is not deleted automatically
Got new thing to learn. Thank you!!
this is helpful without using lot of formula....other videos were helpful too in another channel but problem there was XLOOKUP formula.....if we're using older version of window we do not have XLOOKUP so this video is very helpful if you do not have XLOOKUP or if you do not want to use lot of formula...simple technique to get same result..
Saved my day, thanks, very appreciated :)
Very helpful thank you!
This is such nice tutorial
Thank you!
and Finally sb with a sensible way!!!!! merci beaucoup
Great job explaining this.
Thank You for this short, but very informative and useful video, my Friend! Subscribed and liked!!!
Tried out and it works good!
I got, however, an issue where the sheets content not really so simple is. The range name has various limitation as i see, as well as the value can be quiet long.
'0 - L4-CCI-01-00-Master Process' is the value for example i need to see as a value in dropdown. The named range prohibits whitespaces inside, to begin with digiti and else...
It looks like according to video it works only if Value in indirect lookup range is 1:1 same as the related column name and no other way, for example column is UK and the indirect value in related range is also UK, but in reality it is never as easy as it is here. Sheet values may include symbols like ?, '' '', ' and so on, where formula is then complaining its wrong format.
How would You suggest to deal with such names? Needs to be indexed?
Thank You so much.
Does not work on Office 365 in 2024. Not on my PC anyway. I have done this like 6 times, starting over fresh and the resulting pulldown does not work.
Can you please share how to do a dropdown that will change the values on the column ? Say Column A have diff number values and you wanted to have Selection 1, 2 ,3 on dropdown that each has a formula that affects those numbers in a column?
Thank me it unlocked me from a corner.
@Spreadsheeto if I wanted to remove the option already selected above how do I do it? For example in minute 06:28, you chose UK and when you were selecting the staff name you had the 3 options again instead of 2
excellent vid, so well explained and easy to follow. Thank you
Great. Thanks
Nicely explained 👌
Wonderful n easy 🙏❤️👍🎉😍
Hi! Am I able to create a drop down list pulling data from different tables not side by side of each other?
Very nice tutorial!!!
How do I sync two drop down lists? I want to select one option from one list, and have the corresponding cell in the other list automatically populate. For example, if I select the common plant name, I need the scientific plant name to autopopulate in the other drop down list. Is this possible?
Thank you
What if when someone change the first column's input, the select value has not reset. If there is a solution that help to reset the selected value when first dropdown changed, that will be absolutely fantastics. Thanks for your sharing anyway.
Nice Presentation, Thanks.
Hi, what's about you would like to choose USA or UK? thanks
very helpful ! thanks
Hi! Is it possible to create a tutorial for my case? Where in multiple tabs (Finance, Marketing, HR, Legal let's say) I have the same Header list (People, Assets, Contracts, Systems), but with different data each list in every tab. I have tried using your method and it works in the first tab, Finance. But when I move to Marketing and trying to follow the same steps, when I am trying to rename the list, it will take the data existing under Finance: People, Assets etc. And not the new list under these categories. Is there a way to create multiple dependent drop down list for several tabs, where the header list is the same, but information under each of it is different?
But I have two columns
Like
Product1 Name1
Product2 Name1
Product1 Name2
Another sheet user select product,
& I want to search all matches of names that belong to particular product.
No names ranges allowed.
Data validation acceptable formula only. Thanks ❤
How would you update values? For example, if I add new items to the range, dependent cells don't show anything. Most of the people in the comments judge other people's complicated procedures while this simple has a lot of problems and is not flexible at all.
Perfect, thanks
Could you explain the indirect() function in more details pls.
Thanks for the suggestion. I will consider this for another video :)
Was hopeful this would work, but the INDIRECT for the second column doesn't seem to work. I'm wondering if its because I'm in Office 365 or something. Just cannot get it to want to read the adjacent cell, it only ever reads one cell in particular.
Hi, I followed this video for a project I am working for a local charity. My problem is that it doesn't work in every row it misses some and then starts again. I have 15 names in the first column dropdown and then say 20 items per selection in the first column. some seem to work fine and others don't bring up anything.
Any idea?
thanks
thank you so much
Is there way to do this with the name of the list being a number? Excel seems to only like letters and not numbers.
thank you sooooosoooo much!!!
Drop downs cannot be used within the Forms function. Do you know of any way to remediate that? Their support says there is no fix in the near future.
Unable to get this when tried with indirect formula, any setting to be changed, pls let me know
Great job
Has a more recent version deleted $ and replaced with r and c for row and column? I get R4C1. I tried deleting column and it gave me a warning but I got nothing in drop down..
Super .....................................🥰
What about for words more than 1word? I can’t get it right. For the 3rd range since the 2nd range has more than 6 words. Please help me with my project. Thank you
Hi I have one main category but 2 sub category how to create the drop down
very cooooooooooooool. Thank you very much :)
Superb!
Please I need help, because I'm having a problem setting up a name range for a group if data , it works for some ranges but in other ranges it does not work , why would this happen????
You are great
This does not work if the data I want to show in the second level is on another sheet of the same file. Any hint how to solve in this case?
This works for the first row only... but not when I try to apply it to other rows! I've tried SO MANY tutorials and formulas and methods and nothing is working!! I'm so frustrated
SAME! I'm going round in circles trying 12 different ways, none of them work
This is not working for me. Each time I try to do the Data Validation for the =INDIRECT($E2) I get an error. I have also tried this with Xlookup which I was able to get that to work, but it would not carry down the column.
The step at 2:30 does not work. Every time i get past the error message, the second drop down is empty rather than having its values.
how does this work when your options are on another sheet?
How can I quickly do this for something with 1000 fields? I can't possibly name all of them
in first example, I have a huge date, but I can not reach rows number 1974.
Thanks
What happen if country is from two words?
easy,tq Sir
I have done every step of this video multiple times. It DOES NOT work. The dependent drop down list never populates. Ever.
Navn fra liste vis række med input ud fra det valgte hvordan gør man så lige det
Awesome
your explanation and functions never work with me😔?!