Formula to Reference Cell in Column Using @row

Min

Hello!

I'd like to be able to have a column formula where a cell is the same value as the next direct cell in another column. For instance, I'd like the cell on my third row under column "Successor Responsible" to equal the cell on my fourth row under column "Task Responsible".

Of course, the simplest way to do this is to have the formula "=[Task Responsible]3" but since I need to convert to column formula this is not currently an option.

Any help would be greatly appreciated thank you!

Paul Newcome

Insert an auto-number column (called "Auto" in this example) and a text/number column (called "Row"). Use this column formula in the Row column

=MATCH(Auto@row, Auto:Auto, 0)

Then in your Successor Responsible column you can use this column formula:

=IFERROR(INDEX([Task Responsible]:[Task Responsible], Row@row - 1), "")