Excel: What's the best way to get the value of a Relative Row but from a Fixed Column?

Question

The following formula will always return the value of the 4th column (D) of the next row.

=INDIRECT("R[1]C[" & 4-COLUMN() & "]",FALSE)

Is there a better way to achieve the same results?

Answer 1

This will work if you know the range:

=INDEX($A$1:$E$4, ROW()+1, 4)

Answer 2

Putting a '$' character in front of a column letter or row number will lock it down when you copy and paste.

Eg:

$C$17

Answer 3

Similar, but less wordy and easier to read (IMHO), is the A1 style of addressing:

=INDIRECT("$D" & ROW()+1)