Jul 24 2019 11:49 AM
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?
Jul 24 2019 01:41 PM
Jul 25 2019 06:55 AM
Solution@Sergei Baklan 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 & "]")
Jul 25 2019 07:46 AM
TableName and ColumnName could be references to cells, named cells, simply texts. If you consider first as text when INDIRECT("TableName[" & ColumnName & "]").
Jul 25 2019 06:55 AM
Solution@Sergei Baklan 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 & "]")