Find 2 values closest that are higher

[caleb]

Hi

Got an equation nightmare on my hands.
So i have 3 columns of data
A: State Abbreviate
B: Benchmark Number
C: New Number

I am trying to get an equation that in column D will return the 2
closest values in column B for a value in a cell in Column C.
So if column C1 is 100
And column D15 is 101, 115, 98, 5,92
It will find values 101 and 115 and put them in column D. The trick
being was that i was hoping it would also return the State Abbreviate
for this record. So if Fl is 101 it would return Fl: 101

Any ideas on how to do this???

 

[Shane Devenshire]

A little more detail would help.

Also,

Please enter a quesion in the body of your emai; if you don't the web won't
let us reply, instead it displays the following error message.

"An error occurred while sending your post

We're sorry, but there was a problem with the system and your post was not
received. The error has been reported to Operations and will be investigated
as soon as possible. Please try again later."

This means, that to respond we need to start a separate thread - which is a
bad practice and wastes time.

 

[Shane Devenshire]

Smartin,

How come you have a message in the body of your response that is not in the
OP?

Cheers,
Shane Devenshire