Excel: How to set list data validation to point to a column in a named range

Question

I have a named range called "items" spanning 3 cols and 10 rows. In another worksheet I have a cell that uses a data validation list to allow a user to select from a drop down. In the source I want to specify the first column of the named "item" range. Is this possible?

Answer 1

Set your validation range formula to

=INDEX(items,0,1)

Though is your named range called "item" or "items".... I've assumed "items"