Results 1 to 4 of 4

Thread: *Resolved* Excel: return entry in column above/below cell

Threaded View

  1. Nov 16th, 2005, 06:06 PM #1
    TheRobster
    TheRobster is offline

    Thread Starter
    Hyperactive Member
    Join Date
    May 2004
    Location
    Right here
    Posts
    275

    Resolved *Resolved* Excel: return entry in column above/below cell

    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
    Last edited by TheRobster; Nov 17th, 2005 at 10:31 AM.
    http://www.sudsolutions.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width