Hi

Given a number I want to look up what number in a list is just greater
and just less than my original number.

Ex. Given number 55 look at the following list of values:

22
33
44
55
66
77

and in one cell return 44 and another 66. Seems easy but I can't get
it. Thanks.


--
jpx
------------------------------------------------------------------------
jpx's Profile: http://www.excelforum.com/member.php...fo&userid=1013
View this thread: http://www.excelforum.com/showthread...hreadid=398709