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!!
Bookmarks