hi guys!
I've been trying to do the next without success. i'm desperate!
The user type a number in cell J5 ... The function has to look for the closest larger value in column A then it takes the value that is in the same row but in the column B and copy this value in the cell K5.
The table is:
0.5000 0.0030
0.6660 0.0085
1.0000 0.0220
1.5000 0.0420
2.0000 0.0560
2.5000 0.0630
3.0000 0.0670
the user type for example 1.25 in cell J5 and the function gets 0.0420 in K5
Thanks for your help.
Bookmarks