Forum Discussion
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 in a named table from a different worksheet? I think the syntax would look something like this...
INDIRECT("'" & Table name? &"' &[Column name])
... Where the table name is text and the column name is a cell reference. However, I can't quite get it to work. Any suggestions, internet?
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 & "]")
3 Replies
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 & "]").
