From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Looking up information with VLOOKUP and HLOOKUP

Looking up information with VLOOKUP and HLOOKUP

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Looking up information with VLOOKUP and HLOOKUP

- In this worksheet, we've got a list of Employees, Social Security numbers, Job Ratings, Salaries and so on here. We want to come up with the Tax Rate. Now, depending upon what you know about Excel formulas, one approach could be the IF function, and those who are familiar with the IF function right away might be saying, "Are you sure? "Is that going to be the best way?" If we're looking up Salaries from the list here, if this is a short list, maybe with break points every 20 or 30,000, that's highly unlikely, maybe the IF function would be OK, but in this example, not at all. There's gotta be a better way to do this. If we used an IF function here, it would probably involve using Nested IFs. Maybe up to 10 or 11 of them here. Ultimately, not very effective. In Excel, there are a number of LOOKUP functions. The two major ones are called VLOOKUP, think of V for Vertical, and HLOOKUP, H for Horizontal, and the situation we're about to refer to here is what we might call a small example…

Contents