Refer upper field
 

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.

Refer upper field
 

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.

"Info" wrote:

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.