By Greg Harvey . The most popular of the lookup functions in Excel 2007 are HLOOKUP (for Horizontal Lookup) and VLOOKUP (for Vertical Lookup). These functions are located in the Lookup & Reference category on the Formulas tab of the Ribbon and in the Insert Function dialog box.
How to Use the VLOOKUP Formula in Functions in Excel 2007 ...
10/19/2016 · Welcome to my latest hub on Excel. Both Excel 2007 and Excel 2010 have an enormous number of functions available and today I will be looking at one of the most powerful Excel functions, VLOOKUP and how it can be used in formulas.
Description. The Microsoft Excel LOOKUP function returns a value from a range (one row or one column) or from an array. The LOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function.
Lookup & Reference Functions in Excel - Easy Excel Tutorial
The VLOOKUP (Vertical lookup) function looks for a value in the leftmost column of a table, and then returns a value in the same row from another column you specify. 1. Insert the VLOOKUP function shown below. Explanation: the VLOOKUP function looks for the ID (104) in the leftmost column of the
The VLOOKUP function in Excel performs a case-insensitive lookup. For example, the VLOOKUP function below looks up MIA (cell G2) in the leftmost column of the table. For example, the VLOOKUP function below looks up MIA (cell G2) in the leftmost column of the table.