Excel FunctionsLesson 120Free preview
XLOOKUP
This lesson is part of Excel · All levels
Summary
XLOOKUP is a new generation search function that replaces VLOOKUP, HLOOKUP, and INDEX-MATCH. The syntax is. This function can search in any direction and have an in-built message when the data is not found.
Key points
- Lookup_array and return_array are two separate ranges
- The if_not_found argument replaces the IFERROR requirement
- You can search from right to left and from bottom to top.
- Match_mode sets the exact, nearest, or wildcard search
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.