ADDRESS result isn't accepted as parameter

[Lorenz25]

I want to get the value one row above the current cell, like this:

 =OFFSET(ADDRESS(ROW(),COLUMN(),4), -1, 0)

But it doesn’t accept the reference. Error 504.

[w_whalley]

The function ADDRESS() returns a text representation of the cell address. That doesn’t work for the OFFSET function, hence the 504 parameter list error.
You could use the INDIRECT function to convert the text version of the address to a usable one, i.e.

=OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),-1,0,1,1)

but why not simplify and use

=INDIRECT(ADDRESS(ROW()-1,COLUMN()))

[Lorenz25]

Thank you. Should’ve looked up the ADDRESS function, instead of just copy/paste.

[karolus]

Hallo

I want to get the value one row above the current cell, like this:

Why the hell not simply =<the cell name one-above>, or if you need some oversophistication:

=OFFSET(<this-cell>; -1; 0) 

for Example the Fomula for Cell D7 →→

=OFFSET(D7;-1;0)

[Lorenz25]

After I’ve given it some thought, I think this would work too. Had some doubt about the reference always being the cell of the formula, if copied elsewhere. So thank you as well.