Syntax
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]).
Why it's better
XLOOKUP can look left, defaults to exact match, handles missing values gracefully and doesn't break when you insert columns.
Finance example
Pull a company's revenue from a data table: =XLOOKUP("ACME", A2:A500, D2:D500, "Not found").
Keep learning
Want to put this into practice? Explore our courses and build real models step by step.