Microsoft Office Tutorials and References
In Depth Information
Looking up information in a worksheet
Looking up information in a worksheet
Whenever you create a worksheet that holds information about a list of distinct items, such
as products offered for sale by a company, you should ensure that at least one column in
the list contains a unique value that distinguishes that row (and the item the row represents)
from every other row in the list. Assigning each row a column that contains a unique value
means that you can associate data in one list with data in another list. For example, if you
assign every customer a unique identification number, you can store a customer’s contact
information in one worksheet and all orders for that customer in another worksheet. You
can then associate the customer’s orders and contact information without writing the
contact information in a worksheet every time the customer places an order.
In the case of shipments handled by Consolidated Messenger, the column that contains
those unique values, also known as the primary key column , is the ShipmentID column.
6
If you know a shipment’s ShipmentID, it’s no trouble to look through a list of 20 or 30 items
to find a particular shipment. If, however, you have a list of many thousands of shipments,
looking through the list to find one would take quite a bit of time. Instead, you can use the
VLOOKUP function so that your colleagues can enter a ShipmentID in a cell and have the
corresponding details appear in another cell.
Search JabSto ::




Custom Search