May 17, 2024

Google Sheets: Create Dependent Dropdowns with a Formula

21K Views517 Upvotes
How to create a dependent dropdown list with formulas.
Important notes:
* You cannot have a formula in the Data Validation section for range/list
* You must have an output range/formula for every depe …
Locked
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
All Replies
Jun 2, 2024
Why not use the Indirect function?

First name the ranges appropriately then use Indirect to generate the drop-down and then point to it.


Last edited Jun 2, 2024
false
12657993985903711003
true
Search Help Center
true
true
true
true
true
35
Search
Clear search
Close search
Main menu
false