Microsoft Office Tutorials and References
In Depth Information
LOOK UP INFORMATION
in your worksheet
By using the VLOOKUP function, you can enter a
product’s ID and retrieve its price. Use VLOOKUP
when you know one value, such as the product ID,
and need to look up another value, such as price.
Before you can use VLOOKUP , you must sort your list
in ascending order, and the first column of your list
must contain the values you want to use to retrieve
another value. Specify the column from which you
want to retrieve the corresponding value.
You can use the Function Wizard to enter your
VLOOKUP arguments. You must enter three required
arguments: the cell address containing the value you
want to use to retrieve another value, the list’s cell
range, and the column that contains the value you
want to retrieve. For simplicity, call the first column
in the list 1, the second column 2, and so on.
The VLOOKUP function has an optional fourth
argument called range lookup. If you enter TRUE or
leave this argument blank, the function looks for the
closest match to the value you seek. If you enter
FALSE, the function returns only exact matches.
Type the value you want to use
to retrieve another value.
In an adjacent cell, type
As you begin to type, the
Function AutoComplete list
appears. Double-click an
option to select it.
Click the Insert Function button.
l The Function Arguments dialog
box for VLOOKUP appears.
Click in the cell with the value
entered in Step 1 or type the cell
Click and drag to select all the
values in the list, or type the cell
Type the number of the column
containing the value you want to