Excel Formula

[Kevin]

I am trying to create a formula to...

A B C
5
4
3
2
1
01/01/04 0
-1
-2
search through data in column C so that when it reaches
zero or <0 it will return the date that is in column A in
the cell that I write the formula in.

Thanks

Kevin

 

[Peo Sjoblom]

One way

=INDEX(A1:A10,MATCH(TRUE,C1:C10<=0,0))

entered with ctrl + shift & enter

 

[Peo Sjoblom]

I might add that you probably have to format result as date since what come
out is probably the serial number
of the date

 

[Guest]

Thanks for your help !

-----Original Message-----
One way

=INDEX(A1:A10,MATCH(TRUE,C1:C10<=0,0))

entered with ctrl + shift & enter

--

Regards,

Peo Sjoblom




.