VLOOKUP and Other Excel Lookup Formula Tutorials
Excel VLOOKUP Step by Step Tutorial
The VLOOKUP function is used to find specific information that has been stored in a database. This tutorial includes a step by step example of how retrieve information using the VLOOKUP function in Excel.
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.
Lookup Formula with Multiple Criteria in Excel Tutorial
Another 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. This tutorial includes a step by step example of creating a lookup formula that uses multiple...
Excel TRANSPOSE Function
The TRANSPOSE function is used to transpose data from a row into a column or data located in a column into a row.
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.
Find Multiple Fields of Data with VLOOKUP
This tutorial covers how to create a lookup formula to return multiple fields of data from a single row of a data table.
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. This tutorial includes a step by step example of using the INDEX function to return the name of a specific item of data from a database.
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 MATCH Function Tutorial
The Excel MATCH function finds the position of specified data in a selected range of cells.