From the course: Excel: Lookup Functions in Depth

Unlock the full course today

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

Use the new XLOOKUP function for approximate matches

Use the new XLOOKUP function for approximate matches

From the course: Excel: Lookup Functions in Depth

Start my 1-month free trial Buy for my team

Use the new XLOOKUP function for approximate matches

“

- [Instructor] You can use Excel's XLOOKUP function to replace all occurrences of VLOOKUP and HLOOKUP, even when they're involved with what we call an approximate match. On this worksheet called XLOOKUP Approximate, we're trying to come up with the tax rate here for the salaries. And unlike when using VLOOKUP, where the day that we're trying to compare is in the left column of a list, here it's in the right column. And we don't worry about that with XLOOKUP. But if it's an approximate match, it's a bit more involved than an exact match. The example here equal, remember we can type X + L + Tab. The salary is in cell C2, comma, and we're looking for a match in column H, comma. When we find a match, we go into column G. But this is not an exact match. So we have to do something extra. First of all, we need to put in comma. And if you look in that orange panel to the right, the next argument in VLOOKUP is for an if not…

Contents