lookup last cell contains text and number on same cell

Dear MVPs

I really need your help, I have excel worksheet like this

A
1 Type
2 Exclusive 1
3 Sprint
3 VBB
5 Special 80
6 VNB
7 Exclusive 2
8 Special 90
9 Sprint
10 Super
11 Douglas
12 VNB

I want to lookup last cell which contains text and number in a cell which is should be "Special 90" at cell A8

Many thanks for your help

Originally Posted by bebo021999

Try:

Please Login or Register  to view this content.

It works!, maybe if you don't mind, can you explain a bit about how it works especially the "ROW" function

many thanks, however please accept my star for your reputation

Originally Posted by bebo021999

Try:

Please Login or Register  to view this content.

It Works!! anyway, if you don't mind, can you explain a bit how it works, especially the "ROW" function

Many thanks, and here, please accept star of reputation from me for you....