INDEX

Use the INDEX function to get a cell from a table

The syntax is:

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.