How to use table column as data validation list

[connoisseur]

In Excel 2007, is there any way I can use a column in a Named Table as my data validation list without specifying the range. For example I have a table named MyTest of ID/Name. I want to display the Name column as my data validation list. Any time I try using my source as =MyTest[Id] in the DataValidation List Source I get an error. I want to find a way to do this without specifying the given range within my table because my tables might use different start range cells. Any help?

[Gania]

In Name Manager you can create a new name called myList with a reference of =MyTest[Id]. In DV, use List, Source myList.

[Erakna]

Attached file might help you with your query. There are 2 samples of calling a named table via a Data Validation. First one uses the OFFSET function. The named range is the first cell of the table which is used as a starting reference for the OFFSET function. The second one uses an array to support the TRANSPOSE function. The named range is the table itself.