Here's one option:

=OFFSET(INDIRECT("A"&MATCH("Hill",A1:A100,0)),-1,0)

Replace "A" with the column letter that your data is in. You can also
replace "Hill" with a cell reference containing the value that you wish to
look up.

HTH,
Elkar


"Airfive" wrote:

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