Another set of alternatives with dara in A1:A6 and B1=95:

=LOOKUP(B1,A1:A6)
=LOOKUP(2,1/FREQUENCY(B1,A1:A6),A1:A6)

"Soccer boy" wrote in message
...
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.