Lookup Functions

lookup(z, A, B) Looks in a vector or matrix, A, for a given value, z, and returns the value(s) in the same position(s) (that is, with the same row and column numbers) in another matrix, B. When multiple values are returned, they appear in a vector in row-wise order, starting with the top left corner of B and sweeping to the right.

hlookup(z, A, r) Looks in the first row of a matrix, A, for a given value, z, and returns the value(s) in the same column(s) in the row specified, r. When multiple values are returned, they appear in a vector, starting from the left.

vlookup(z, A, c) Looks in the first column of a matrix, A, for a given value, z, and returns the value(s) in the same row(s) in the column specified, c. When multiple values are returned, they appear in a vector, starting from the top.

match(z, A) Looks in a vector or matrix, A, for a given value, z, and returns the index (indices) of its position(s) in A. When multiple values are returned, they appear in a nested array in row-wise order, starting with the top left corner of A and sweeping to the right.

The degree of precision to which the comparison adheres is determined by the TOL setting of the worksheet.

Arguments:

• z is a real or complex number, or string.
• A, B are real, complex numbers or strings, m x n matrices or vectors.
• r, c are integers; ORIGIN ≤ r ≤ ORIGIN + (n − 1), ORIGIN ≤ c ≤ ORIGIN + (n − 1).

Notes:

• Matrix and vector elements, rows, and columns are numbered starting with zero, unless you change the ORIGIN.
• The value z is considered to match within the tolerance, TOL, set for the worksheet. Reducing this value makes the match more strict; increasing it makes the match less so.
• Related to the sorting functions.

QuickSheet