On Mon, 2 Mar 2009 09:19:01 -0800, Raz wrote:

Hi, Thanks in advance if you can help.

I need two seperate equations to find the number above and below a specific
number from a list of numbers in accending order.

for example my specific number is 875, I need to find the number (only one
number) which is immediately less than 875, and the number that is
immidiately higher than 875 from the list below.

The two equations should give me 850 and 900 in seperate cells.

500
550
600
650
700
750
800
850
900
950
1000

What do you want to return if the Specific Number is exactly equal to a member
in the List of Numbers?

To return either the Same number (if Specific Number is present in the List) or
the next lowest number (if Specific Number is NOT present in the list):

=VLOOKUP(SpecNum,ListOfNums,1)

To return the next higher number:

=INDEX(ListOfNums,1+MATCH(SpecNum,ListOfNums),1)

The formulas will return error messages if specific number is not within the
range of the List of Numbers.
--ron