I am using VLOOKUP with the not_exact_match set to True, however instead of finding the next largest value that is less than value, I want to find a way of returning the next largest value that is greater than value. I have looked at using MATCH and OFFSET to try and increment the returned value by 1, but so far haven't managed to figure this out.
Can anyone suggest a way to achieve this.
Many thanks
Bookmarks