Sort the data descending, then assuming the test value is in B1, use

=MATCH(B1+1,A:A,-1)

--
HTH

-------

Bob Phillips
"pugsly8422" wrote in message
...
I have a list of 99 different numbers. In one cell a person can type in a
number, and after they do that I want it to pick the smallest number that
is
larger than the one they listed. For example:

The list is 1,2,3,4,5

They enter 3

I want it to pick 4 since that is the smallest number that is larger than
the one they entered.

Thanks for any assistance.