http://www.computergaga.com/excel/2007/foundation/managing_worksheets/splitting_freezing_panes.html Freeze headers in Excel with this tutorial. Freeze headers in Excel so they are always visible in a worksheet.
Use the Vlookup formula in Excel 2007 with this tutorial. Use the Vlookup formula to search for and return data from a range of cells. See more Excel 2007 formulas at http://www.computergaga.com/excel/functions/