5g: MLookupλ()

Description

MLookupλ() is a multi-value, multi-column lookup function that returns one value or an array. We can have up to four search criteria with each criteria containing one or more values to find in a given column. We can return a single column's matching value(s), or multiple columns' matching values, or the entire table's or array's matching rows.

Click here to download MLookupλ() example Workbook.

Syntax

MLookupλ( ReturnArray, FindValues1, InArray1, [FindValues2], [InArray2], [FindValues3], [InArray3], [FindValues4], [InArray4])

Arguments

ReturnArray

(Required) A column or array to return matching values.

FindValues1

(Required) A single value to find, an array of values to find, or a comma separated list of values to find in InArray1.

InArray1

(Required) A column or array of values to search using FindValues1.

FindValues2

(Optional) A single value to find, an array of values to find, or a comma separated list of values to find in InArray2.

InArray2

(Optional) A column or array of values to search using FindValues2.

FindValues3

(Optional) A single value to find, an array of values to find, or a comma separated list of values to find in InArray3.

InArray3

(Optional) A column or array of values to search using FindValues3.

FindValues4

(Optional) A single value to find, an array of values to find, or a comma separated list of values to find in InArray4.

InArray5

(Optional) A column or array of values to search using FindValues4.

Example

In this example we want to know what the price is for red apples from Mexico.

In this example we want a list of countries where we source red apples and grapes from.

In this example we want a list of everything we source from Peru along with descriptions and pricing.

Page updated

Google Sites

Report abuse