So, if you’re using prior versions of Excel (2010/2013/2016/2019), you won’t be able to use this function. The power of this function will become even more clear as I deep dive into some XLOOKUP examples later in this tutorial.īut before I get into the examples, there is a big question – how do I get access to XLOOKUP? How to Get Access to XLOOKUP?Īs of now, XLOOKUP is only available for the users of Office 365. XLOOKUP is a function that allows you to quickly look for a value in a dataset (vertical or horizontal) and return the corresponding value in some other row/column.įor example, if you’ve got the scores for students in an exam, you can use XLOOKUP to quickly check how much a student has scored using the name of the student. It does everything VLOOKUP used to do, and much more. XLOOKUP is a new function is Office 365 and is a new and improved version of the VLOOKUP/ HLOOKUP function.
0 Comments
Leave a Reply. |