FUNCTION CATALOGUE / LOOKUP & REFERENCE
XLOOKUP Excel function
Looks up a value and returns the corresponding result.
Correct sentence to use
Find [lookup value] in [lookup range] and return the matching value from [return range].
Modify this query in PlainFormula →Example formula
=XLOOKUP(E2,A:A,B:B,"Not found")
Looks for a match and returns the corresponding item.
Syntax
XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])
Argument signature: lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]
Availability note
Available in supported Microsoft 365 / newer Excel versions; verify the exact release and platform.