I expect there is something more elegant but I came up with this
=INDEX(A1:A7,SUMPRODUCT(MIN((A1:A7<"")*ROW(A1:A7) +(A1:A7="")*9999999)))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Rowland" wrote in message
...
I am looking for a formula to find the first row in a column that contains
any data.I can do it with an array formula INDEX(rng,MATCH(TRUE,rng0,0))
but was curious if some can do it without using an array formula,perhaps
with LOOKUP