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 the value(s) are returned, they appear in a vector in column-wise order, starting with the top left corner of B and sweeping down.

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 the value(s) 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 the value(s) 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 the value(s) are returned, they appear in a nested array in column-wise order, starting with the top left corner of A and sweeping down.

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

Arguments:

Notes:

QuickSheet