Forum Discussion
Using Lookup, Index or Match for a Simple Problem
I am using Excel 2000 for Windows. I have a 60-month amortization table having the following columns: Payment# Monthly Payment Due Date Payment Date Principal Interest Principal B...
Thank you Twifoo!
Your function worked perfectly.
I figured another solution. However, my method is not as elegant or economical as yours. Here it is:
To automatically fill-in cell I8
=SUMPRODUCT(MAX((D11:D75<>"")*ROW(D11:D75)))
To automatically fill-in cell H4
=INDIRECT(ADDRESS(I8, I9))
nytwodees
Whenever possible, avoid volatile functions, such as INDIRECT and OFFSET, because they require frequent recalculation.
Anyway, I am pleased to have helped you.
Anyway, I am pleased to have helped you.