How to Base one drop down list on another in Microsoft Excel

Excel dilettantes and seasoned Microsoft Office professionals alike may be surprised to learn that in Excel one can make a drop down list based upon a second drop down list (or, similarly, data validation list that is based on a second validation list).

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