Previous row values - OFFSET

The OFFSET Excel formula is quite useful when we need to access the values of previous or next rows.

Syntax
=Offset(currentcell,row,cols)

Example : 
=Offset(A10,-1,0)

Returns the value of Cell A9.