VlookupDouble function for Excel (VLOOKUP3)

VLOOKUPDOUBLE() Description

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

The modified function VLOOKUPDOUBLE searches for two conditions in two different columns of the table at the same time.

Main Features Functions VLOOKUPDOUBLE

Syntax:

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

Parameters:

• LookupValue1: The value 1 we are looking for.
• LookupArray1: Column 1, in which we search.
• LookupValue2: The value 2 we are looking for.
• LookupArray2: Column 2, in which we search.
• ReturnArray: The column from which we return the 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 a column from which the related values will be returned and Excel will automatically find and return the required result on two matches:

=VLOOKUPDOUBLE("John"; {Lookup Array1}; "001"; {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 to search ({Lookup Array1}) .
• LookupValue2: B3 - The value 2 we are looking for ("001") .
• LookupArray2: B11:B20 - Range 2 to search ({Lookup Array2}) .
• ReturnArray: C11:C20 - The range from which we return the value ({Return Array}) .

Download the extension

You can use the VLOOKUPDOUBLE() function by installing a free extension YouLibreCalc.xlam .

After that, this function will be available in all files that will be opened in Excel.