Hi all,

I have a spreadsheet with data in the range of A9:M30. The data looks like
this:
588 - Number in a cell directly above a name
Hill - Name in a cell directly below a number
Each row has numbers in it and the row immediately below that one has a name
in it. I am looking for a way to search this range so for instance when
"Hill" is found, I want to return the value in the cell directly above it.
All names and the corresponding values above this will always be unique---no
duplicate names or numbers. Any suggestions would be greatly appreciated.
Thanks.

Ron