let me make a small note to this post. If my min is ($500,000) I wan tto
find the first time the cash reaches $500,000 to the good.

"Lambchop" wrote:

I have a row of numbers that represent cash. I use the min function to find
the lowest amount my cash gets to which is a negative and the Hlookup to find
the corresponding date. Now I need to find the first time my cash gets
positive that is equal to or greater than my min number. I tried using the
lookup function but it gives the amount that is less than the min. If you
can help me with this I would appreciate it.