Hi,

I was looking to use VLOOkUP to match the first non-blank cell, the formula
you've kindly provided doesn't do that.
Thank you for trying anyway.

Clarissa

"Carim" wrote:

Ok then ...

Have a go with :

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

Instead of Enter, use Shift Control Enter keys simultaneously to input
formula

HTH