Lookup functions

CHOOSE Returns a parameter with the given numeric position.
FILTER Filters an array using a logical array.
INDEX Returns the array element at the given position.
LET Assigns names to values and allows these values to be used in subsequent calculations.
MAP Transforms all array elements using a formula fragment and returns an array with the results.
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 Looks up a value in the second array which corresponds to a value in the first array matching the first parameter.
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.