Results 1 to 5 of 5

Search a column to return values just above and below the search criteria

Threaded View

  1. #1
    Registered User
    Join Date
    12-20-2012
    Location
    Northeast Ohio
    MS-Off Ver
    Excel 2010
    Posts
    3

    Search a column to return values just above and below the search criteria

    Okay...so here goes my first post:

    I have a search I'd like to do on a table of data. I have an ascending list of numbers, non repeating and each unique. I'd like to search the first column to look for one of those values, and give me the prior and next value in the table. Or even better, return to me the associated data of the prior and next row in the last column. I do not want to have the original search value returned to me.

    It's been a long day >.<

    I included a sheet with some values to show what I'm working with. I'd like to search column A, for say '774.87536752463', and only have returned to me 'Indigo' and Kilo'. Most of what I can find via searching and reading will return only 'Juliet'.

    MultReturn.xlsx
    Last edited by Rehpot; 12-20-2012 at 05:30 PM. Reason: added attachment & hopefully clarification

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1