MS Excel - Dependent Dropdown List

[@TutorialsPoint_]

To Get Certification, Click Here: bit.ly/38Jyu3p Use coupon "KZbin12" to get ‘’FLAT 12%’’ OFF at Checkout.

[@namithalokesh8166]

The best tutor I've ever come across. Kudos to you. Always on point, no dragging, simple explanation. Thank you very much

[@prakashsrinivasan7840]

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 🙏🙏🙏

[@echofunks]

you people have all the tutorials i ever need for excel great videos

[@nikhils6042]

I read a million blogs and it shows the weirdest ways to build out this mechanism, this was sooo simple

[@yourharbour3450]

Here is another indian hero saving the world. Thank you so much

[@SalinSharma-y9z]

Went thru many videos to get this done conveniently. Everyone was using complex combinations for this. But this was so simple. Thank you. Subscribed.✅

[@9871578881]

Excellent video without any nonsense...Thanks !

[@shrikantkirwale9339]

simple ...to the point ....value for your time and need ....no cliche....👍👍

[@kerrianreid5690]

You are an excellent teacher! You make everything so straightforward! Thank you. Feb. 6, 2021

[@shubhamsaurabh4092]

This channel is gold.

[@sajjadkhan-vm6hj]

He is an excellent teacher for Ms. Excel.

[@vonjamarfetalino3949]

This is the best way I have seen about this topic... Thank you!

[@AbdullahAbdullah-yz7tx]

Bro, You are a great teacher. Lot of love

[@sanjaygiri6862]

Sir aap jo b pdhate ho sbkuch achhe se clear ho jata h

[@omarsabdani8830]

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.

[@RA-rh5lb]

Thanks for your simple way of explaining . One of the best excel trainer in English.

[@PD_incredible]

Incredible tutor, brilliant explanation - very precise and clear. Thanks a lot.

[@jloo1900]

Best and shortest explanation. Brilliant and Big Thanks

[@emmanuelsia8209]

This guys explanations are so smooth

[@codwithfauj]

Pleasant way of teaching. Brief and clear. I have been searching for this for quite sometime finally found a good teacher. 👍🏼

[@mammenjohn2179]

Very nice and clear to the Points. Well simplified and nice presentations. Keep it up !! Good Luck !.

[@louisefarlow9808]

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.

[@real1083]

Excellent work

[@venumada]

Explained in very simple terms.

[@anwaraboobacker9531]

Thankyou somuch,So Informative,Love from Saudi Arabia.

[@asadsadiq2804]

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.

[@BhupendraKumar-mh3lg]

Sir can you explain me again. I am unable to apply this.

[@munnatbabu6905]

wow best teaching style i have ever seen...thank u sir

[@AkhileshYadav-ng2mm]

Thank you so much, I was looking to find exact solution & thanks for explaining it so well

[@RA-rh5lb]

I have followed as you showed and it works..

[@rahulnavale8160]

Super video sir.. no one can teach with this simple with indepth details.. thanks a lot

[@sovanmahapatro]

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.

[@pradip331]

Your learning methods are ousam. I like it 👍 Keep it I learn from you all

[@teams222]

Easy to understand, good teacher 👍👍👍

[@sandeepkumarsaral6787]

Best explanation ever i seen...

[@burhanakhtar1]

Love you tutorial point....I prefer your video instead of others

[@abhishekchris4854]

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

[@thebosslady5301]

Great Teaching, in short time, clear, precise n up to the mark!..

[@kantiyasagar4725]

Very nice , helpful & well explained video

[@arks2012]

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.👍👍

[@godavariindustrialsolution573]

Thanks! Learnt Drop down today.

[@ShahzadAhmedKhan0660]

Very Short & Excellent...... 👍

[@constanceenon6289]

Thanks for making it simple and Precise. I appreciate you 👍🏼

[@sadafkhan5235]

Thanks alot... This really worked for me....

[@shekharroy703]

Nice... I hope u will teach us in a very simple language as usual. Thanks a lot..

[@sabirrehman8733]

perfect sir, amazing and very easy steps with cool accent .. thanks and good wishes

[@farkhundadorin3045]

very much useful & so easy demonstration!!

[@faizanhussain2857]

Brother you are doing an excellent job.. I have learnt a lot of functions from your videos...

[@rohithsh007]

thanks a lot for sharing this. You were really great to put this in such a short span of time.

[@kamdarchoudhary4515]

Excellent… I have a question you just make it only for one row, If want it more then one then what is the procedure, Pls advice waiting for your reply

[@gauravgagrawalandco4386]

Very much helpful really liked it. 👍

[@bipashad3714]

Very useful informations, thanks for sharing such a beautiful video

[@dytjayasinghe]

As usual Short & Sweet.!🤗

[@rctprivatetuition]

Thanks for making it simple and Precise. I appreciate you

[@georgeroro4693]

simple way you have given us. thanks

[@adhikesavankesavan30]

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

[@Tahirkhantk81]

Excellent and very easily understood, thank you very much

[@AshrafZaman-qm8md]

Nice tutorial. Can I make it vice-versa, that is if I select the city name from drop-down menu, will the corresponding country name selected automatically?

[@ansh551]

Thank you. Nice and very helpful tutorial

[@VjayJadhav]

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.

[@Tec-canada]

Extremely helpful - thank you!

[@brightagbenyo678]

Thanks for the tutorial, well self explanatory. Thanks very much and also wish if you can do the same in vba.

[@pradeepkumara3793]

Excellent example and speech. Thank you

[@ShekharTalukuVenkannaiah]

You have made it look so easy thank you

[@balajik9805]

Really a nice information...I have a doubt Is it possible to list the countries name in a single column then u will apply the indirect formate?

[@dharshiniisenthilkumar976]

Thanks a lot... It's short and clear

[@statesticsandanalyses6348]

Very nicely explained. 👍👍👍 Hope this will help me in my work.

[@sanndeepverma5005]

Very clearly mentioned

[@murthysurya8098]

Easy way to understand , helped me lot

[@sagarmachivale3153]

Sir ,you are the best teacher .. But sir please make a 1 video on shortcut keys

[@hiteshapatel9989]

thank you!!!! this was made so simple!!!! love it

[@RaviKumar-jq3dh]

Great tip. I was looking for it.

[@byone9355]

Thanks a lot , you saved my time !

[@PartTimeTrader2024]

Great learning sir

[@arunchinnasamy1683]

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 ......

[@mhtplayz3948]

Very smart class!!

[@wajidnawaz6014]

Great video. Although I am curious as to whether this can be done across a vertical list? Thanks 😊

[@r.c.t.privatetuitionrct5209]

same question ....have you found about this solution?

[@adoniswalk]

To add more data to the list so that the list expands is there a special formula? Great video! Thank you

[@alistairgene]

This is FANTASTIC!

[@hanilathermadam5973]

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?

[@ujjalMsubba33]

Keep doing what you doing!.

[@venkatasurendranadh.K]

TQ BRO EXPLAINED DETAILED.

[@MyMediaKH]

Good teaching, I like this.

[@Muruganrenganathan323]

Dear bro many time i seen you chennal goos explaination nice very well. And i have one doubt...that one I have 5 pages in work sheet so i need one heading in first 2 page and balance 3 page need diffrent headding... how to create.. you can understand...my question.. ? If you not understand pls ask in comments box..

[@asharsumari9313]

love your tutorial.thumbs up

[@DineshKumar-ss5ve]

Well explained. Thank you

[@sajidjasnaik]

Nice explanation 👍

[@vivekabharathigvt8631]

Thank you. This video is amazing and simple than other videos in KZbin. 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?

[@diobelys1992]

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.

[@diego5130]

@@diobelys1992 I keep getting "a named range specified cannot be found" after doing =INDIRECT +...??? searched the internet couldn't understand anything

[@kiranholla5102]

I too got same error

[@Nini-sd9it]

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 😊

[@kaustubhjadoun]

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.

[@Asifiqbal138]

Excellent way of presentation. Weldon bro. Keep it up 🙂

[@sunnykolkata]

You are the best !!!!!!!!!!!

[@apsmusicislifeline6156]

Thank you.. the video was very helpful..

[@osmankhalidmohammed]

really helpful, many thanks.

[@olooalfredo]

That was so simple. Thank you

[@mkd6417]

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)

[@sharvansingh7345]

Thanks for this But if we want to dependent drop down with multiple entries for multiple countries in 1 sheet how can we do that...? Pls reply..

[@ayuashkumar3523]

Excellent video

[@Amirkhan-uk2up]

Thank you so much for this great help

[@deepakmr5307]

Awesome session.👍

[@Filza2012]

Thanks you so much I learnt new thing today with this.

[@MyAyna]

Thanks for your nice & easy tutorial on conditional dropdown list.

[@yrs743]

Sir, Nice explanation easy to understand Thanks Sir