Forum Discussion
Solved
Dynamic data validation based on another column in table
I'm trying to get the data validation (values from another table) dynamic, in a table and based on the value in another column. I manage to get all values from my other table in data validation us...
There are two way you can do it. Try the following ways.
- One way could be using some dynamic spill formula with hash # operator in data validation. See the attached file.
- Another way could be using name manager. But in this case you have to create individual name for each category. See the attached file.
Hi,
This functionality is called: Dependent drop lists. What you are looking for is a single level of dependency (simple) while you can create so many levels (I created up to 6 levels of dependencies using Dynamic arrays)
I presented about Dependent drop lists (your issue) at this event:
https://youtu.be/xgpQKd1Pukw
and Created much more powerful dependent drop lists in this YouTube Tutorial:
https://youtu.be/zbsqGjNbPKg
Hope that helps
Can you please add a sample file here?