Free XLOOKUP Formula Generator
Searches a range or an array, and then returns the item corresponding to the first match it finds. If no match exists, then XLOOKUP can return the closest (approximate) match.
Generated Formula
=XLOOKUP(lookup_value, lookup_array, return_array)Learning Resources
Want to master Excel? Check out this Top-Rated Course.
Why XLOOKUP is the Modern Replacement for VLOOKUP
Introduced to solve the limitations of older functions, XLOOKUP is more powerful, flexible, and easier to use. It works in any direction (left, right, up, down) and defaults to an exact match.
Key Advantages of XLOOKUP
- No More Column Counting: You select the lookup array and the return array separately.
- Horizontal Lookups: XLOOKUP replaces both VLOOKUP and HLOOKUP.
- Built-in Error Handling: You can define what to display (e.g., "Not Found") directly within the formula if a match isn't found.
Formula Syntax Example
=XLOOKUP(search_value, lookup_array, return_array, [if_not_found])
Want to become an Excel Pro?
Stop searching for formulas. Master Excel in 30 days with this top-rated course.
Learn More