Send to a Friend via Email

Your suggestion is on its way!

An email with a link to:

was emailed to:

Thanks for sharing About.com with others!

Excel's Lookup and Reference Functions

Excel's Lookup and Reference Functions can be used to simplify finding specific entries in a data table. There are tutorials listed for the latest three versions of Excel: Excel 2010, 2007, and Excel 2003.

Excel VLOOKUP Step by Step Tutorial
Excels VLOOKUP function is used to find specific information that has been stored in a spreadsheet table. This tutorial includes a step by step example.

Excel HLOOKUP Step by Step Tutorial
This tutorial covers how to use HLOOKUP to find specific data that is stored in an Excel database. This tutorial includes a step by step example of how to use the HLOOKUP function in Excel.

Excel Two Way Lookup Using VLOOKUP Part 1
This tutorial covers creating a two way or two dimensional lookup formula using the VLOOKUP and MATCH functions in Excel.

Excel Two Way Lookup Using VLOOKUP Part 2
Part 2 of the step by step two way lookup formula using the VLOOKUP and MATCH functions in Excel.

Find Multiple Fields of Data with Excel VLOOKUP
How to create a lookup formula to return multiple fields of data from a single row of a data table.

Lookup with Multiple Criteria in Excel
One limitation of VLOOKUP is that it will only match data in a single criterion in a database. By using an array formula in Excel we can create a lookup formula that will allow multiple criteria to find information in a database or list of data.

Excel Left Lookup Formula Using VLOOKUP
This tutorial covers creating a left lookup formula, which can find data in columns to the left of the lookup value. This formula includes the VLOOKUP and CHOOSE functions.

Using a Dynamic Range in Excel Formulas
Excel's INDIRECT function makes it easy to create a dynamic range of cell references in formulas. This tutorial combines INDIRECT with the SUM function to create an easy way to change the range of data added up by the formula

Excel VLOOKUP Function Tutorial Text-only Version
Excel's VLOOKUP function is used to find specific information that has been stored in columns in a table of data.

Excel LOOKUP Function Tutorial - Array Form
The Array Form of Excel's LOOKUP function will return a single value from a multi-row or multi-column range of data.

Excel LOOKUP Function - Vector Form
The Vector form of the LOOKUP function can be used to find a single value from a one-row or one-column range of data.

Excel INDEX Function - Array Form
The INDEX function uses row and column numbers from an array to return the name of a specific item of data.

Excel MATCH Function Tutorial
The Excel MATCH function finds the position of specified data in a selected range of cells.

Excel INDIRECT Function Tutorial
The INDIRECT function can be used to return data referenced in a separate cell in a worksheet.

Excel OFFSET Function Tutorial
The OFFSET function is one of those functions that is used extensively with other functions such as SUM, COUNT, and MATCH to create advanced lookup formulas. The job of OFFSET is to refer to the location of specific data in a worksheet.

Excel SUM OFFSET Formula Tutorial
The SUM OFFSET Formula can be used to create a dynamic sum formula that will update the range totalled as new cells are added.

Excel COLUMN Function Tutorial
The COLUMN function can be used to either find the number of the column for the cell where the function is located in the worksheet or find the number for a column of a given cell reference.

Excel ROW Function Tutorial
The ROW function can be used to find either the row number for the cell where the function is located in the worksheet or find the row number for a given cell reference.

Excel HLOOKUP Function Tutorial Text-only Version
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 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.

Excel CHOOSE Function Tutorial
The CHOOSE function can be used to return a value from a list based upon its position in the list.