Using the LOOKUP Function

Contact Us or call 1-877-932-8228
Using the LOOKUP Function

Using the LOOKUP Function

The LOOKUP function returns a value either from a one-row or one-column range or from an array. The LOOKUP function has two syntax forms: the vector form and the array form.

The LOOKUP function is used to pull a value from a range that is one row or one column, or from an array. It has two syntaxes: vector and array.

To use the LOOKUP function, you need to know:

  1. Lookup value. The value you will use to identify individual records in your table.
  2. Lookup vector. For a vector syntax, this will be a range that contains one row or column.
  3. Array. For an array syntax, this is the range you want to compare with the lookup value.

To use the LOOKUP function:

  1. On the FORMULAS tab, in the Function Library group, click the Insert Function command:Insert Function Command
  2. In the Insert Function dialog box:
    1. Search on "LOOKUP" or, in the Or select a category drop-down box, select Lookup & Reference.
    2. Under Select a function, select LOOKUP.
    3. Click OK.OK Option
    4. In the Select Arguments dialog box, choose a vector or array syntax and click OK. Syntax
  3. In the Function Arguments dialog box (the following is for a vector):
    1. Enter the Lookup_value.
    2. Enter the Lookup_vector.
    3. Enter the Result_vector.
    4. Click OK.OK Option