Excel's Lookup and Reference Functions

Excel's VLOOKUP function is used to find specific information that has been stored in a table of data stored in a spreadsheet. This tutorial includes a step by step example of using Excel's VLOOKUP function.

The TRANSPOSE function is used to transfer data located in a row into a column or data located in a column into a row. This tutorial includes a step by step example of using Excel's TRANSPOSE function

Creating a Lookup formula with multiple criteria in Excel. This tutorial includes a step by step example of creating a lookup function with multiple criteria in Excel.

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

The Excel MATCH function finds the position of specified data in a selected range of cells. This tutorial includes a step by step example of using the MATCH function in Excel to find the position of specific data.