XLOOKUP is a new function in Excel that replaces VLOOKUP and HLOOKUP in many ways. So, a good tip is to try to use the function every time you intend to use VLOOKUP or HLOOKUP. In this way, you will learn more quickly how to work with the function.
Want to see some advanced ways how to use XLOOKUP? Click here for the solutions for the quiz last week
Watch the lesson in Learnesys course Excel Essentials, about the function XLOOKUP