Finding First Negative Value

Hi All,

I am looking for a formula which will return the date of the first negative value. I have attached an example workbook.

I manage to get it to return the row or column ref that it falls in but I cant seem to return the date.

Thanks
P

Try:

=INDEX(E3:H3,MATCH(0,E4:H4,-1)+1)

Thanks PaulM100 worked pefectley

If it took care of your problem, please mark the thread as Solved. Thanks.

Apply the formula

Formula:

=INDEX(E3:H3,,AGGREGATE(15,6,COLUMN($A:$U)/(E4:H4<0),1))

Hi, to all!

Another approach could be:
=AGGREGATE(15,6,E3:H3/(E4:H4<0),1)

Blessings!