=OFFSET(Sheet1!C3,2,0)

will return contents of Sheet1!C5

2 for 2 rows down and 0 for same column.


Gord Dibben MS Excel MVP


On Mon, 30 Oct 2006 11:41:01 -0800, wienmichael
wrote:

If I have referenced a cell from another worksheet, how can I return cell
values that are offset from the origional cell referenced.

Example:
CellA1(sheet2) = CellC3 (sheet1)

I want CellA2(sheet2) to equal a value offset from CellC3 (sheet1)

Thanks