Try the below

=OFFSET($A$1,ROW(A1)-1,ROW(A1)-1)

If this post helps click Yes
---------------
Jacob Skaria


"Dan" wrote:

I would like to drag a formula down a column, where the cell referred to is
one column right and one row down from the previous cell;

=A1
=B2
=C3
...

Thanks,
Dan