Return the value from the cell above

The value in the cell directly above


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

Built-in Functions

INDIRECT - The text string of the contents of a given cell reference.
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.


© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top