Excel formula get value just greater than an other

Question

I was wondering how to retrieve the smallest value greater than an other one.

To my knowns :

Using an approximate match,VLOOKUP searches for the value X in column A, finds the largest value less than or equal to X in column A.

What would be the equivalent of VLOOKUP in order to find the smallest value greater than or equal to x

Example : In this table if my value is -0,322

VLOOKUP returns : -0,362

Which Formula would return :-0,317 ?

Answer 1

We can use the Search function in Excel to find a value that equals a specified value, however it will return nothing if there are no values that exactly match the lookup value. Have you ever attempted to determine the closest value that is larger than or less than a certain amount, as shown in the screenshot below? In this tutorial, I'll show you how to use Excel formulas to get the closest number that is more or less than the lookup value.

Locate the Lowest Price More than
Select a blank cell for the lookup result, type 

=MIN(IF(A1:B6>E1,A1:B6)) 

Hit  Shift + Ctrl + Enter at the same time. Take a look at this image:

The range you want to locate value in is A1:B6, and the value you want to search for is E1.