Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Excel Lookup/Search Tip 6 - Vlookup with a Drop Down Menu and Data Validation


Learn how to use the VLOOKUP function in Excel in conjunction with a data validation drop down menu in order to create more logical and easy to use Excel spreadsheets. This allows you to use a drop down menu to supply the lookup value to the vlookup function in Excel instead of having to type the lookup value by hand. This reduces the amount of errors when searching a database and increases efficiency in Excel.
   Topics Covered
VLOOKUP() function in Excel.
Data Validation in Excel.
Drop Down Menus in Excel.
Search tables with lookup functions and formulas.
   Difficulty:         Intermediate
   Video:               Yes



Got a Question? Ask it Here in the Forum.