Okay, I claim to have a working knowledge of Excel. But I cannot figure out this problem with mortgage amortization.

I'm working on columns that have data in them, with one of the columns displaying when the mortgage is paid off. The loan remaining is in one column, and a display on a subsequent column displays wether the debt is paid off or not. The data is collected by month.

What I'm trying to figure out is how to display (at the top of the sheet) the month the mortgage is paid off (that is, using an "if" statement to say, if the "paid off" column says "paid off", then display the corresponding month).

Does that make sense?

6/30/2016 6:59:23 PM

Use match to find "paid off" and index to find the associated month.

6/30/2016 7:06:54 PM

will try that, thx

6/30/2016 7:22:58 PM

works!!!

=INDEX(where you want to look up the date, MATCH(what text/value you want to look for, where you want to look for that value,0))

6/30/2016 8:16:57 PM