Microsoft Office Tutorials and References
In Depth Information
Looking up information in a worksheet
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 .
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 .
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 .
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.