My friend, you made things very simple. I watched few videos and could figure out the second level dropdown. Now I can raise the levels of drop-down to any number. Excellent. I will be subscribing your channel also. Excellent.
Is there a way to remove the '_' in the names of the dropdowns of the first col as excel doesn't allow naming the headers of the tables without the "_". Please help!
Min 8, when you change Make from Hyundai to Honda, the Model and Color stay from your original Hyundai selections - Is there a way to automatically delete the Model and Color selections when you change the Make selection?
Great video btw, can you however solve the problem that you demonstrate perfectly towards the end when you go back and edit the Make but the Model and Colour cells don't automatically go blank. They need to otherwise is shows the wrong info. I'll update if i find a way. Thanks
@@mrinalinimustafee9415 A mix of conditional formatting, data validation with multiple lists and long rules did work eventually. I would send it if i had it still but I didn't actually use it after all as i couldn't rely on anyone to keep it updated with all the new data so it would of become out of date quick. Good luck, it can be done
I followed these steps exactly, but I get an error message when setting the dependent validation. Says the source results in an error. I’m not using any spaces in the naming of the lists either. Can you assist with this?
I had the same struggles. The mistake he makes is at 2:53, this must be a List/range =Make instead of typing the names as he demonstrated. The fix I found was to named the upper ranges first then you can make the cell A14 a data validation list with the range name =Make. Hope this helps.
i followed your way to make dependent lists, however lets say you decide to change the make of the car, it doesnt automatically change the dependent model. How can you make sure that if you change the make of the car, the model also changes automatically?
Hi, I've followed all steps and it's a success! You explain so easy and I've been looking through many videos until I found yours! Only trouble I'm having is that the formula doesn't copy itself. I've dragged and done copy paste manually but it doesn't work. Is there a fix? I can't add the same formula for all the rows I have individually haha, it's too many! Thanks
Hi. I like your explanation. But I'm encountering a problem. My data begins with numbers and it requires me to put an underscore before the name. by the time I'm to select my data for the next column, it does not seem to find matching data. Can you help me with this? I hope I was able to explain the situation. Thanks!
you might ve to remove the $ sign if you are draggin it down. If not it would not be dynamic and wont get multiple choices when you drag it down to different cells
What if in the first list, you have an option that is two words (like "Direct Materials") so when naming the ranges, the name has to match, right? Well, I get an error when I try to name a range "Direct Materials". What's the solution to this? (Trying to figure out if there's a way other than adding an underscore)
Can I use this for storage management? Here is the Idea For example I have 33 hats but each hat has a specific different number in them. I m lending this hats to my customers. But I want to know which customer has which number? Is it possible to do?
Naming the range of selected cells doesnt work in a 2003 excel....it's dropdown list in that space is a bunch of tables and converts my selection into a table and messes up my premade table and other work done.......
Couple of things, Indirect, I have seen will not work if you are choosing picklist with multiple words Like" White Hyundai" .. so may have to trim the space ? 2. Index and match is preferred I am advised if you have many drop downs 3. Is there a way to Reset the Color drop down when different Make and model of car is selected
Great, now if we have a scenario of different prices for each make, model and colour and based on the selection from the dropdown, How can we get the different prices?
Hi What if the dependent dropdown list is referencing numbers rather than text e.g product codes or SKU. I realized the dropdown becomes inactive. What is the solution?
Do you have video where If I select country 1 (from list of 10 countries) and then move to another drop down list to select country 3 (from list of 9 countries) where country 1 is not an option in this second list.
Great lesson. I made a dependent drop down menu. Now can I streamline this dropdown menu even further to simplify things for my customers. For example my customer doesn't care what make or model he wants all he cares about is that he wants his new car to be PURPLE (and in my example let's imagine there are numerous makes and models to choose from) my customer does not want to sift through all the make/model combinations until he finds a purple option he wants to choose purple first and then be offered the remaining make/model combinations that accommodate his color choice. Can the menus be adjusted to be interdependent...my customers can choose whatever make model color in any order they choose? Some want to start with color others want to start with model... Does my question make sense? Can you help me with this? Thanks!
If I need to extend this rule through an entire list (the dependent drowpdown column) How would I do so? Can I copy and paste data validation settings through cells?
I am struggling from the same issue because the copied 2nd column is actually getting depended only on one cell and not moving as we move along the rfows. Any solution?
Great video, but I have an issue with the range names. I need to be able to refer to ranges just like you to, but since the options are not one worded, like yours, it's all messed up. Is there any way to do this when having multi worded options and options with punctuation like "Big Orange" or "Orange-colored" instead of the one worded options in the video? The issue is that I really need to have options containing punctuation etc. but cant have ranges named like that...
Can anyone help?! I have 4 columns which are each dependent dropdowns on the previous column. I have my data (dropdown lists) organised on different sheets for ease. I want to know if you can use the offset function, but dependent on the selection made in the previous cell, can excel look to a different sheet. i.e. If I select 'X' from column 2 drop down, look here for the data to appear in drop down column 3, else look here....
Final Exams and Video Playlists: www.video-tutor.net/
You're a teacher for life dear!!
What a guy! thank you, I searched for hours to find this. I'm embarrassed as it's actually so easy to do!
Awe
Awesome, Thanks!!! After almost 3 years, still the best explanation about this issue
Past one week I watched at least ten videos on the subject. This is the easiest one.
This is 100 times easier solution then any I was trying last 2 hours. Thanks man!
worked like a charm!!! Thank you, my client is thrilled he can use this feature for his service reports.
My friend, you made things very simple. I watched few videos and could figure out the second level dropdown. Now I can raise the levels of drop-down to any number. Excellent. I will be subscribing your channel also. Excellent.
Clear and easy to understand - A good teacher👍👍👍
Perfect. That's what I was looking for!!! Thank you mate.
Thank you man. I've been looking for this thing from hours.
You are the man!! Finally, I can complete my reporting with the correct drop down list options.
This helped one of my end users. Thanks!!
you made my life easier! thank you!
Very useful in our day to day activity. Very well explained.
Got it after a bit of struggle ! Thank you !
Thanks for your teaching 🥰
i want like this video 1000times
Excellent teacher ... Thank you 😀
Thanks for explaining it in an easy way. Further if I have to copy this on every row in the sheet then how to do it>
I'm having the same issue. How to get this to work on multiple rows. Did you get a solution?
Nicely explained, easy to understand
Thankyou
you are life saviour! !! thank you!
Very well explained. Thank you so much i desperately needed this formula
AMAZING! You just made me a lot of money! Thank you very much!
Thank you very much, you saved my day with this tip.
Thank you 🎩
Thanks a lot sir, for this Informative video.
This helped me alot
Is there a way to remove the '_' in the names of the dropdowns of the first col as excel doesn't allow naming the headers of the tables without the "_". Please help!
I see you left this comment 7 months ago with no reply. Have you figured it out? Because I'm looking for the solution as well.
@@vahidmacvandi1297 @AirSwimmer Use substitute function. Substitute(Select Cell here,"_"," ") this will replace _ with space and will work
Min 8, when you change Make from Hyundai to Honda, the Model and Color stay from your original Hyundai selections - Is there a way to automatically delete the Model and Color selections when you change the Make selection?
Thank you so much! Been struggling with this for quite some time.
Thanks so much. You have no idea how I've been trying to do this!
Question: Do you have to keep the cells you used to create the drop downs or can you clean up the spreadsheet and delete the data you no longer need?
Thank you very much 👍🏻👍🏻
Very helpful
Thanks for the video mate
wow - thank you for sharing. You explained and demonstrated that very clearly and simply. well done!
Thank you guy, I got what I looked for, you have a good explanation and easy way to show it, so subscribed in your channel.
It is really excellent unprecedented vedio
Thank you, thank you, thank you!!
Thank you so much for making this understandable!
Thanks, Simply explained, Great job.
You made it so easy,thank you
Thanks a lot , after 1 hours i got exact solutions , Really Thanks Sir
Thank you very much! Well deserved "like"!
Exactly what I was looking for Thank you!
Great content!!!!
Great video btw, can you however solve the problem that you demonstrate perfectly towards the end when you go back and edit the Make but the Model and Colour cells don't automatically go blank. They need to otherwise is shows the wrong info. I'll update if i find a way. Thanks
Have you found a answer for this? I'm looking for the same info. Thanks in advance
@@mrinalinimustafee9415 A mix of conditional formatting, data validation with multiple lists and long rules did work eventually. I would send it if i had it still but I didn't actually use it after all as i couldn't rely on anyone to keep it updated with all the new data so it would of become out of date quick. Good luck, it can be done
Great video, thanks
Thanks for the tutorial! It was far helpful to complete my dashboard
Very well explained!
Well done, well explained and easy to remember as not too complicated.
I followed these steps exactly, but I get an error message when setting the dependent validation. Says the source results in an error. I’m not using any spaces in the naming of the lists either. Can you assist with this?
I followed the tutorial exactly and I get the same problem. doesn't work.
I had the same struggles. The mistake he makes is at 2:53, this must be a List/range =Make instead of typing the names as he demonstrated. The fix I found was to named the upper ranges first then you can make the cell A14 a data validation list with the range name
=Make.
Hope this helps.
@@draw504 thanks bro it works
Thanks so much, it really helped. You explained it simple and nicely!
Thanks for the video. This was super helpful
Thanks for the video
Amazing, thanks for sharing this, it's not the easiest thing to do, but you explain it well! thanks :)
Can you delete those rows from 1 to 11? Or it would affect the dropdown list?
I love this 💞
WOW, that really helped me out. Thanks alot for such a wonderful teaching
Thanks for helping me out
Outstanding Tutorial. Thank you.
When a selection is made in each list and I change the selection of the first list, how do I set the subsequent lists to reset to blank automatically?
I have been searching for the answer to this as well. It seems that this is set to possible errors if changes are made to the first cell
I also want the same result
ua-cam.com/video/wWasYHG1lmM/v-deo.html
Very useful, Thanks
i followed your way to make dependent lists, however lets say you decide to change the make of the car, it doesnt automatically change the dependent model. How can you make sure that if you change the make of the car, the model also changes automatically?
Simply way of explaining
Best. Thanks.
Very nicely explained.
Thank you!!!
Hi, I've followed all steps and it's a success! You explain so easy and I've been looking through many videos until I found yours! Only trouble I'm having is that the formula doesn't copy itself. I've dragged and done copy paste manually but it doesn't work. Is there a fix? I can't add the same formula for all the rows I have individually haha, it's too many! Thanks
remove dollar sign ($)
Thank you!!!!! 🙏
nice video carry on
Is it possible to ensure that 2nd level selection gets auto reset to null if we select honda after setting hyundai sonata
can u mix/include drop down lists in words or paragraph?
thank you so much boss i need emergency buttons of how create ADD, Clear without formulas, Search,
NEXT, BACK by using macro
Hi. I like your explanation. But I'm encountering a problem. My data begins with numbers and it requires me to put an underscore before the name. by the time I'm to select my data for the next column, it does not seem to find matching data. Can you help me with this? I hope I was able to explain the situation. Thanks!
Is there any way how to copy this formula to a multiple amount of cells ? or should I write it manually in each cells ? Thanks
I have this question too - I thought I could drag and drop, but it's not working :(
Same here. I am struggling with this. Any solution?
you might ve to remove the $ sign if you are draggin it down. If not it would not be dynamic and wont get multiple choices when you drag it down to different cells
How does it work for list that has a spacing? Example full name etc
Add underscore between the names. E.g. Jerica_Soberano
Great video, really well explained. How would I add information to an existing dependant dropdown?
use name manager to re-select the table
What if in the first list, you have an option that is two words (like "Direct Materials") so when naming the ranges, the name has to match, right? Well, I get an error when I try to name a range "Direct Materials". What's the solution to this? (Trying to figure out if there's a way other than adding an underscore)
Did you find a solution for this?? Having the same problem
I am looking for his answer too
are these dynamic array functions still available, only on Office 365?
Can I use this for storage management? Here is the Idea For example I have 33 hats but each hat has a specific different number in them. I m lending this hats to my customers. But I want to know which customer has which number? Is it possible to do?
What I want to do is click drop down all numbers and choose the number of the hat I want to know and see who has that specific numbered hat
Naming the range of selected cells doesnt work in a 2003 excel....it's dropdown list in that space is a bunch of tables and converts my selection into a table and messes up my premade table and other work done.......
Couple of things, Indirect, I have seen will not work if you are choosing picklist with multiple words Like" White Hyundai" .. so may have to trim the space ? 2. Index and match is preferred I am advised if you have many drop downs 3. Is there a way to Reset the Color drop down when different Make and model of car is selected
Great, now if we have a scenario of different prices for each make, model and colour and based on the selection from the dropdown, How can we get the different prices?
Hi What if the dependent dropdown list is referencing numbers rather than text e.g product codes or SKU. I realized the dropdown becomes inactive. What is the solution?
How do i get this to work across multiple sheets in the workbook
Thank you
Do you have video where If I select country 1 (from list of 10 countries) and then move to another drop down list to select country 3 (from list of 9 countries) where country 1 is not an option in this second list.
Great lesson. I made a dependent drop down menu. Now can I streamline this dropdown menu even further to simplify things for my customers. For example my customer doesn't care what make or model he wants all he cares about is that he wants his new car to be PURPLE (and in my example let's imagine there are numerous makes and models to choose from) my customer does not want to sift through all the make/model combinations until he finds a purple option he wants to choose purple first and then be offered the remaining make/model combinations that accommodate his color choice. Can the menus be adjusted to be interdependent...my customers can choose whatever make model color in any order they choose? Some want to start with color others want to start with model...
Does my question make sense? Can you help me with this? Thanks!
What is the formula for colour. I am unable to get it kindly mention. Thank you in advance
If I need to extend this rule through an entire list (the dependent drowpdown column) How would I do so? Can I copy and paste data validation settings through cells?
I am struggling from the same issue because the copied 2nd column is actually getting depended only on one cell and not moving as we move along the rfows. Any solution?
This is a great tutorial!
could you please add 1 more column with dependent dropdown for the pricelist displays automatically?
Try this:
docs.google.com/spreadsheets/d/1J6RuqgrTgN5k_W-P4_Zy3OIwLUpM9sL3kUVKpeM9cZ4/edit?usp=sharing
Very useful
How you drag this dependent list in other cells? Simple drag only takes the last group
helpful.Thanks
THANK YOU! :)
Awesome! Thanks
Hi. I tried data validating for 2nd list and it didnt work for me. The =indirect isnt getting recognized. Is there any workaround?
Great video, but I have an issue with the range names. I need to be able to refer to ranges just like you to, but since the options are not one worded, like yours, it's all messed up. Is there any way to do this when having multi worded options and options with punctuation like "Big Orange" or "Orange-colored" instead of the one worded options in the video? The issue is that I really need to have options containing punctuation etc. but cant have ranges named like that...
Although it won’t be exact, one solution (work-around) is to replace spaces and periods with an underscore e.g. Big Orange would be Big_Orange
Can anyone help?! I have 4 columns which are each dependent dropdowns on the previous column. I have my data (dropdown lists) organised on different sheets for ease. I want to know if you can use the offset function, but dependent on the selection made in the previous cell, can excel look to a different sheet. i.e. If I select 'X' from column 2 drop down, look here for the data to appear in drop down column 3, else look here....