Search Function

[mattsheffield]

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

 

[Dave Peterson]

One way:

=INDEX($B$1:$AA$1,MATCH(TRUE,B2:AA2>0,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.)