From the course: Excel 2016 Essential Training

Unlock the full course today

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

Getting approximate table data with the VLOOKUP function

Getting approximate table data with the VLOOKUP function

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Getting approximate table data with the VLOOKUP function

“

- An important and powerful function in Excel is called VLOOKUP, like a V for vertical. There's a companion function called HLOOKUP. Think of H for horizontal. We're looking at a worksheet called VLOOKUP Approximate. There are two major kinds of VLOOKUP uses, one for approximate matches, one for exact matches. On this worksheet, we're about to put in a reduction percentage in column E. There's a table off to the right in columns H and I. It could be on another worksheet. In our example, it's in the current worksheet. And by looking at it, you probably have an idea already as to what it's going to do. Based on the Subtotals that we see in column D, we want to calculate a reduction rate. The Subtotal for cell D2 is 1,363. Now different people might read this differently but the way the VLOOKUP function is going to work is it's going to be comparing that value with different values in the left column of this table. And if we have not reached this 1,500 level, then the percent below will…

Contents