Share via

how to make data validation list source data with table names

Anonymous
2021-02-09T09:36:29+00:00

My work  sheet has 4 excel tables,I want to create a  data validation list using these 4 table names,so that I can analyze data of these tables using appropriate formulas.How I can refer these table names from drop down list of my data validation list.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lz._ 38,106 Reputation points Volunteer Moderator
    2021-02-09T10:39:07+00:00

    Hi

    Unfortunately you can't directly refer to a Table column. Assuming the following Table1

    • Select the column content (A3:A5 above) > from the Formula tab > Define name > Name = (i.e.) myList (Refers to should be =Table1[ColumnName])
    • Data validation list > Source = myList
    24 people found this answer helpful.
    0 comments