Data Validation using Indirect Function leads to a concept of Dependent drop down list.
Refer the attached Sheet.
Last updated 7 years ago