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 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 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 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.