ckelsoe
asked on
HowTo: Use table for Data Validation List
Hello,
I am having issues trying to use a table for a data validation list. In my case I have a single column table - created by using the "Format As Table" feature. I have named my table ListStatus.
In the Data Validation dialog box I have selected List and entered ListStatus as the Source. I get an error when doing this.
How can I reference a single column table as the source for data validation?
Thanks in advance.
I am having issues trying to use a table for a data validation list. In my case I have a single column table - created by using the "Format As Table" feature. I have named my table ListStatus.
In the Data Validation dialog box I have selected List and entered ListStatus as the Source. I get an error when doing this.
How can I reference a single column table as the source for data validation?
Thanks in advance.
ASKER
That does not seem to work with a range name made by the names created by using the format as table functionality.
ASKER
The names that were created when the table was created are not showing up in the Names section. When I press F5 I can get to the table column but cannot reference the name in a formula. This is Excel 2007
ASKER
Ok - it looks like I have to create a new name and reference the existing structured table name to get the results I need.
For example, I can create a new name StatusLookup and have it reference =ListStatus[Status]
For example, I can create a new name StatusLookup and have it reference =ListStatus[Status]
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That would work as well. I just wanted to use the table feature to handle this. I guess the tables implementation is half baked in Excel still.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
http://www.contextures.com/xldataval01.html