Hello,

I have an amortization "what-if" schedule, and on the summary page, I am
trying to write a lookup formula that will return the date from the table
that the balance flips from positive to negative. For example, the formula
would return 4-1-2001 in the following case (in reality there are a lot of
columns in between)


DATE BALANCE
1-1-2001 29
2-1-2001 19
3-1-2001 09
4-1-2001 -1
5-1-2001 -11
6-1-2001 -21


Thanks!