Hi,

For the lower match

=VLOOKUP(95,A1:A6,1,TRUE)

for the higher match the array formula

=MIN(IF(A1:A6=95,A1:A6))

This is an array formula which must be entered with CTRL+Shift+Enter and NOT
'just enter. If you do it correctly then Excel will put curly brackets around
'the formula{}. You can't type these yourself. If you Edit the ranges
'then you must re-enter as An array

Both will return an exact match if there is one.



Mike





"Soccer boy" wrote:

I am wanting to retreive data from an inputted list. What i want to do is
input a number and have the function give me the next highest and lowest
number.
Say for example

90
92.5
93.1
94.7
96.2
98.3

and i enter the number 95. the result should give me the values of 94.7 and
96.2. is this possible to do.