Scott Fegette |
Wednesday, January 15, 2014
Explore this course at lynda.com.
When looking up information in Microsoft Excel, you’ll regularly need to compare data against a table—and tables can be found in a variety of locations and formats. For example, in the image above you may need to find the appropriate tax rate in the table on the right for a given employee’s salary listed in the table on the left.
On the Formulas tab in the Excel ribbon, you’ll see a categories function called Look up and Reference. The two key functions for this type of task are VLOOKUP (V meaning vertical) and its companion function HLOOKUP (H meaning horizontal).
Why two functions instead of one? As shown in the image below, data tables can be found in horizontal and vertical orientations—so with two dedicated functions, you’re covered either way.
Let’s take a straightforward look at how the HLOOKUP and VLOOKUP functions are written (this graphic shows an HLOOKUP function but the syntax for VLOOKUP is identical).
The four comma-separated parameters you can specify for the HLOOKUP and VLOOKUP functions are:
As you can see, VLOOKUP and HLOOKUP are incredibly helpful functions to know for any data-matching tasks in Excel 2013. For more details on these functions among many others, be sure to watch Dennis Taylor’s course Excel 2013: Advanced Formulas and Functions.
Tags: Excel, Excel formulas, Excel functions, Microsoft Excel
Check out these popular Business courses.
Thanks for signing up.
We’ll send you a confirmation email shortly.
Sign up and receive emails about lynda.com and our online training library:
Keep up with news, tips, and latest courses with emails from lynda.com.
We've updated our terms and conditions (now called terms of service).Go Review and accept our updated terms of service.