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

Rehpot,

Welcome to the forum!
Attached is a modified version of your posted workbook.
The cell where you type in the unique number is H2

In cell H3 is this formula to get the data from column E (Prior):

Please Login or Register  to view this content.

In cell H4 is this formula to get the data from column E (Next):

Please Login or Register  to view this content.

You're very welcome and thank you for the star tap

If that takes care of your need, please mark this thread as solved.
How to mark a thread Solved
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
Go to the first post
Click edit
Click Go Advanced
Just below the word "Title" you will see a dropdown with the words "No prefix"
Change to "Solved"
Click Save

Must the search array be in ascending order? I realized after i got your modified code to return the unique numbers, that I should have the table sorted by a different column first.

I wonder if I should just post the actual workbook in it's entirety?

Edit:

So I answered my own question (love that)! I simply tried what I was thinking. I reordered the column I should have the first time, and the search seems to be going off without a hitch.

Thanks again! Now, off to mark the thread solved.