Microsoft Office Tutorials and References

In Depth Information

**Looking up information in a worksheet**

3

In cell
C3
, edit the formula so that it reads
=VLOOKUP(B3, Shipments, 2, FALSE)
.

The formula now finds its target value in table column 2 (the
CustomerID
column), so

the value
CI512191
appears in cell
C3
.

4

In cell
C3
, edit the formula so that it reads
=VLOOKUP(B3, Shipments, 4, TRUE)
.

Changing the last argument to
TRUE
enables the
VLOOKUP
formula to find an

approximate match for the
ShipmentID
in cell
B3
, whereas changing the column to
4

means the formula gets its result from the
OriginationPostalCode
column. The value

14020
appears in cell
C3
.

5

In cell
B3
, enter
SI3049209
. The value in cell
B3
is smaller than the smallest value in

the
Shipments
table’s first column, so the
VLOOKUP
formula displays the
#N/A
error

code in cell
C3
.

6

In cell
B3
, enter
SI3049245
. The
ShipmentID
entered into cell
B3
is greater than the

last value in the table’s first column, so the
VLOOKUP
formula displays the last value

in the target column (in this case, the fourth column). Therefore, the incorrect value

44493
appears in cell
C3
. The error occurs because the
range_lookup
argument is set

to
TRUE
.

CLEAN UP
Close the ShipmentLog workbook, saving your changes if you want to.