Hello Bill,

Assuming you have less than 1000 rows of data (adjust as necessary) try
this formula in D1

=INDEX(C2:C1001,MATCH(1,INDEX((A1:A1000<0)*(A2:A1 001=0),0),0))


--
barry houdini
------------------------------------------------------------------------
barry houdini's Profile: http://www.thecodecage.com/forumz/member.php?userid=72
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=127731