13

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?

a-z
  • 1,634
  • 4
  • 16
  • 35

1 Answers1

28

Try using the OFFSET function to offset the cell by -1 row. For example you can paste the below formula into cell A2 and it will return the value of A1:

=OFFSET(A2,-1,0)

If, however, you really want to keep your present address method, put it inside of the INDIRECT function like this:

=INDIRECT(ADDRESS(ROW()-1,COLUMN()))
Cristian Ciupitu
  • 20,270
  • 7
  • 50
  • 76
danielpiestrak
  • 5,279
  • 3
  • 30
  • 29
  • 1
    Be aware if you use INDIRECT it is volatile and will cause excessive calculation – Jesse Jul 10 '12 at 04:29
  • Agree with Jesse, there's almost never any reason to use INDIRECT unless you've got yourself into a pickle. In this case offset is also pointless as instead of =OFFSET(A2,-1,0) as a formula you should just use =A1 –  Jul 10 '12 at 22:49