change the less than sign < to greater than
so the correct formula is
=INDEX(A4:A1000,MATCH(TRUE,(B4:B10000),0))
array entered(ctrl+shift+enter)

"N Harkawat" wrote in message
...
=INDEX(A4:A1000,MATCH(TRUE,(B4:B1000<0),0))
array entered(ctrl+shift+enter)

assuming range a4:a1000 holds the dates and b4:b1000 has the amounts




"JNW" wrote in message
...
I am doing some mortgage calculations. Based on any number of variables
and
calculations the final payoff date can vary. I have a spreadsheet with
the
date (in mmm-yy form) in one column and another with the remaining amount
on
the mortgage (which is a negative amount until payed off then turns
positive). What I need is some way funtion to return in cell a1 the date
at
which the value turns positive.

Thank you