1. Tech

Articles related to excel lookup functions

Excel Lookup Function Tutorials - Spreadsheets - About.com
Excel's HLOOKUP function, short for horizontal lookup, works much the same Excel's VLOOKUP function above. The only difference being that VLOOKUP ...
Excel Lookup and Reference Functions - Spreadsheets - About.com
Excel's Lookup and Reference Functions can be used to simplify finding specific entries in a data table. There are tutorials listed for the latest three versions of ...
Excel LOOKUP Function Tutorial - Vector Form - Spreadsheets
Dec 24, 2012 ... The LOOKUP function is similar to other Excel lookup functions such as VLOOKUP and HLOOKUP in that it can be used to return a value from a ...
Excel LOOKUP Function Tutorial - Array Form - Spreadsheets
Jan 12, 2013 ... The Array form of Excel's LOOKUP function can be used to find a single value from a multi-row or multi-column range of data. A step by step ...
How to use Excel's VLOOKUP Function - Spreadsheets - About.com
Excel's VLOOKUP function, which stands for vertical lookup, can be used to look up specific information located in a table of data or database. VLOOKUP ...
Excel Lookup Formula with Multiple Criteria
How to create a Lookup formula that uses multiple criteria in Excel. This tutorial includes a step by step example of creating a lookup function with multiple ...
Excel Two Way Lookup Formula Using VLOOKUP - Spreadsheets
Excel's VLOOKUP function can be used along with the MATCH function to create a two way lookup formula that finds data at the intersection point of a row and ...
Excel Lookup Formula Tutorials - Spreadsheets - About.com
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 ...
Excel VLOOKUP Function Tutorial - Spreadsheets - About.com
Excel's VLOOKUP function is used to find specific information that has been stored in a table of data stored in a spreadsheet. This tutorial includes a step by step ...
Excel Left Lookup Formula Using VLOOKUP
Sep 1, 2013 ... This tutorial combines Excel's VLOOKUP and CHOOSE functions to create a "Left Lookup" formula, which can search for data from from right to ...
1  |  2  |  3  |  4  |  5  |  6  |  7  |  8  |  9  |  10      Next

©2014 About.com. All rights reserved.