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...
Excel Date Filter Magic - Last Month, This Month, YTD & More + Awesome Interface
Tutorial: Learn to make a beautiful and intuitive date filtering interface for your data in Excel t...
Combine Data from Multiple Worksheets in Excel
Tutorial: The easiest way to combine and consolidate data in Excel. Simple method to combine data ...
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 774: Dynamic Data Validation AND Dependent Data Validation Together


Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
A great trick from http://www.contextures.com/xldataval02.html#Dynamic
To create a Dynamic Data Validation AND Dependent Data Validation Together using Defined Names, OFFSET function, INDIRECT function and more.





Got a Question? Ask it Here in the Forum.