Please disregard the second formula. It doesn't work with other data
interspersed.

In article ,
Domenic wrote:

Also...

Top...

=INDEX(A1:A150,MATCH("~*",B1:B150,0))

Bottom...

=INDEX(A1:A150,MATCH("~*",B1:B150))

OR

=LOOKUP(2,1/(B1:B150="*"),A1:A150)

Hope this helps!