What should happen if/when the lookup number is less than the lowest number
in the list? What should happen if/when the lookup number is greater than
the highest number in the list? What if the lookup number equals the lowest
number in the list? What if the lookup number equals the highest number in
the list?

Biff

"Eric" wrote in message
...
Does anyone have any suggestions on how to determine the values from a
list?
such as following example

Under column A
There are some values listed from cell A1 to A7
10,20,30,40,50,60,70

In cell B1, there is a given value 35, I need to determine the upper and
lower values based on the given one.
In cell C1, it returns 30 and in cell C3, it returns 40.

If the given value from B1 is 40, then
In cell C1, it returns 30, and in cell C2, it returns 40 and in cell C3,
it
returns 50.

For the cell C1, it displays the lower value based on the given one.
For the cell C2, it displays the given value if it equals to the given
one,
else display nothing.
For the cell C3, it displays the upper value based on the given one.

Does anyone have any suggestions on how to determine the values from a
list?
Thank for any suggestions
Eric