MS Excel - Dependent Dropdown List Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited Check out latest Video Courses and eBooks : www.tutorialsp...
"The Source currently evaluate to an error" this is the message I got when I try to use the "INDIRECT" Function for the drop down. However one of the drop down returns for me but the other does not
You r genius l know named ranges for past 20 years but don't know shortcut of creating multiple names at a time and also use of indirect function thank u very much hats off you 🙏🙏🙏
Hi. The INDIRECT thing is not working in the data validation for me. The error shown is “The source currently evaluated to an error” Can you please help
I have learned how to make dependent dropdown list from other Excel guru, but this is the simplest and the best so far. Thank you, your tutorials are amazing.
This is brilliant. You have explained every step and why you've done it, rather than just say do this then this. I've spent ages trying to do this today, your video helped in a matter of minutes.
Your Tutorials are awesome and crafted carefully for the audience to learn the steps perfectly and thoroughly. I am wondering how to apply this formula for multiple criteria's. Example, I want to have "List of Tasks: as dynamic dropdown when "Project Code" and "Category" is selected, and it should be on Every Row. @TutorialsPoint_ do we have any tutorial for similar scenario which I mentioned above.
Awesome your all the video on Excel are excellent and I have never come through to such a easy way of teaching I don't know anything about Excel and I'm able to understand and learn it from hear your videos great job sir
Thank you. This video is amazing and simple than other videos in CZcams. But when I practice it will fail. Error msg "The source currently evaluates to an error. Do you want to continue?" Sir What's the solution for this error?
It appears when the Origin cell, in this case the countries, has nothing selected. First you need to select something from the origin and then apply the formula to the dependent cell.
@@diobelys1992 I keep getting "a named range specified cannot be found" after doing =INDIRECT +...??? searched the internet couldn't understand anything
Hi. Either your first drop down is empty before adding indirect formula or your table has multiple names, go to table names, check there might be 2 names redirecting you to same table. Get these resolved, it'll work perfectly. Subscribe to my channel for more tips n tricks 😊
Hi, Do check if the table names have some special characters. Only 'underscores' are allowed. I faced the same error since one of my table name had a '/' in it. I replaced it with '_' and problem solved.
Sir You are an Ultra Amazing Technics about how to teach people in terms of any kind of mind, you can do very smoothly, Thanks a lot from my bottom of heart. God Bless You, Stay Healthy & Stay Safe.
Hi Friend you doing a good job. good simple easy clarity in your videos. very good. Here is my question how can I add alphanumeric in dependant drop down list in a simpler way?
Thanks a lot for this video ...... I have been looking for this kind of smart option to enhance our work... The way you teach is very good and easy to understand... Keep doing ......
While creating the name range for the columns with different number of values in each column you could face with an error. The workaround is to select the columns one by one and name them based on the top row. this is the solution.
@@sohailshaikh8670 To be honest I myself even did not understand what I tried to mean 2 years ago :D Tell me what is your problem may be I can help )) Actually everything works perfectly fine when while doing everything according to instructions in video.
This is exactly what i needed.. beautifully explained . Thanks. Sir, how to delete the header names that we provide by "Create from Selection" . I wanted to change header name however it also show the old ones ,so want to remove it from the top left hand corner section (Name Box i htink)
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "CZcams12" to get ‘’FLAT 12%’’ OFF at Checkout.
The best tutor I've ever come across. Kudos to you.
Always on point, no dragging, simple explanation. Thank you very much
"The Source currently evaluate to an error" this is the message I got when I try to use the "INDIRECT" Function for the drop down. However one of the drop down returns for me but the other does not
You r genius l know named ranges for past 20 years but don't know shortcut of creating multiple names at a time and also use of indirect function thank u very much hats off you 🙏🙏🙏
you people have all the tutorials i ever need for excel great videos
I read a million blogs and it shows the weirdest ways to build out this mechanism, this was sooo simple
Hi. The INDIRECT thing is not working in the data validation for me. The error shown is “The source currently evaluated to an error” Can you please help
Same
You are an excellent teacher! You make everything so straightforward! Thank you. Feb. 6, 2021
simple ...to the point ....value for your time and need ....no cliche....👍👍
Incredible tutor, brilliant explanation - very precise and clear. Thanks a lot.
Hello sir...when i am trying to apply the second step it's throwing an error. Please advise
Thanks for your simple way of explaining . One of the best excel trainer in English.
I have learned how to make dependent dropdown list from other Excel guru, but this is the simplest and the best so far. Thank you, your tutorials are amazing.
Explained in very simple terms.
Went thru many videos to get this done conveniently. Everyone was using complex combinations for this. But this was so simple. Thank you. Subscribed.✅
This is brilliant. You have explained every step and why you've done it, rather than just say do this then this. I've spent ages trying to do this today, your video helped in a matter of minutes.
Excellent work
Pleasant way of teaching. Brief and clear. I have been searching for this for quite sometime finally found a good teacher. 👍🏼
Very nice and clear to the Points.
Well simplified and nice presentations.
Keep it up !!
Good Luck !.
Excellent video without any nonsense...Thanks !
Super video sir.. no one can teach with this simple with indepth details.. thanks a lot
What a great teacher. I was looking for this formula for more than 3 weeks. Finally I got exactly what I wanted for. Thanks alot.
Sir can you explain me again. I am unable to apply this.
Wonderful thank you so much I was broken my head fr this one for such a long time finally I got to know how to do that with ur video.👍👍
Best explanation ever i seen...
simple way you have given us. thanks
Great Teaching, in short time, clear, precise n up to the mark!..
Sir aap jo b pdhate ho sbkuch achhe se clear ho jata h
This is the best way I have seen about this topic... Thank you!
Thanks for making it simple and Precise. I appreciate you 👍🏼
Best and shortest explanation. Brilliant and Big Thanks
He is an excellent teacher for Ms. Excel.
Very nice , helpful & well explained video
Very much helpful really liked it. 👍
Your Tutorials are awesome and crafted carefully for the audience to learn the steps perfectly and thoroughly. I am wondering how to apply this formula for multiple criteria's. Example, I want to have "List of Tasks: as dynamic dropdown when "Project Code" and "Category" is selected, and it should be on Every Row. @TutorialsPoint_ do we have any tutorial for similar scenario which I mentioned above.
Love you tutorial point....I prefer your video instead of others
Awesome your all the video on Excel are excellent and I have never come through to such a easy way of teaching I don't know anything about Excel and I'm able to understand and learn it from hear your videos great job sir
Here is another indian hero saving the world. Thank you so much
Bro, You are a great teacher. Lot of love
wow best teaching style i have ever seen...thank u sir
Very useful informations, thanks for sharing such a beautiful video
perfect sir, amazing and very easy steps with cool accent .. thanks and good wishes
Sir, I was more than one-hour spending my time segregating data but using this formula short out the data minimum time. thank you so much
Thank you. This video is amazing and simple than other videos in CZcams. But when I practice it will fail. Error msg
"The source currently evaluates to an error. Do you want to continue?"
Sir What's the solution for this error?
It appears when the Origin cell, in this case the countries, has nothing selected. First you need to select something from the origin and then apply the formula to the dependent cell.
@@diobelys1992 I keep getting "a named range specified cannot be found" after doing =INDIRECT +...??? searched the internet couldn't understand anything
I too got same error
Hi. Either your first drop down is empty before adding indirect formula or your table has multiple names, go to table names, check there might be 2 names redirecting you to same table. Get these resolved, it'll work perfectly. Subscribe to my channel for more tips n tricks 😊
Hi, Do check if the table names have some special characters. Only 'underscores' are allowed. I faced the same error since one of my table name had a '/' in it. I replaced it with '_' and problem solved.
All formula is working based on your video but while I am putting formula for indirect it show error of the source currently evaluates to an error
Sir You are an Ultra Amazing Technics about how to teach people in terms of any kind of mind, you can do very smoothly, Thanks a lot from my bottom of heart. God Bless You, Stay Healthy & Stay Safe.
Great tip. I was looking for it.
Thankyou somuch,So Informative,Love from Saudi Arabia.
This channel is gold.
If there are Countries, State and cities, how to apply Data validation? Please let me know.
Thanks! Learnt Drop down today.
thanks a lot for sharing this. You were really great to put this in such a short span of time.
Your learning methods are ousam.
I like it 👍
Keep it
I learn from you all
Easy to understand, good teacher 👍👍👍
Excellent and very easily understood, thank you very much
very much useful & so easy demonstration!!
Brother you are doing an excellent job.. I have learnt a lot of functions from your videos...
Very nice and helpful 😃
As usual Short & Sweet.!🤗
Hi Friend you doing a good job.
good simple easy clarity in your videos. very good.
Here is my question
how can I add alphanumeric in dependant drop down list in a simpler way?
really helpful, many thanks.
TQ BRO EXPLAINED DETAILED.
Great video. Although I am curious as to whether this can be done across a vertical list? Thanks 😊
same question ....have you found about this solution?
This is FANTASTIC!
Nice... I hope u will teach us in a very simple language as usual.
Thanks a lot..
thank you!!!! this was made so simple!!!! love it
Thank you so much for this great help
love your tutorial.thumbs up
Very Short & Excellent...... 👍
wow you made it seem easy that's nice thanks
Thanks a lot for this video ...... I have been looking for this kind of smart option to enhance our work... The way you teach is very good and easy to understand... Keep doing ......
I have followed as you showed and it works..
Thanks for making it simple and Precise. I appreciate you
This guys explanations are so smooth
Great learning sir
Well explained. Thank you
Thank you. Nice and very helpful tutorial
Dependent drop down list in case of numbers, both list consist of number what will do?
Extremely helpful - thank you!
Very nicely explained. 👍👍👍
Hope this will help me in my work.
Thanks for your nice & easy tutorial on conditional dropdown list.
Easy way to understand , helped me lot
Very smart class!!
VERY CLEEEEEEEEEAN EXPLANATION. WOW.
Excellent example and speech. Thank you
While creating the name range for the columns with different number of values in each column you could face with an error. The workaround is to select the columns one by one and name them based on the top row. this is the solution.
I had a similar issue until I tried your solution. It worked! Thanks mate! ✌
Not understood please can you explain
@@sohailshaikh8670 To be honest I myself even did not understand what I tried to mean 2 years ago :D Tell me what is your problem may be I can help )) Actually everything works perfectly fine when while doing everything according to instructions in video.
Thanks a ton... thank you very much.....was just looking for this indirect function....you have made things just very simple.
Good work brother. Very well explained. Thank you very much
Thanks a lot , you saved my time !
You have made it look so easy thank you
You are the best !!!!!!!!!!!
Keep doing what you doing!.
Thanks alot... This really worked for me....
Thanks a lot... It's short and clear
Sir ,you are the best teacher ..
But sir please make a 1 video on shortcut keys
Thanks you so much I learnt new thing today with this.
Sir,
Nice explanation
easy to understand
Thanks Sir
U da Besssssttttt ı have been looking for this all-day! Thank you thank you thank you!
This still hasn't worked for me, after using indirect function inside the data validation source, the cell does not open up as it should. Any help?
@@ifeanyiadika6871 same here.. didn't helped me out..
This is exactly what i needed.. beautifully explained . Thanks. Sir, how to delete the header names that we provide by "Create from Selection" . I wanted to change header name however it also show the old ones ,so want to remove it from the top left hand corner section (Name Box i htink)
Very clearly mentioned
Nice explanation 👍
Thanks for the tutorial, well self explanatory. Thanks very much and also wish if you can do the same in vba.