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