Excel Forum

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.