Search and reference functions. Use the LOOKUP function to find data quickly.

• Picture and text skills
• Case

Returns the numeric value in a vector or array. The function LOOKUP has two syntax forms: vector and array.

Tip: The values ​​of LOOKUP_vector must be sorted in ascending order: ..., -2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE;

Otherwise, the function LOOKUP cannot return the correct result. The text is not case sensitive.

1. Vector form

A vector is a range containing only one row or column.

The vector form of the LOOKUP function searches for values ​​in a single row or column range (vector).

Thenreturns the value at the same position in the second single-row range or single-column range.

If you need to specify a range containing the value to be found, you can use this form of the LOOKUP function.

Another form of the LOOKUP function automaticallyfinds a value in the first column or row.

Syntax
LOOKUP(lookup_value,lookup_vector,result_vector)
￭ Lookup_value is the value that the function LOOKUP is looking for in the first vector.

lookup_value can be a number, text, logical value, ora name or reference containing a numeric value.

￭ Lookup_vector is an area containing only one row or column. The values ​​of lookup_vector can be text, numbers, or logical values.
￭ < /span>Result_vector contains a range of only one row or column and must be the same size as the lookup_vector.

Description
￭ If function LOOKUP cannot find lookup_value , then find the largest value in lookup_vector that is less than or equal to lookup_value.
￭ < /span>If lookup_value is less than the minimum value in lookup_vector, function LOOKUP returns error value #N/A.

2. Array form

The array form of function LOOKUP searches for the specified value in the first row or column of the array.

Then returns the value at the same position in the last row or column.

If the value you need to find is in the first row or column of the array, you can use this form of the LOOKUP function.

Other forms of the LOOKUP function can be used when you need to specify the position of a columnor row.

Syntax
LOOKUP(lookup_value,array)
Lookup_value is the value that the function LOOKUP is looking for in the array. It can be a number, text, logical value, or a name or reference containing a value.

Description

￭ If the function LOOKUP cannot find lookup_value, the largest value in the array that is less than or equal to lookup_value is used.

￭ If lookup_value is less than the minimum value of the first row or column (depending on the dimension of the array), the function LOOKUP returns the error value #N/A.
Array is a cell range containing text, numbers or logical values, and its value is used for comparison with lookup_value.

The function LOOKUP'sformformula is very similar to the function HLOOKUP and the function VLOOKUP.

The difference is that the function HLOOKUP looks for lookup_value in the first row, and The function VLOOKUP looks for the first column.

The function LOOKUP searches according to the dimensions of the array.

￭ If the area contained by the array is large in width and small in height (that is, there are more columns than rows), the function LOOKUP searches for lookup_value in the first row.

￭ If the array is a square, or the area it contains is large in height and small in width (that is, the number of rows exceeds the number of columns), the function LOOKUP searches in the first column

lookup_value.

￭ The HLOOKUP and VLOOKUP functions allow indexing by row or column, while the LOOKUP function always selects the last value of a row or column.