Page 89 - Excel Data Analysis

05 537547 Ch04.qxd 3/4/03 11:52 AM Page 75

CREATING FORMULAS 4

When looking up specific values in a data list, Excel provides another function
that you can use to return values called the LOOKUP function. You can use
the LOOKUP function when you do not know the row or column location of
the value you want to locate. The LOOKUP function provides two formats, a
vector format and an array format.
With the vector format, you can specify a value you want to locate and the
column or row in which you want to locate it. You also specify the column or
row containing the matching value you want to return. The vector format of the
function has the following syntax with an optional Result_vector parameter:

Example:
=LOOKUP(Lookup_value, Lookup_vector, [Result_vector])
For example, if you specify a value of 11 for the Lookup_value, with a
Lookup_vector of column A and a Result_vector of column C, Excel returns
the value in column C located on the same row and the value 11 in column A.
The array format finds the values you specify in the first column and returns
the value on the same row in the last column of the specified range in the
Array field. This version of the function has the following syntax:

Example:
=LOOKUP(Lookup_value, Array)

Á Specify the column ■ For VLOOKUP, specify the ■ The value in the specified
heading value in the column number. row and column displays in
Lookup_value field. the selected formula cell.
■ If desired, type False in
‡ Specify the range of cells the Range_lookup field to
for the data list in the find an exact match for the
Table_array field. Lookup_value argument.
° Specify a number · Click OK.
representing the desired row
in the Row_index_num field. 75