Creating a dropdown list from values in a column on another sheet
I am trying to create a simple dropdown list of values to select from a customized list of values in another sheet. This list will change over time, so I want to use this reference sheet to update the list values. I have setup the list in Sheet Reference Manager and there is only one column of data in the reference sheet which contains the values for the dropdown list. However, I am at a loss as to what formula to use on the primary sheet column so that it is using the values from the referenced sheet. Thank you for assisting.
Help Article Resources
Check out the Formula Handbook template!