Excel Function/XLOOKUP function/Office 365
Function: XLOOKUP function/Office 365 Type: Lookup and reference Description: Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn’t exist, then XLOOKUP can return the closest (approximate) match.