## Array form

**TIP:** We strongly recommend using **VLOOKUP** or **HLOOKUP** instead of the array form. **See this video about VLOOKUP; it provides examples**. The array form of **LOOKUP** is provided for compatibility with other spreadsheet programs, but it’s functionality is limited.

The array form of **LOOKUP** looks in the first row or column of an array for the specified value and returns a value from the same position in the last row or column of the array. Use this form of **LOOKUP** when the values that you want to match are in the first row or column of the array.

### Syntax

LOOKUP(lookup_value, array)

The **LOOKUP** function array form syntax has these arguments:

**lookup_value**Required. A value that**LOOKUP**searches for in an array. Theargument can be a number, text, a logical value, or a name or reference that refers to a value.*lookup_value*- If
**LOOKUP**can’t find the value of, it uses the largest value in the array that is less than or equal to*lookup_value*.*lookup_value* - If the value of
is smaller than the smallest value in the first row or column (depending on the array dimensions),*lookup_value***LOOKUP**returns the #N/A error value.

- If
**array**Required. A range of cells that contains text, numbers, or logical values that you want to compare with lookup_value.The array form of**LOOKUP**is very similar to the**HLOOKUP**and**VLOOKUP**functions. The difference is that**HLOOKUP**searches for the value ofin the first row,*lookup_value***VLOOKUP**searches in the first column, and**LOOKUP**searches according to the dimensions of array.- If array covers an area that is wider than it is tall (more columns than rows),
**LOOKUP**searches for the value ofin the first row.*lookup_value* - If an array is square or is taller than it is wide (more rows than columns),
**LOOKUP**searches in the first column. - With the
**HLOOKUP**and**VLOOKUP**functions, you can index down or across, but**LOOKUP**always selects the last value in the row or column.**IMPORTANT:**The values in array must be placed in ascending order: …, -2, -1, 0, 1, 2, …, A-Z, FALSE, TRUE; otherwise,**LOOKUP**might not return the correct value. Uppercase and lowercase text are equivalent.

- If array covers an area that is wider than it is tall (more columns than rows),