Excel functions
Every Excel function (476), organized by category. Arguments in [brackets] are optional.
Formula Explainer · Paste any formula and see it broken down step by step. Free.
Try itLookup & Reference (40)
=ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])Returns a reference as text to a single cell in a worksheet.
=AREAS(reference)Returns the number of areas in a reference.
=CHOOSE(index_num, value1, [value2], ...)Chooses a value from a list of values.
=CHOOSECOLS(array, col_num1, [col_num2], ...)Returns the specified columns from an array.
=CHOOSEROWS(array, row_num1, [row_num2], ...)Returns the specified rows from an array.
=COLUMN([reference])Returns the column number of a reference.
=COLUMNS(array)Returns the number of columns in a reference.
=DROP(array, rows, [columns])Excludes a specified number of rows or columns from the start or end of an array.
=EXPAND(array, rows, [columns], [pad_with])Expands or pads an array to specified row and column dimensions.
=FILTER(array, include, [if_empty])Filters a range of data based on criteria you define.
=FORMULATEXT(reference)Returns the formula at the given reference as text.
=GETPIVOTDATA(data_field, pivot_table, [field1, item1, field2, item2], ...)Returns data stored in a PivotTable report.
=GROUPBY(row_fields, values, function, [field_headers], [total_depth], [sort_order], [filter_array], [field_relationship])Helps a user group, aggregate, sort, and filter data based on the fields you specify.
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])Looks in the top row of an array and returns the value of the indicated cell.
=HSTACK(array1, [array2], ...)Appends arrays horizontally and in sequence to return a larger array.
=HYPERLINK(link_location, [friendly_name])Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet.
=IMAGE(source, [alt_text], [sizing], [height], [width])Returns an image from a given source.
=INDEX(array, row_num, [column_num])Uses an index to choose a value from a reference or array.
=INDIRECT(ref_text, [a1])Returns a reference indicated by a text value.
=LOOKUP(lookup_value, lookup_vector, [result_vector])Looks up values in a vector or array.
=MATCH(lookup_value, lookup_array, [match_type])Looks up values in a reference or array.
=OFFSET(reference, rows, cols, [height], [width])Returns a reference offset from a given reference.
=PIVOTBY(row_fields, col_fields, values, function, [field_headers], [row_total_depth], [row_sort_order], [col_total_depth], [col_sort_order], [filter_array], [relative_to])Helps a user group, aggregate, sort, and filter data based on the row and column fields that you specify.
=ROW([reference])Returns the row number of a reference.
=ROWS(array)Returns the number of rows in a reference.
=RTD(ProgID, server, topic1, [topic2], ...)Retrieves real-time data from a program that supports COM automation.
=SORT(array, [sort_index], [sort_order], [by_col])Sorts the contents of a range or array.
=SORTBY(array, by_array1, [sort_order1], [by_array2, sort_order2], ...)Sorts the contents of a range or array based on the values in a corresponding range or array.
=TAKE(array, rows, [columns])Returns a specified number of contiguous rows or columns from the start or end of an array.
=TOCOL(array, [ignore], [scan_by_column])Returns the array in a single column.
=TOROW(array, [ignore], [scan_by_column])Returns the array in a single row.
=TRANSPOSE(array)Returns the transpose of an array.
=TRIMRANGE(range, [trim_rows], [trim_cols])Scans in from the edges of a range or array until it finds a non-blank cell (or value), it then excludes those blank rows or columns.
=UNIQUE(array, [by_col], [exactly_once])Returns a list of unique values in a list or range.
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])Looks in the first column of an array and moves across the row to return the value of a cell.
=VSTACK(array1, [array2], ...)Appends arrays vertically and in sequence to return a larger array.
=WRAPCOLS(vector, wrap_count, [pad_with])Wraps the provided row or column of values by columns after a specified number of elements.
=WRAPROWS(vector, wrap_count, [pad_with])Wraps the provided row or column of values by rows after a specified number of elements.
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match.
=XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])Returns the relative position of an item in an array or range of cells.