Hi everyone!

I have a problem using VLOOKUP...

For the Meow rows, I want to return the number of Cat (which is 1 or 4 or ... depending on which is above it).
The data is arranged as shown below..

1 Cat
2 Meow 1
3 Meow 1
4 Cat
5 Meow 4
6 Meow 4


What I need for a function to do is to: LOOKUP the number of the cat that is NEAREST ABOVE the meow.
Hope you guys could help. Thanks!!