Google Sheets Use case
Dependent Drop-Down List in Google Sheets That Works on Every Row
Build a dependent drop-down in Google Sheets that works on every row and keeps working when you insert rows or add items. One helper formula, no named ranges.