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
|