Dear Mike H,

Thank you for your reply.

Regret to inform you that your formula returned an error "N/A". Id didn't
work out. Sorry.

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

Best Regards,

NHH


"Mike H" wrote:

From your formula I guess you may be trying to find the first number. Try
this array entered.

=INDEX(A1:A1000,MATCH(TRUE,ISNUMBER(A1:A1000),0))

Mike

"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