Excel Data Validation using Dependent Lists

Using Dependent Lists is an excellent trick that allows you to input information in Excel faster and with more precision thanks to the data validation functionality.

[BegurKailash]

very clear way of explaining so that the concept is understood even by those who are unable to grasp at the first instance can make it in one go.

[mr.hbhatia]

Thank you so much. This is the easiest formula around. Not sure why other people are complicating it.

[veniceangelicadimailig]

You helped us a lot. The technique to copy and paste and type the cell name was what we needed to get the results we wanted. Keep up the good work and post more educational and easy to understand tutorials. KUDOS!!!

[MrCromler]

such a perfect, brief, succinct, lucid and helpful tutorial. It requires a talent to explain something more or less complicated in such an easy to understand way! Thanks, man! Really great job!

[sushmagupta]

Very helpful video on dependent drop-down list.Thanks a lot sir

[tourismitaly]

Ciao Aldo, italians in fuga non esiste più come canale?

[moshigirl]

Thank you so so much...only video I have been able to follow and to get my table to work...only wasted 3hours :(

[jaydipjadav]

Thanks for the sort and simple solution

[peterscheid]

Excellent video. Clear and to the point. Thank you!

[nicolasmajdalani]

Amazing !!! amazing !!! thank you much !!!

[parimalgoradiya]

Very nice and useful video
Thank you for sharing

[Sachin]

Thnak u so much sir for valuable information

[petermackey]

Great video. Your next challenge is to make another level of dependent drop down!

[MomentumPGC]

Excellent, exactly what I was looking for. Thank you, such a great video, really easy to follow.

[gopalakrishnarao]

Thanks a lot very helpful and useful for the excel lovers/learners/addicts. Please send the playlist link

[harshas]

Thank you, helpful & easy to understand

[nelipottery]

this is great ... however how do you take it one level further? i.e. you have a third set of lists that you want to add (so in your example sales person will drive another set of lists - e.g the product type they sold? i use indirect again on salesperson and i get a error ("Source currently validates to an error. Do you want to continue") but no further info on error....

[jamesperry]

Nice. Thanks.
Do u have another video that can take both functions - DV & Indirect - to a advanced level ? Thank U.

[denisdomnik]

Hello I need ur help as I was using this formula in excel I am getting below error.

The Source currently evaluates to an error. Do you want to continue?

[ernestchan]

Thank you for the tutorial. How do you give an "error message" in the sales person column once the Sales Region column has changed. Lets say you changed North to South in the sales region but the Sales Person column remains the same. How could I show a warning message to ask user to check on both column because it doesn't match