Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Search | Excel Worksheet Functions | |||
Search through Data | New Users to Excel | |||
Duplicate Data Search | Excel Discussion (Misc queries) | |||
Search for data using 'contains' | Excel Discussion (Misc queries) | |||
Search data formulas - HELP!! | Excel Worksheet Functions |