Originally Posted by plinius

Il 09/11/2012 06:36, Randy Sauve ha scritto:
I have a specific number X in a cell and in the column beside I have a
list of data that ranges from smalles to largest. I need to find a
number in that column the is = or than X. the number should be the
closest number to X but greater.

Any ideas?





The number to find is in A1, rng is the list:

=INDEX(rng,IF(MATCH(A1,rng)=MATCH(A1,rng,0),MATCH( A1,rng),MATCH(A1,rng)+1))

Hi,
E.