Help. Trying to do the opposite of VLOOKUP
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.
|