Dependent Drop-Down List with Data Validation in Excel

Learn how to build a template with drop-down lists, using Data Validation to cell range, named range and INDIRECT reference to a value in a cell (Dependent Drop-down List).