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 disadvantages - it compares values in only one column. But what if you need to compare values in multiple columns at once?

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

Main Features Functions VLOOKUPMULTI


=VLOOKUPMULTI(LookupValue; LookupArray; ReturnArray)


Example Usage

The VLOOKUPMULTI() function is easy to use. You just need to specify the range to search, which can include many columns and the column from which the associated 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:

VLOOKUPMULTI formula usage

This example uses the following values:

Extension "YouLibreCalc.oxt"

You can use the function VLOOKUPMULTI() by setting the extension " YouLibreCalc.oxt ". After that, this function will be available in all files that will be opened in LibreOffice Calc.