From the course: Mastering Lookup Functions in Excel: Seven Powerful Formulas

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

XLOOKUP pros and cons

XLOOKUP pros and cons - Microsoft Excel Tutorial

From the course: Mastering Lookup Functions in Excel: Seven Powerful Formulas

Start my 1-month free trial Buy for my team

XLOOKUP pros and cons

“

- As we mentioned in our last video, XLOOKUP is a great alternative to VLOOKUP and HLOOKUP because it doesn't contain many of those limitations that we spoke about earlier. For example, you aren't limited to looking up your values in one direction. You can flexibly choose between either direction in your formula as you wish. You also don't need to memorize how many columns or rows you want your lookup value to be returned. With XLOOKUP, you're in essence telling Excel to return the value in our return array as it matches the position of our lookup value in our lookup range. That makes things really simple. XLOOKUP also allows you to return a value if a match is not found, which is a great way to add a more pleasant experience whenever an error arises. Lastly, you can specify the search mode with XLOOKUP, allowing you to save processing power with really large datasets. These are all the great pros. So now you may be wondering, what's the downside to using XLOOKUP? Well, the biggest…

Contents