How to Create a Dependent Drop-Down List in Google Sheets
By using a drop-down list, you can make data entry more efficient and error-free. You can also create a dependent drop-down list in Google Sheets so that the first list choice determines the options for the second.
Source: howtogeek.com