function which takes address() and gives value
===

I want to make a cell equal to the cell above it.

When I write

    =address(row()-1;column())

It just writes the name of the cell above(for example for B2 it writes $B$1)

Is there a function which inputs the address and puts the value?