# Excel's Lookup and Reference Functions

Excel VLOOKUP Step by Step Tutorial

Excel’s 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. This tutorial walks you through an example of using the VLOOKUP function in Excel.

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.