XLOOKUP
Finds a value in one range and returns the matching value from another. It can look to the left and can give a fallback.
Group: Lookup
Syntax
XLOOKUP(lookup_value, lookup_range, return_range, [if_not_found])Example
Exampleexcel
WeCodeAcademy