top of page

XLOOKUP

The XLOOKUP function is designed to search for a specific value within a range and retrieve the corresponding value associated with it.

XLOOKUP can be considered a powerful combination of several well-known Excel functions like VLOOKUP, INDEX MATCH, IFERROR, HLOOKUP, and others. It incorporates the best features from these functions into a single super-function.

In summary, XLOOKUP provides an advanced and versatile way to perform lookup operations in Excel, offering enhanced functionality and flexibility compared to traditional lookup functions.

The syntax of the function is: =XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) 

  • lookup_value – What is the value we are looking for?

  • lookup_array – Where should we lookup our value?

  • return_array – From where should the corresponding value be returned? This could be a column, row or even a range – Meaning we can return more than one cell per match.

  • [if_not_found] – optional argument – What to return in case the value is not found.

bottom of page