This and more Excel tips can be found on http://www.contextures.com/tiptech.html
Excel VLOOKUP Function and VLOOKUP Example
In a workbook, you can create a table that stores information about your products, or employees, or other data you want to refer to frequently. From other cells in the workbook, you can use an Excel VLOOKUP formula to look up data from the master table.