SOLVED

Indirect Function - Referencing Table Columns

Brass Contributor

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?  

 

3 Replies

@warrevar 

That's like

INDIRECT( TableName & "[" & ColumnName & "]")
best response confirmed by warrevar (Brass Contributor)
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 & "]") 

 

@warrevar 

TableName and ColumnName could be references to cells, named cells, simply texts. If you consider first as text when INDIRECT("TableName[" & ColumnName & "]").

1 best response

Accepted Solutions
best response confirmed by warrevar (Brass Contributor)
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 & "]") 

 

View solution in original post