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
|