Step by Step Guide on Excel for XLOOKUP (With Examples) What is XLOOKUP? XLOOKUP helps you find a value in a range or array It's better than VLOOKUP, HLOOKUP, and some uses of INDEX-MATCH Syntax: XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) Parameters: lookup_value: The value you want to search for lookup_array: The range column where Excel will