Lookup
18 functions in this section.
| CHOOSE | Returns a parameter with the given numeric position. |
| DROP | Returns the given array with the first or last elements removed. |
| 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. |
| RECORD | Returns a value which bundles other values together, each under a name you choose. |
| REDUCE | Reduces an array of values to a single value using a user-supplied formula. |
| REVERSEARRAY | Reverses the given array and returns it. |
| SCAN | Reduces an array of values using a user-supplied formula, returning every intermediate value of the accumulator. |
| 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. |
| TABLE | Returns a table, built from one array per column. |
| TAKE | Returns the first or last elements of the given array. |
| 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. |