Menu

INDEX

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?
Can't find the answer in the help docs? We are quick to answer and friendly :) Thanks! We'll be back with a reply soon.
Send