VlookupDouble function (VLOOKUP3) for Excel (Calc)

VLOOKUPDOUBLE() Description

The built-in function VLOOKUP is one of the most powerful functions in Excel (Calc) . But it has some drawbacks - it compares values in only one column and only in the leftmost column. But what if you need to compare values in 2 columns and not just in the first column?

The modified VLOOKUPDOUBLE function searches for two conditions in two different columns of a table simultaneously.

Main Features of the VLOOKUPDOUBLE Function

Syntax:

=VLOOKUPDOUBLE(LookupValue1; LookupArray1; LookupValue2; LookupArray2; ReturnArray)

Parameters:

• LookupValue1: The value 1 we are looking for.
• LookupArray1: Column 1, in which we perform the search.
• LookupValue2: The value 2 we are looking for.
• LookupArray2: Column 2, in which we perform the search.
• ReturnArray: The column from which we return a value that is associated with two conditions at the same time.

Example Usage

The VLOOKUPDOUBLE() function is easy to use. You just need to specify 2 separate ranges to search, 2 values to compare, and the column from which to return related values and Excel (Calc) will automatically find and return the required result based on two matches:

=VLOOKUPDOUBLE(LookupValue1; Lookup Array1; LookupValue2; Lookup Array2; Return Array)

We will have the following result:

This example uses the following values:

• LookupValue1: A3 - The value 1 we are looking for ("John") .
• LookupArray1: A11:A20 - Range 1 for search ({Lookup Array1}) .
• LookupValue2: B3 - The value 2 we are looking for ("001") .
• LookupArray2: B11:B20 - Range 2 for search ({Lookup Array2}) .
• ReturnArray: C11:C20 - The range from which we return the value ({Return Array}) .

Download extension

You can use the function VLOOKUPDOUBLE() by installing the extension YLC Utilities .

Or its free version YouLibreCalc .

Or its free version YouLibreCalc .

After that, this function will be available in all files that are opened in Excel (LibreOffice Calc) .