This video demonstrates how to create dynamic dependent drop-down lists in Google sheets. This video will be useful to you if you are asking the following questions:

How do I create a dependent drop down list in Google Sheets?
Can you do drop down menus in Google Sheets?
------------------------