Use the INDEX function to get a cell from a table

The syntax is:

INDEX(table_column, table_row)
table_column = the column where the cell is (T1!A, T2!B, etc)
table_row = the row where the cell is (1,2,3, etc)

For the table:
100 2
200 10
300 20
400 30
INDEX(T1!B, 3) will return 20.

This is useful if you have a value that you want to use in many other formulas but want to be able to change in the future.

See the Tables page for more tips on how to work with tables.

Need Help?
Already checked the help docs? We're quick to answer and friendly
We'll reply very soon at
Send message