View Single Post
  #1   Report Post  
eioval
 
Posts: n/a
Default 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