Forum Discussion
Solved
Indirect Function - Referencing Table Columns
I know you can use the INDIRECT function to reference a cell from a different worksheet... INDIRECT("'"&sheet&"'!"&name) ...But I'm wondering if you can use it to reference a column heading i...
SergeiBaklan Thank you! I also needed to put the name of the table in quotes so this ended up being the final syntax...
INDIRECT( "TableName" & "[" & ColumnName & "]")
SergeiBaklan Thank you! I also needed to put the name of the table in quotes so this ended up being the final syntax...
INDIRECT( "TableName" & "[" & ColumnName & "]")
TableName and ColumnName could be references to cells, named cells, simply texts. If you consider first as text when INDIRECT("TableName[" & ColumnName & "]").