"Don Guillett" wrote...
Try this entered normally if TEXT
=INDEX(A2:A100,MATCH("*",A2:A100,0),0)
....

But if not text or not necessarily text, the following array formula
would find it.

=INDEX(A2:A100,MATCH(FALSE,ISBLANK(A2:A100),0))