Excel Create Dependent Drop Down List Tutorial

[@JP-hg5pi]

Clear, simple and quick. Thank you very much! So much better than the microsoft instructions!

[@TEKNISHA]

Glad it helped!

[@SunshineTube87]

Very simple and easy that many people make it complex....Thank you!

[@TEKNISHA]

Glad it was helpful!

[@babydcac]

Great! Clear and simple. Thank you! 😊

[@prakashsathyapriya]

Crisp without unwanted stories. You rocks

[@gabrielnogales4407]

OMG greatest solution ever... just look the other solutions over there for this same problem... you couldnt be more efficient! u made my day :)

[@TEKNISHA]

Glad that this solution helped you. I have also made another version. You can check that too. kzbin.info/www/bejne/rqHLaKqoprNrh7s

[@golddiamond6782]

And finally it was the $ thing which was not allowing copying in the multiple cells.Thanks for sorting that out

[@TVSCDN]

Thanks for your simple uncomplicated explanations... ❤️❤️❤️

[@LabTechNajmal]

I am watching after 5 years of upload, thanks. It's useful

[@tourismhotspots]

Valuable video for learning creation of Category in Excel

[@christianjr3760]

Thank you very much my brother, this is what I have wanted to know since a month ago. 🙏🏾🙏🏾🙏🏾

[@chiragLakhmani]

TO THE POINT EXPLINATION , REALLY HELPFULL . TYSM

[@hvsmanian8948]

I learnt from your KZbin channel. Great. Good Teaching. This is the easy way.

[@shrikrushnajadhav2621]

I was confused for not getting dependent dropdown correctly, and you just tell exact reason of removing $ from column and cell number. Thank you.

[@foodkpk5719]

Sooo nice my dear. very simple thank you so much. you are a nice teacherrrrr

[@rollingthunder4599]

Liked your video, just what I was looking for.

[@TEKNISHA]

Glad that this Helped

[@shayarjiinfo5404]

❤ thank you so much man You Made my Day

[@mohanlhamsaraj4053]

Super quick explanation with systematic approach...

[@vickyvikneswari3956]

Thank you! I managed to create the dependent list in excel :D

[@TEKNISHA]

Awesome. Happy that this helped

[@jerrymilesmiles9313]

Outstanding! Hi from Limón, Costa Rica!

[@TEKNISHA]

Glad that you liked it

[@gloria770]

You are the best. Thank you.

[@TEKNISHA]

Happy to help!

[@jonaking3203]

Thanks for this. Very helpful.

[@thebmusproject]

Nice one! Thanks!

[@TEKNISHA]

You bet!

[@chinnababu8673]

I watched many videos but this is great ...

[@kavinduramanayake2166]

Very simple and easy ,hank you very much

[@dyandraap]

easy to learn, thankyou Mr. Teknisha~

[@ouzz_zz]

thats a good yet not much a sufficent application. you could use the Indirect with Match, Char and CountA to set the range of the second combobox.

[@mwendasilumesii9649]

Wow!!! Sorted out like 90% of the problem I had, now the second column upon changing the first one.

[@RUNNAIFY]

very quick and clear,tq Sir

[@mspraveen50]

Thanks you did it simple to explain. How to remove the blank in drop down? Instead of offset

[@Nicecomputertutorial]

Excellent bro

[@Xandonezz]

thank you! you solve my problem!

[@TEKNISHA]

Great. Glad that this helped

[@larsonfredrick2470]

Excellent ! Short & sweet and to the point.

[@TEKNISHA]

Thank you

[@jintalaban119]

Thank you very much Sir, very well explained and uncomplicated...

[@faheemJabbar-y2s]

you skip the video how dependent drop down list creates

[@surajitpradhan3032]

Thanks for it. It's working soo good.

[@TEKNISHA]

You are welcome

[@malamala9881]

Nice 😊👏👍teaching sir, tq for your support.

[@josemiguel2611]

Straight to the point. thank you !

[@rishipradhan3633]

Thank you Sir, video was really very helpful & easy to understand

[@TEKNISHA]

Glad it was of help

[@m.mukhtiarali6063]

it is so much easy. i really liked it.

[@Boony15]

Thank u buddy..its very use ful

[@anhnhatnguyet4628]

A drop-down list with 10 names. in line 1 choose name number 1, in line 2 do not show name number 1 because it was selected before. continue like that until the end. can this be done?

[@curlyrapunzel3380]

Yes, it can be done. You have to highlight the preferred column where you want the data validation to occur and apply the data validation in the column. E.g if you want the data validation to have effect in column D, you need to highlight the whole of column D and apply the data validation

[@pankajgupta9426]

Very helpful 👍 🙂

[@TEKNISHA]

Glad that this was helpful

[@josephdiingmajok7521]

Short but extremely helpful, thanks a lot.

[@TEKNISHA]

Glad that this helped you

[@kianasteph_]

Thank you so much! It was exactly what I need it.

[@TEKNISHA]

Glad that you liked it

[@rinleak5712]

Thank you so so much for this video

[@lakhbirsingh7009]

Short & excellent

[@SHIJUSASIDHARAN]

Great , Thank You very much , Hugs

[@TheGiorgioSol]

Very very good!

[@TValexTav]

Thank you, your information was very helpful, although I encountered some difficulties with titles containing multiple words (which I resolved by inserting underscores "_" between the words).

[@iikoconcept6647]

thanks for sharing!

[@sweetmac17]

After creating the table, can I delete the selections on the left where you highlighted yellow? Will it also delete thr selections if I delete them?

[@thebaldguytv1340]

great video! Direct to the point and very clear. Thank you!

[@TEKNISHA]

Glad that this Tutorial helped you

[@dadathelegend]

Thanks Buddy the video is very much useful for my exam purpose

[@ristab5678]

❤thank you very much. 🎉

[@jayantmarathe9100]

Excellent👍👍👍

[@TEKNISHA]

thanks...

[@82chandar]

Hi, Instead of dependent drop dow, can we get both fruit & vegetables in same list under names using expand & collapse. Eg: Fruit-> expand -> names & Vegetables -> names

[@ankitpathak3695]

Really thanks 👍🙏

[@sherko965]

amazing, excellent job

[@sudhakarjain1299]

Very simple explanation. Useful to me.

[@juliayeo812]

Thank you for the video! It definitely helped however I would like to know if I am able to select the 1st level and have the 2nd level automatically inserted on the 2nd level instead of having it as a drop down? Which means once I select the 1st level, I do not need to type out the 2nd level as I only have single text to display. 😊

[@TEKNISHA]

Glad that you liked it. Yes it is possible to pull the 2nd level text. For this you need to use a lookup method like index/match or vlookup. All your first level and respective 2nd level information needs to be in a table and then you can use a lookup method to populate the 2nd level based on the 1st level chosen

[@juliayeo812]

@@TEKNISHA oh no, I have not done those you mentioned before... I'm clueless! Can tou shed some advice here... thank you so much!!

[@edwinwong]

Brilliant! Thank you.

[@TEKNISHA]

Glad that it helped

[@sachinkishore4115]

Thank you bro. It is working.

[@aleena_binoy3386]

Thank you❤

[@wamzfuna2452]

I love this it is very applicable

[@TEKNISHA]

Happy that this helped you

[@Νίκοςλιακο]

Thanks for the Video. Also i want to ask you something in case that i have make an error with the selection of second list , how i could change the selection which created at first?

[@richardkwan2840]

Can you please searchable dropdown list that works for version 2019 or older

[@abhijitraul940]

Thank you so much sir...

[@bobbymartins7349]

Hi Nice Simple Vid but just to let u know I had issue going forward after removing both the $$ symbols, its only after I kept the 1st $ Symbol before ColumnG and removed the 2nd $symbol, i was able to proceed

[@thebesttechnical3608]

Supper explanation and very helpful

[@valerianovello7038]

THANKS FOR THAT VIDEO! PS: Für Dummies wie mich: Formel wenn Excel auf Deutsch ist = Indirekt :D

[@clark2847]

Can we do the data validation separately from data base into dofferent sheet?

[@jayanaidu7667]

Thanks for the video What if I have to chose only 3 options out of 5 in the drop down skipping a cell. Example 1 3 and 5 how do I do it

[@mazharkhadri5408]

Thank you so much for demonstrating the simplest way of doing this. Much appreciated. Keep up the good work 👏.

[@JamesJones-uk7zs]

Nice video, but the method of adding blank cells to the range in case of additional values is sloppy and doesn't presentation t well. instead make the named range dynamic by using an OFFSET formula and COUNTA

[@sandy17163]

Thank you so much...

[@TEKNISHA]

Glad that you liked it

[@3dpowercontracting445]

Thank you for the this video. How can i put the color automatically once i choose particular type? 😊

[@naboulsikhalid7763]

Great video, I need this tutorial for a personal project. Thank you

[@hiren1980able]

Thanks for sharing.

[@TEKNISHA]

Thanks for watching.. Hiren Patel

[@alvinfren6790]

thank you so much for your video & it does help me alot

[@kch3019]

Thanks for putting this up

[@TEKNISHA]

You are Welcome

[@JAYSONFERANIL]

not working

[@paulbotha2002]

Can the data be on a seperate excel book from the dropdowns?

[@h.ktraders2928]

Thanks Brother

[@TEKNISHA]

Happy that this helped...

[@Temprelaxe11]

Nice video, Good speed and time management. Crisp and clear...Thank you

[@TEKNISHA]

Thank you...

[@jonobugs]

Maybe I'm doing something wrong, but this list doesn't seem to be dynamic. Rather it seems to look at the cell you type for indirect for. So, that means the first one will be fruit and the second will be vegetables even if you select fruit again.

[@jeffreybean5466]

Encountered the same issue.

[@remoteflying]

Great video, other channels drag this on for 18 minutes. What if the first drop down had names with spaces? Like 'Green fruits" and "Orange fruits"? Named ranges cannot have spaces

[@TEKNISHA]

Thank you George. Check my updated video for the multiple dependent drop-down list. In this method you can use names with spaces. kzbin.info/www/bejne/rqHLaKqoprNrh7s

[@manojvishwas6062]

thank you

[@CharlieChopstixTV]

Very useful

[@jaychikhalkar2351]

Thanks sir u r great

[@Tamer-Courses]

first step of categorization xcel not accept

[@dhruvgupta8993]

try removing any spaces in the name, it will work

[@dhruvgupta8993]

after trials and errors it worked but instructions need to clear for audience, defining the name we can not have names with spaces, in data validation you can not select the entire columns but specific range.

[@Islamiclibrary128]

Thanks...

[@TEKNISHA]

You're welcome!

[@mtfvks]

Super Sir

[@TEKNISHA]

Glad that this helped

[@unitedworldcare9497]

Thank you so much

[@TEKNISHA]

You are welcome

[@intoqalbunahmad1731]

Really need your help

[@yashikayadav7149]

What is the short cut key to use drop down list??

[@mohammedashrafak1900]

Perfect!

[@ksyamsundar1111]

Superb

[@swaadcafe1730]

Thanks

[@TEKNISHA]

You are welcome Divya...

[@HimanshuSingh-sn8yw]

It gives an error for me. 'The source currently evaluates an error'. Method Does not work shows error after indirect step.

[@JimmiSTRATMAN]

Very good video, didn't beat around the bush but quick & easy with good instruction. thanks for sharing & will subscribe to your channel

[@TEKNISHA]

Thank you jim