INDEX formula to get the text in the next row in a different column

Question

I need the formula to get the text from the next row in a specified column.  I am creating the formula in row 2 in a column named 'Next' and want it to bring back the data from column 'Test' in row 3.  This is what I have tried so far but getting #unparseable error.

=INDEX(Test:Test, row() , +1)

=INDEX([Test]:[Test], row() , +1)

Thanks!!

Paul Newcome · Accepted Answer

Insert an auto-number column (called "Auto" in this example) with no special formatting. Then use this:

=INDEX(Test:Test, Auto@row + 1)