Need to figure out how to find a number from a previous sheet, from a range.

Title wasn't long enough to describe what I'm seeking. I'm relatively new to Excel, but learning fast. I am building a spreadsheet that in sheet 2, I need to reference sheet 1, to find a number in a column that fits within a range, and then give me the cell number from the same row but different column. Confusing isn't it. Ok, I'll try to extrapolate...

A B C D E F
4 S 13.02 1456.74 1779.46
5 D 13.015 1469.755 1792.475
6 4 13.102 1482.857 1805.577

And so on and so forth, this pattern repeats itself, with the numbers changing ever so slightly for about 500 rows or so. What I'm looking for, as this would be on sheet 1, is a formula or macro for sheet 2, that would find the number 1798.565 as being between row 5 and 6, with the difference shown from either cell. Like, if the function says it's row 6 - 7.012

or tell me it's row 5 + 6.09. Something like that. I can manipulate the function, formula, or macro to fit my needs but I'm at my wits end trying to get a cell to do this. Maybe have a helper cell on sheet 2? Not sure.

To further things, once this has been calculated, I need the answer given be able to populate a cell with a drop down answer box that gives a direction. Such as, if the answer is say, row 6 - 7.012, then another cell would read the -7.012 and then populate a cell with a given command of 'Add single' or 'Lay out single' or 'Do nothing'. This would be for a different cell on sheet 2 still, but able to read the answer from the first part, perform a calculation, then give the appropriate answer, if possible... I may be asking a lot here, but any help would be awesome. Thanks in advance...

I think you're looking for something like this.
For the -7.012 case

Formula:

Please Login or Register  to view this content.

For the 6.09 case

Formula:

Please Login or Register  to view this content.

Thanks for the welcome I'll see what I can do to upload a clean workbook to illustrate further what I'm attempting to accomplish. Cheers...

I'll try this one out, see if it works. Cheers m8!

Hmm. Not sure how to attach a clean workbook to this post...

Okay, here's what I'm working with, I don't have anything that shows what I'm looking to have done as if I knew how to get that, I wouldn't have to ask you guys for help lol...