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 VLOOKUP Function Tutorial - Spreadsheets - About.com
Excel's VLOOKUP function, which stands for vertical lookup, is used to find specific information that has been stored in a spreadsheet table. Note: The data in the ...
Excel VLOOKUP Function Quick Tutorial - Spreadsheets - About.com
Excel's VLOOKUP function, which stands for vertical lookup, is used to find specific information that has been stored in a spreadsheet table.
Excel Lookup Function - Array Form - Spreadsheets - About.com
May 14, 2014 ... There are two forms for the LOOKUP function in Excel - the Vector Form and the Array Form. The difference between the two lies in where the ...