Explanation
This is a standard INDEX formula.
you could use INDEX to retrieve individual values, or entire rows and columns.
Get column name from index in table
To get the name of a column in an Excel Table from its numeric index, you can use the INDEX function with a structured reference. In the example shown, the formula in I4 is: =INDEX(Table1[#Headers],H5) When the formula is copied down, it returns an name for each column, based on index values in column H.
