Microsoft Office Tutorials and References
In Depth Information
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.