VlookupDouble (VLOOKUP3) Function

VLOOKUPDOUBLE() Description

The built-in VLOOKUP function is one of the most powerful functions in Excel (Calc). But it has some drawbacks - it compares values only in 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 by two conditions in two different table columns simultaneously.

Key Features of the VLOOKUPDOUBLE Function

Syntax:

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

Parameters:

• LookupValue1: Value 1 to search for.
• LookupArray1: Column 1, in which we search.
• LookupValue2: Value 2 to search for.
• LookupArray2: Column 2, in which we search.
• ReturnArray: Column from which we return the value that is related to two conditions simultaneously.

Usage Example

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

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

We will have the following result:

In this example, the following values are used:

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

Download extension

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

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