Excel Forum
Similar Content
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
Add a Drop Down Menu to a Cell in Excel - Data Validation Macro
Macro: Add a drop down menu or list to a cell in Excel with this free Excel macro. This is a grea...
Make Quick Lists for Drop Down Menus - Save A LOT of Time
Tutorial: Quickly make data validation drop down lists (menus) in Excel. This method is simple, onl...
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 Magic Trick 550: Data Validation List Drop-Down Based On 2nd Data Validation List Drop-Down


See how to create a Drop Down List that is based on another drop down list using there features:
1)Data Validation List
2)Defined Names
3)Create Names From Selection
4)INDIRECT function
5)SUBSTITUTE function
Drop down based on Drop down list
Data Validation based on another data validation
Dependent Data Validation





Got a Question? Ask it Here in the Forum.