Dear Max,

Thank you for your reply.

Regret to inform you that your formula returned an error "#VALUE!", it
didn't work out. Sorry.

Looking for your further effort to help me in this issue.

Best Regards,

NHH

"Max" wrote:

One way, array-entered* in say, B1:
=INDEX(A1:A100,MATCH(TRUE,A1:A100<"",0))

*press CTRL+SHIFT+ENTER to confirm the formula
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400 Files:358 Subscribers:55
xdemechanik
---
"NHH" wrote:
I need a formula to help return the value of the first not null cell in a
column, I know the formula that returns the same but in the last not null
cell in a column (LOOKUP(99^99,Sheet1!A:A)), but I need the first not the last

Thank you for your help