1. Home
  2. Computing & Technology
  3. Spreadsheets

Excel's Lookup and Reference Functions

Excel's Lookup and Reference Functions can be used to simplify finding specific entries in a data table.
Excel 2007 VLOOKUP Function
Excel's VLOOKUP function is used to find specific information that has been stored in columns in a table of data. This article walks you through an example of using the VLOOKUP function in Excel 2007.
Excel 2007 VLOOKUP Step by Step
Excel’s VLOOKUP function can be used to find specific data that is stored in a spreadsheet table. This article includes a step by step example of using Excel's VLOOKUP function.
Excel 2007 HLOOKUP Function
Excel's HLOOKUP function is used to find specific information that has been stored in rows in a table of data. This article walks you through an example of using the HLOOKUP function in Excel 2007.
Excel VLOOKUP
Excel’s VLOOKUP function is used to find specific information that has been stored in a spreadsheet table. This article covers in detail how to create a VLOOKUP function in Excel.
Excel HLOOKUP
Excel’s HLOOKUP function is used to find specific information that has been stored in a spreadsheet table. This article covers in detail how to create a HLOOKUP function in Excel.
Excel 2007 TRANSPOSE Function
The TRANSPOSE function, one of Excel's Lookup & Reference functions, is used to transfer data located in a row into a column or data located in a column into a row.
Explore Spreadsheets
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Excel Functions
  5. Lookup Functions

©2009 About.com, a part of The New York Times Company.

All rights reserved.