You're welcome. Thanks for the feedback!
On Thu, 03 Mar 2011 00:58:51 GMT, Santiago Castro wrote:
I need to solve something similar but more complicated:
I have the following data:
Aug-99 Jul-99 Jun-99 May-99 Apr-99 Mar-99 Feb-99
6.92 6.90 6.88 6.86 6.86 6.84 6.79
What I need is find next biggest number to 6.87, but I nee excel to look for it in order according to the date to which each number is related. So the formulea needs to go first to Feb-99, look at the number below (6.79) and compare it to 6.83. Since the 6.79 is below 6.83, then go to Mar-99 and do the same and so on until it finds 6.88 (under Jun-99). PLEASE HELP!!!
If I may restate your problem, is it the same as:
Return the value in the rightmost column that is greater than 6.87
??
If that is the case:
Your number values are in Row 4
The 6.87 is in A8
You may try this formula: =LOOKUP(2,1/($4:$4A8),$4:$4)
|