VLOOKUP and Other Excel Lookup Function Tutorials

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

Normally VLOOKUP is used to return information from one cell in a database. It's usefulness can be extended, however, by using it in an array formula which allows you to find multiple fields of information with one VLOOKUP function.

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

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.

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.

The TRANSPOSE function is used to transpose data from a row into a column or data located in a column into a row.