Excel's Lookup and Reference Functions

Excel's VLOOKUP function , which stands for vertical lookup, can help you find specific information in large data tables such as an inventory list of parts or a large membership contact list. VLOOKUP can also be used in an array formula which makes it possible to return multiple fields of data or even entire records from a database. The...

Excel's HLOOKUP function , which stands for horizontal lookup, can help you find specific information in large data tables such as an inventory list of parts or a large membership contact list. This tutorial list includes step by step examples of how to use HLOOKUP to return fields of data from an Excel database.

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.

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’s VLOOKUP function can be used to find specific data that is stored in a spreadsheet table. This tutorial includes a step by step example of using Excel's VLOOKUP function.

How to create a VLOOKUP array formula. This tutorial includes a step by step example of how create a VLOOKUP array formula in Excel.

This document contains the tutorial data for Excel 2007 VLOOKUP Array Formula Tutorial . The data is to be copied and pasted into the tutorial worksheet.

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’s VLOOKUP function is used to find specific information that has been stored in a spreadsheet table. This article covers in detail how to create a VLOOKUP function in Excel.

Excel’s HLOOKUP function is used to find specific information that has been stored in a spreadsheet table. This article covers in detail how to create a HLOOKUP function in Excel.

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.