Need help trying to get cell value when condition is met

[SL]

I'm trying to get the cell value from column A, when cell
in column E is less than or equal to zero. I'm only
interested in the first instance. Column E has a loan
value which is decreasing, but doesn't exactly reach
zero. Column A is the number of months. Thanks for your
help.

 

[Ron de Bruin]

Try this

=IF(E1<=0,A1,"")

 

[SL]

I think I need to be more clear. I am looking for a
formula that looks at an entire column E, and posts the
correct month from column A in cell F3. I'm guessing I
need to use index or some other function. Thanks.

-----Original Message-----
Try this

=IF(E1<=0,A1,"")

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SL" <[email protected]> wrote in

message news:[email protected]...

 

[Aladin Akyurek]

=INDEX(A:A,MATCH(0,E:E,-1))

 

[Ken Wright]

Contiguous cells from E1 down with a header in E1, then perhaps the following as
one way of doing it:-

=OFFSET($A$1,COUNTIF(E:E,">=0"),)