Tip #143_Excel

Excel (Advanced): Dependent Data Validation Drop-Down Lists

 

You can limit the choices in an Excel data validation list, by using named ranges and the INDIRECT function, to create dependent data validation lists.

 

Full tip: Advanced Excel tip