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
vertical - as described above
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
