look up number in column

[Guest]

I have a spread sheet with three columns. I need to type a number and look up
a number in a cell. My objective is to look up number a column and retreive
the next largest number from that cell. Ignoring remaining numbers in the
column. The column is in ascending order.

cell k10: input number cell example 500
column a: b: c:
1 44 200
2 35 330
3 44 485
4 38 499
5 28 510
6 55 590

I need to return the number 510

thanks Jimmy Lavoie

 

[KL]

Hi,

Try this:

=INDEX($C$1:$C$6,MATCH(K10,$C$1:$C$6)+1)

Regards,
KL

 

[Guest]

THANKS!!

Hi,

Try this:

=INDEX($C$1:$C$6,MATCH(K10,$C$1:$C$6)+1)

Regards,
KL