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. Example 11: Find the Last Value in the Column.Example 9: Conditional Lookup (Using XLOOKUP with Other Formulas).Example 7: Approximate Match with XLOOKUP (Find Tax Rate).Example 6: Find the Last Matching Value. Example 5: Nested XLOOKUP (Lookup in Multiple Ranges).Example 4: When Lookup Value is Not Found (Error Handling).Example 3: Two Way Lookup Using XLOOKUP (Horizontal & Vertical Lookup).Example 2: Lookup and Fetch an Entire Record.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |