Try this:

=INDEX(D$46:D$4200,ROWS(U$7:U7)*69-69+1)

--
Biff
Microsoft Excel MVP


"James D" wrote in message
...
Hi.

I have a row in which each cell references another cell.

Format looks like this:

U7 =D46
U8 =D115
U9 =D184

Notice that each cell is still referencing column D, but moves up in
sequence by 69
When I highlight and drag (I need to continue this series all the way to
U66), Excel is returning =D49 in cell U10, and =D118 in cel U11...it does
not
maintain the series.
Driving me bonkers, what do I need to do to continue the series without
manually entering the formula? Done right, U10 should be =D253, U11
shoudl
be =D322, etc.

--
Thank you all for your help!