I already posted this, but I think I may have inadvertently posted it to the
wrong area. I have made an amortization table to figure payoffs. I have
already made the table, it figures the amoritization, the payments, number of
days to first payment, the per diem, and the payoff as of that date. I am
displaying the payoff figures in a row. I would like to create a cell that
has the number of months past that will bring up the figure from the row.
Example: If the months past were 5 and the row started on line a10, the
figure I would be looking for would be on line a15, if it were 7months past
the figure I would want displayed in a seperate cell would be on line a17.

Thanks,

Mark.