Return the value from the cell above

The value in the cell directly above

	A
1	The value in the cell above
2	=INDIRECT(ADDRESS(ROW() - 1, COLUMN() ) ) = The value in the cell above

Built-in Functions

INDIRECT - The value of a given cell reference specified by a text string.
ADDRESS - The cell reference given a row and column number.
ROW - The row number of a cell reference.
COLUMN - The column number of a cell reference.