Try

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

regards
Peter

"STARFINANCIALGROUP" wrote:

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.