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).
0 Comments
Leave a Reply. |