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.
HLOOKUP Function Step by Step Tutorial
Excel's HLOOKUP function, short for horizontal lookup, works much the same Excel's VLOOKUP function above. The only difference being that VLOOKUP searches for data in columns while HLOOKUP searches for data in rows.
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 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 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 LOOKUP Function - 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. 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 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 CHOOSE Function Tutorial
The CHOOSE function can be used to return a value from a list based upon its position in the list.
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 MATCH Function Tutorial
The Excel MATCH function finds the position of specified data in a selected range of cells.