Refer to Table column by position / index?

[Dave Bruns]

I know I can easily refer to a table column by name, as in Table1[column name]

But is there a way to refer to a table column by it's position? For example, refer to the first column, third column, etc. without using the column name?

Hoping there is some way to do this using structured references.

 

[Jonmo1]

Try using INDEX

=INDEX(Table,0,3)

That will be the 3rd column of the table.

 

[Dave Bruns]

Thanks! INDEX works just fine.

 

[Jonmo1]

You're welcome.