Hi,

I need to find a way of returning the cell values that are directly
above and below a specific cell. For example, suppose I have the
following list in column A:

dogs
cats
fish
mice

There is another cell (say cell B1) in which the user inputs one of the
items in the list and then another 2 cells (say B2 and B3) that return
the entries above and below the user-input entry i.e. in this case, the
user input "cats" and so in cell B2 would be displayed "dogs" and in
cell B3 "fish".

I cannot get this to work however. I have tried several functions (e.g.
HLOOKUP) but it does not work as intended. Can anyone give me any
help/advice?

Many thanks
-Rob


--
TheRobsterUK


------------------------------------------------------------------------
TheRobsterUK's Profile: http://www.excelforum.com/member.php...fo&userid=9924
View this thread: http://www.excelforum.com/showthread...hreadid=485713