Forum Discussion
table references for drop down
I have created table1 on tab Empl By Dept with headers for Employee, supervisor and dept. I am using a drop down list on another tab of the same workbook to select data from this table. Per excel help when choosing my source for this drop down it should put the table name references when I click on the cell below the header name employee. instead it puts the cell reference names ie...a2. I have tried several variations shown in help trying to get the syntax right to pull this data. I am wanting the drop down choices to automatically change if the table info changes. Using table references is supposed to do this. help....
- when I type =table1[employee] in the source for the drop down. It highlights all of my employees in the table with the dotted lines, but when I click ok on the drop down panel, I get err about trying to create a function.
- formula not function
The data validation menu doesn't accept structured table references for list sources. The workaround is to define a named item inside of your table (It will expand with the table as needed).
- I am not seeing anywhere to define a named item as shown in the pic.
