VlookupMulti function for LibreOffice Calc (VLOOKUP4)

VLOOKUPMULTI() Description

The built-in function VLOOKUP is one of the most powerful functions in LO Calc. But it has some drawbacks - it compares values in only one column. But what if you need to compare values in multiple columns at the same time?

The modified VLOOKUPMULTI function searches for a specified value in a range with multiple columns.

Main Features of the VLOOKUPMULTI Function

Syntax:

=VLOOKUPMULTI(LookupValue; LookupArray; ReturnArray)

Parameters:

• LookupValue: The meaning we are looking for.
• LookupArray: A multi-column range in which to search.
• ReturnArray: The column from which we return the associated value.

Example Usage

The VLOOKUPMULTI() function is easy to use. You just need to specify the range to search, which can include multiple columns, and the column from which the related value will be returned, and LibreOffice Calc will automatically find and return the required result:

=VLOOKUPMULTI("US"; {Lookup Array}; {Return Array})

We will have the following result:

This example uses the following values:

• LookupValue: A3 - The value we are looking for ("US") .
• LookupArray: A12:C25 - Search range consisting of 3 columns ({Lookup Array}) .
• ReturnArray: D12:D25 - The range from which we return the value ({Return Array}) .

Download extension

You can use the VLOOKUPMULTI() function by installing the free extension YouLibreCalc.oxt or its full-featured version YLC_Utilities.oxt .

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