HOW DO COPY A CELL BUT INCREASE ITS REFERENCE BY TWO CELL POSITIO.

[Crusty]

I want to copy a cell that has a reference to a cell in another sheet but I
want the new reference to be incremented by 2 positions.
example copy cell f1 to f2, cell f1 has a reference to 'test'!r5
I want the f2 cell to reference 'test'!r7
Can this be done?

Thanks,

no1crusty

 

[Roger Govier]

Hi

Try
=INDIRECT("'Test'!R"&5+(ROW(A1)-ROW($A$1))*2)