1. Technology

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 ...
http://spreadsheets.about.com/od/Lookup-Functions/
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 ...
http://spreadsheets.about.com/od/excelslookupfunctions/
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 ...
http://spreadsheets.about.com/od/tipsandfaqs/ss/2012-12-24-excel-lookup-function-tutorial.htm
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 ...
http://spreadsheets.about.com/od/tipsandfaqs/ss/2013-01-12-excel-lookup-function-array-form-tutorial.htm
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 ...
http://spreadsheets.about.com/od/excelfunctions/ss/vlookup.htm
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 ...
http://spreadsheets.about.com/od/lookupfunction1/ss/2011-03-03-excel-2010-vlookup-multiple-values-sbs-tutorial.htm
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 ...
http://spreadsheets.about.com/od/lookupfunction1/ss/2012-06-01-excel-two-way-lookup-vlookup-part-1.htm
The Lookup Value Argument in Excel's VLOOKUP Function
This step in the tutorial covers entering the lookup value argument for the VLOOKUP function, including what types of data are permissible.
http://spreadsheets.about.com/od/excelfunctions/ss/vlookup_4.htm
Using Excel's MATCH Function in a Lookup Formula - Spreadsheets
The MATCH function can be used as part of a Lookup formula that allows multiple criteria in Excel. This step in the tutorial covers using the MATCH function in a ...
http://spreadsheets.about.com/od/lookupfunction1/ss/2011-03-03-excel-2010-vlookup-multiple-values-sbs-tutorial_5.htm
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 ...
http://spreadsheets.about.com/od/Lookup-Formula-Tutorials/
1  |  2  |  3  |  4  |  5  |  6  |  7  |  8  |  9  |  10      Next

©2014 About.com. All rights reserved.