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