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 ?

Apr 5, 2022 in Database 855 views

## 1 answer to this question.

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.

• 22,960 points

## How to get the "Name Box" name of an Excel cell?

By typing in the Name Box, you ...READ MORE

## Are there such things as variables within an Excel formula?

Yes. However, not directly. a less complicated method You ...READ MORE

## Insert a value to a cell in excel using formula in another cell

Select the cell where the formula should ...READ MORE

## What is the SQL query to get the third highest salary of an employee from employee_table

You can try out something like this: SELECT ...READ MORE

## Reading Excel File using Python, how do I get the values of a specific column with indicated column name?

So the key parts are to grab ...READ MORE

## How to get address, Column Name and Row Name of all marked rows in Excel table as rows in new worksheet

need the row/column combinations marked with an ...READ MORE

## MS Excel - SumProduct formula with Loop

Drag this to the right of cell ...READ MORE