How to return more than one value in XLOOKUP

XLOOKUP function can return more than one value at the same time for the same match.

How to return more than one value in XLOOKUP
=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:

  1. Lookup value is the value to search for.
  2. Table_array is the array or range to search.
  3. Return_array is the array or range to return.
  4. If_not_found is returned if no match is found.
  5. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *