answered here: https://bettersolutions.com/excel/formulas/return-the-value-from-the-cell-above.htm
=INDIRECT(ADDRESS(ROW() - 1, COLUMN() ) )