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.

ragnarok89

Here's a simple explanation:

http://www.contextures.com/xldataval01.html

ckelsoe

ASKER

That does not seem to work with a range name made by the names created by using the format as table functionality.

ckelsoe

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

ckelsoe

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]

ASKER CERTIFIED SOLUTION

Rob Henson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ckelsoe

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.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.