is there this func?

I need a function that scans from the current position or range of cells in order vertically and/or horizontally and looks for the first non-blank value it finds and returns it. Is there such a function, I looked and looked and couldn't find one.

Thanks,

Devin

Try the following...

=INDEX(A1:A100,MATCH(TRUE,A1:A100<>"",0))

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

Originally Posted by dino-new

I need a function that scans from the current position or range of cells in order vertically and/or horizontally and looks for the first non-blank value it finds and returns it. Is there such a function, I looked and looked and couldn't find one.

Thanks,

Devin