Picking a cell to show in another page.

[Guest]

I made an amoritization table to calculate payoffs. I would like to pick the
number of months past and show the amount in that cell. ie: If the cell
with the number of payments past is a1 and the amoritization table starts in
a10 and the amount of months past would be 15, so the number in a1 is
fifteen, I want to display the value of cell a25.

Thanks,

Mark.

 

[Guest]

Try

=INDIRECT(ADDRESS(A1+10,1))

regards
Peter

 

[David McRitchie]

The subject does not match the question, to answer the part for the
subject. to refer to cell A1 on sheet4
=sheet4!A1
if the sheetname has spaces\
='sheet four'!A1
another way is to enter = sign then go to 'sheet four' select cell A1
then return to original sheet and hit enter to see your formula created.