Excel 2000 in a Nutshell

Name

LOOKUP

Synopsis

Use LOOKUP to return a value either from a specific row or column or from an array of cells. When you return a value from a single row or column it is referred to as a vector lookup in Excel.

Excel provides two forms of the LOOKUP function, one for vectors and another for arrays. The vector form of the function returns the value in the second row or column of the specified range. The array form of the function finds the specified value in the first row or column of the array and then returns the last value in the corresponding row or column.

To Calculate (Vector)

=LOOKUP(Lookup_Value, Lookup_Vector, Result_Vector)

Use this form of the function when dealing with vectors. All arguments are required for the function.

Lookup_Value

Indicates the value that you want to locate in a row or column range specified by Lookup_Vector. This value can be a number, text, logical value, or a reference.

Lookup_Vector

Indicates the range of cells that you want to search for the value specified for the Lookup_Value argument. This argument can only specify a single row or column. If the function does not find a match, it uses the largest value that is smaller than Lookup_Value.

Note

The values in the row or column specified by Lookup_Vector must be sorted into ascending order (i.e., 1,2,3,.., A-Z, FALSE, and TRUE).

Result_Vector

Must indicate a row or column of the same size as the range specified for the Lookup_Vector argument that contains the values to be returned.

To Calculate (Array) ...