Try...

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

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

On Nov 1, 3:11 pm, Bullseye
wrote:
I'm looking for a function that will return the value of the first non-blank
cell in a range.