Microsoft Office Forums - View Single Post - [Solved] INDIRECT and Relative Referencing?

tinfanide · 03-03-2016, 03:12 AM

Code:

Absolute referencing:
=INDIRECT("'"&B$1&"'!$N"&ROW()+1)

VS

Relative referencing:
=INDIRECT("'"&B$1&"'!$"&N&ROW()+1)

The relative one returns an error: #NAME
Although the absolute one is correct, I would like to have the column ("N" in this case) relative. This means when I insert a new column (then "N" should be "O"), the formula updates it automatically. How could I achieve that?

Any help is appreciated.