Increment a formula by row and column?

[mitchellsm]

I am trying to create a formula that will allow me to refer to the cell one below and one right of the column previously referenced (basically data in a diagonal line) in a new sheet in that workbook. Any help is appreciated--thanks!

Here's a simplified version of what I'm trying to do:

Sheet 1
[TABLE="width: 500"]
<tbody>[TR]
[TD]275[/TD]
[TD]55[/TD]
[TD]333[/TD]
[TD]418[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]153[/TD]
[TD]4444[/TD]
[TD]375[/TD]
[/TR]
[TR]
[TD]1976[/TD]
[TD]400[/TD]
[TD]20[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]77[/TD]
[TD]52[/TD]
[TD]96[/TD]
[TD]4599[/TD]
[/TR]
</tbody>[/TABLE]

Sheet 2
[TABLE="width: 125"]
<tbody>[TR]
[TD]275[/TD]
[/TR]
[TR]
[TD]153[/TD]
[/TR]
[TR]
[TD]20[/TD]
[/TR]
[TR]
[TD]4599[/TD]
[/TR]
</tbody>[/TABLE]

 

[JoeMo]

Assuming the first data point on sheet1 is in cell A1, then in cell A1 on sheet2 enter:
=OFFSET(Sheet1!$A$1,ROW(A1)-1,ROW(A1)-1)
and copy down.

 

[mitchellsm]

Thank you!!

 

[JoeMo]

Thank you!!

You are welcome - thanks for the reply.