Can the values in a dropdown menu be from a unique list?

Options

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:

Row1: Rick

Row2: Cait

Row3: Rick

In the column [Tests], I have the values:

Row1: A

Row2: B

Row3: C


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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!