From the course: Excel: Lookup Functions in Depth

Unlock this course with a free trial

Join today to access over 24,200 courses taught by industry experts.

Using the XLOOKUP function for approximate matches

Using the XLOOKUP function for approximate matches - Microsoft Excel Tutorial

From the course: Excel: Lookup Functions in Depth

Start my 1-month free trial Buy for my team

Using the XLOOKUP function for approximate matches

“

- [Instructor] On this worksheet called XLOOKUP Approximate, in column D, we'd like to come up with the tax rate for each of the people listed over in column A. Their salaries are in column C, and based on the salary and that list that we see over to the right in columns G and H, we want to come up with the appropriate tax rate. If we were using VLOOKUP, we'd have to rearrange the left to right order of these columns. But with XLOOKUP, it makes no difference. Keep in mind too, that when you are using XLOOKUP, you need to go to an additional set of arguments. With earlier examples of XLOOKUP, we saw how we could use a fourth argument, if not found, it's optional. But that fifth argument, it's called match mode, is what we'll be using here. So for an approximate match, XLOOKUP equal XL tab. What are we looking up? The salary in cell C2. 63, 981. Comma. Where are we looking to find this? Now remember, this is not going to be an exact match. We're looking in column H. And when we find the…

Contents