Data Validation using Indirect Function leads to a concept of Dependent drop down list.
​
Refer the attached Sheet.