Can the values in a dropdown menu be from a unique list?
I have a column, lets call it [Names]. And another column, [Tests]. Lets say I have 3 rows.
In the column [Names], I have the values:
In the column [Tests], I have the values:
Now Let's say I have another column (A dropdown), is there a way I can do an index formula where I type in Rick, and then within the dropdown it will show "A" and "B" to select from?
Help Article Resources
Check out the Formula Handbook template!