One way:

=INDEX($B$1:$AA$1,MATCH(TRUE,B2:AA20,0))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

mattsheffield wrote:

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

--

Dave Peterson