Data Validation and Drop Down Lists With Vlookup Function | Excel Tutorial

This excel video tutorial provides a basic introduction into data validation and drop down lists. It explains how to use the vlookup function to retrieve data from a database or list using a drop down menu.

Top 30 Excel Tips & Shortcuts:

How To Move Multiple Rows & Columns:

Excel - Find and Replace Tutorial:

Excel Conditional Formatting:

________________________________________
How To Look Up Customer Data In Excel:

Excel Vlookup Function:

How To Create a Data Entry Form In Excel:

Multiple Dependent Drop Down Lists:

How To Show & Hide Formulas:

______________________________________
Relative & Absolute Cell References:

Lock Cells and Protect Sheets In Excel:

Excel Interactive Checklist:

Excel Pivot Tables:

______________________________________
YouTube Channel Growth Accelerator:

Final Exams and Video Playlists:

Full-Length Math & Science Videos:

[MoodyMooMoo]

Thank you, this was really helpful! I had never come across this before and was so confused, I thought the data validation was searching for the values not the VLookup! I understand now.☺️

[mahammadbabayev]

That is so helpful. In the simplest way explained and it is direct to the point. I wish there were many videos of you :/

[liana]

thank you so much, this video is very useful and simple to understand.

[lauragasparyan]

Thanks a lot. The video was very helpful.

[faizahluikasb]

Hi, the tutorial is very easy to understand. But how do I categorize the name with branch name? Let say, I wanted to select the branch, and then let it only display only the name list from the selected branch? How do I do that?

[daveyp]

Thanks, Mark Wahlberg, this was helpful.

[sravanthivk]

Thankyou soo much.you made it simply .

[michalischrysomalis]

Can I ask you something if you don't mind please?
I have a cell with 3 choices (by data validation) and i want to fill others cells automatically which also these filled cells can calculate numbers automatically.
For example, when I choose the first choice from the cell with the data validation, then another cell can calculate the sum of some cells automatically.
when i choose the second choice from the cell with the data validation then another cell (not the cell from the first choice)can calculate the sum of some cells automatically. 
I could send you a draft from this excel if you don't mind in order to understand it more clearly.
Thank you in advance

[hafizsanee]

Hi, i got some problem, if i change the name in dropdown list, the below data didnt change.. it only change after i click to the vlookup formula and press enter...

[etanmatt]

I’ve been looking for this for a long time. Thanks a lot! Big time