Hi,

I'm hoping somebody can help!!!
In cells B1 to AA1 i have dates.
Below that i have values (i.e. in B2 to AA2, B3 to AA3 etc)

What function could i use in cell B1 to search the cells to the right
until it finds a value 0 and then retun the value about that in the
dates row (b1 to aa1)

Hope this explains it!!

Many thanks in advance

Matt


--
mattsheffield
------------------------------------------------------------------------
mattsheffield's Profile: http://www.excelforum.com/member.php...o&userid=26196
View this thread: http://www.excelforum.com/showthread...hreadid=395033