I'm using the vlookup function to pull numbers off an array. Is there a way that I can get the vlookup function to pick the smallest number greater than or equal to my Look_up value. If not is there a function that can do that?
What I have for syntax is VLOOKUP(1.2,B3:C46,2). Which will look for the number 1.2 or the next smallest number in the specified column. What I want is to find 1.2 or the next largest number in the column. Is there any way that can be done?
I am looking up values in column B and using the corresponding value in column C. The number I want is 1.2 in column B, but if that number isn't there I'd like to get the next higher value and the next lower value. I can get the the next lower value (1.111 which will then give me .443 out of column C) but can't get the next higher value (1.248 in this case which would correspond with .581 in column C).