Excel 2007 Display value based on values in another column range

C

ChrisM

I have an amortization schedule of my mortgage. I want to show the date when
I can cancel my PMI, the date will change based on how much extra principle I
pay each month. So, I want to search a column for a specific value. Once
that value is less than a constant, I want to pull another value and display
it from the same row that first meets the criteria. I want to search a
range of values (I1:I20). I want to locate the row where the value in that
"I" column first goes below 100,000. Now that I have the row, say I10, I
want to display the date value in that row, say A10.

Thankx
 
S

shail

hi Chris,

Can make me understand it with an example, that will help me to help
you out.

Thanks,

Shail
 
C

ChrisM

Date Balance Payment Extra Principle (varies) Ending Bal
1/1/06 200,000 1000 1000
198,000
2/1/06 198,000 1000 -
197,000
3/1/06 197,000 1000 2000
194,000

Once the ending balance reaches a certain value, I want to know that date
(column A). I want to watch the Ending Balance value and once it reaches a
threshold, I want to capture the date.

ie. if endingbal < 197500, print date. The problem is that the ending
balance is not on a set schedule since the extra principle I pay varies. I
need to monitor a range in the last column, locate the threshold value and
then display the corresponding date.
 
Top