XLOOKUP function can return more than one value at the same time for the same match.
=XLOOKUP(A2,A5:A14,B5:D14,,)----->>>>answer is {22,198,185}
XLOOKUP function
XLOOKUP function searches a range or an array for a match and returns the corresponding item from a second range or array.
XLOOKUP arguments
XLOOKUP(Lookup value,Table_array,Return_array,If_not_found,Match_mode)This function has just 5 Arguments:
- Lookup value is the value to search for.
- Table_array is the array or range to search.
- Return_array is the array or range to return.
- If_not_found is returned if no match is found.
- Match_mode specifies how to match lookup_value against the values in lookup_array.
Match_mode and If_not_found arguments of XLOOKUP function are optional.
