how to reference a cell relative to the current one even rows are bing inserted

[drobble]

Hi Everyone,

I’m wondering how can I keep a reference (to another cell) up to date even if a row has been inserted between the rows (value / reference rows)

I defined the formula: =INDIRECT(ADDRESS(ROW()-2,COLUMN(),4))

e.g. in attached file: how can I keep the reference in cell B6 valid even if I insert a row between R4 and R6?

Thanks in advance
drobble

cell references.ods

[mariosv]

Sorry why do you need indirect then?

[mikekaganski]

Just put formula =B4 to your B6. See Addresses and References, Absolute and Relative in help.