Dynamic drop down list google sheets

1. How do you make a drop down list change depending on selection in Google Sheets?
2. How do I create a dynamic data validation in Google Sheets?

How do you make a drop down list change depending on selection in Google Sheets?

Select “List From a Range” in the drop-down box and then enter the cell range containing the list items that display from the INDIRECT function. Check the box for Show Dropdown List in Cell, complete the invalid data and appearance settings per your preference, and click “Save.” You can then give your lists a test!

How do I create a dynamic data validation in Google Sheets?

To do that, go to cell B2, then go to the menu Data > Data Validation. Set the criteria range E2:E10 and voila! Your dynamic drop-down list in Google Sheets is ready.