Lookup functions

CHOOSE Returns a given parameter based on its numeric position and the value of the first parameter.
FILTER Filters the first array using the second parameter.
INDEX Returns the array element at the given position.
MAP Applies the transformation specified by the given formula fragment to all array elements and returns the resulting array.
MATCH Returns the position that a given value appears at in the given lookup array, or returns an #N/A error if the value cannot be found.
REDUCE Reduces an array of values to a single value using a user-supplied formula.
REVERSEARRAY Reverses the given array and returns it.
SORT Sorts and returns the given array.
SORTBY Sorts and returns a given array, where the sort order is based on sort arrays given to this function.
UNIQUE Returns a version of the given array with all duplicate values removed.
XLOOKUP Returns the array element in the second array with the same position as an element in the first array which is equal to a given value.
XMATCH Returns the position that a given value appears at in the given lookup array, or returns an #N/A error if the value cannot be found.