Refer upper field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any function that can refer upper or beside field without defining
specify field?For example,i'm select row A1,then i use Alt+G to select blank
field,then the blank field will refer the value/text each of there upper
field,example field A2 refer A1,A3 refer A2,A4 refer A3 and so on........

Thanks for your knowlendge.
 
Have you tried looking at INDIRECT and ADDRESS functions.

=INDIRECT(ADDRESS(-1,0,4,FALSE),FALSE)
This will look at the cell 1 row up (the -1) in the same column (the 0)
where the formula is placed.

Helpfile states for ADDRESS function:
Creates a cell address as text, given specified row and column numbers.

INDIRECT simply turns it into a real cell reference.
 
Back
Top