Loading…
Loading…
XLOOKUP finds a value in one range and returns the matching item from another range. It is exact-match by default, can look left, and has a built-in "if not found" argument.
Syntax
XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found])
Read the lesson, then try it yourself in a live spreadsheet.