function exists?

[Francisco Costa]

Greetings,

In one column I have a list of numbers (1, 3, 5, 6, 7 and
10), in other cell I have a grade (4).
Is there a function that can compare all values of the
column with the cell, and put ONLY the first greater
number in a nearby cell?

Thanks,
Francisco

 

[Paul]

Greetings,

In one column I have a list of numbers (1, 3, 5, 6, 7 and
10), in other cell I have a grade (4).
Is there a function that can compare all values of the
column with the cell, and put ONLY the first greater
number in a nearby cell?

Thanks,
Francisco

Suppose your list is in A1:A6 and your grade in B1. Try this formula:
=MIN(IF(A1:A6>$B$1,A1:A6))
This has to be array-entered. Use CTRL+SHIFT+ENTER rather than just ENTER.

 

[Ken Wright]

With your numbers in A1:A20 in ascending order, and your grade value in C5, then in say D5 you
could use:-

=INDEX($A$1:$A$20,MATCH($C$1,$A$1:$A$20)+1)

 

[Peo Sjoblom]

Not function per say but formula

=INDEX(A1:A10,MATCH(SMALL(A1:A10,COUNTIF(A1:A10,"<"&C1)+1),A1:A10,0))

where A1:A10 is your numbers and C1 holds the lookup (4 in your example)

 

[Felipe]

Francisco:

If list is in cells A1:A6 and lookup value is in B1. Use
the following:

=INDEX($A$1:$A$6,MATCH(B1,$A$1:$A$6,1)+1)

Regards,
Felipe