I would like to make a dynamic reference to view some columns of a table. So instead of write =TABLE[aColumn] (assume that this works) I would like to have =TABLE[B2] where cell B2 contais the string "aColumn". Is it possible? Thank you

CodePudding user response：

You can use INDIRECT function to achieve this like this:

=INDIRECT("TABLE"&"["&B2&"]")

You can refer to the following article for more detailed explination: