Related Topics:

Function Wizard Functions

LOOKUP

Description: Based on a range of one row or one column, returns the value from the same position in a second row or column OR looks in the first row or column of an array, and returns the specified value from the same position in the last row or column of the array. The LOOKUP function has two syntax forms: vector and array.

Tip: In general, it's best to use the HLOOKUP or VLOOKUP function instead of the array form of LOOKUP. This form of LOOKUP is provided for compatibility with other spreadsheet programs.

Syntax (vector): LOOKUP(Lookup_value, L_vector, [Result_vector])

Important: The values in L_vector must be placed in ascending order: ...,-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise, LOOKUP may not give the correct value. Uppercase and lowercase text are equivalent.

Remarks (vector):

Example (vector):

  A B
1 Frequency Color
2 4.14 red
3 4.19 orange
4 5.17 yellow
5 5.77 green
6 6.39 blue blue

 

Syntax (array): LOOKUP(Lookup_value, Array)

Remarks (array):

If Array covers an area that is wider than it is tall (more columns than rows), LOOKUP searches for Lookup_value in the first row.

If Array is square or is taller than it is wide (more rows than columns), LOOKUP searches in the first column.

With HLOOKUP and VLOOKUP, you can index down or across, but LOOKUP always selects the last value in the row or column.

Important: The values must be placed in ascending order: ...,-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise, LOOKUP may not give the correct value. Uppercase and lowercase text are equivalent.

Example (array):

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.