LOOKUP

Maps rows from a range according to a column of key values.

Syntax

LOOKUP(keyColumn; rangeKeys; range; orientation)

  • keyColumn - the column defining the order how the rows of range are returned - Value type: column range

  • rangeKeys - the column to search for the keys of keyColumn - Value type: column range

  • range - the range from which the rows are returned in the order defined by keyColumn - Value type: range

  • orientation - the orientation of the LOOKUP operation - Value type: constant (optional, default value: vertical) Possible values are

    1. vertical - as described above

    2. horizontal - the LOOKUP function maps columns instead of rows of range to the key values. In this case, a row range is used for the parameters keyColumn and rangeKeys.

Remarks

  • If rangeKeys has duplicated values,

    • numeric cells are summarized

    • the first non-numeric cell value (from top to bottom) is returned in the return range

Example

Last updated