#data-validation

Create Google Sheets dependent dropdowns with FILTER, helper ranges, and reliable validation for changing lists.

Build dependent dropdown lists in Excel with INDIRECT or dynamic arrays, from two-level choices to three-level cascades.

Create dropdown lists and validate data in Excel. Step-by-step guide to data validation rules and error alerts.