look up number in column
 

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

Hi,

Try this:

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

Regards,
KL


"eioval" wrote in message
...
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

THANKS!!

"KL" wrote:

Hi,

Try this:

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

Regards,
KL


"eioval" wrote in message
...
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