ADDRESS

ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])

AREAS

AREAS(reference)

CHOOSE

CHOOSE(index_num, value1, [value2], ...)

CHOOSECOLS

CHOOSECOLS(array, col_num1, [col_num2], ...)

CHOOSEROWS

CHOOSEROWS(array, row_num1, [row_num2], ...)

COLUMN

COLUMN([reference])

COLUMNS

COLUMNS(array)

DROP

DROP(array, rows, [columns])

EXPAND

EXPAND(array, rows, [columns], [pad_with])

FILTER

FILTER(array, include, [if_empty])

FORMULATEXT

FORMULATEXT(reference)

GETPIVOTDATA

GETPIVOTDATA(data_field, pivot_table, [field1, item1], ...)

GROUPBY

GROUPBY(row_fields, values, function, ...)

HLOOKUP

HLOOKUP(lookup_value, table_array, ...)

HSTACK

HSTACK(array1, [array2], ...)

HYPERLINK

HYPERLINK(link_location, [friendly_name])

IMAGE

IMAGE(source, [alt_text], [sizing], ...)

INDEX

INDEX(array, row_num, [column_num]) or INDEX(reference, ...)

INDIRECT

INDIRECT(ref_text, [a1])

LOOKUP

LOOKUP(lookup_value, lookup_vector, [result_vector])

MATCH

MATCH(lookup_value, lookup_array, [match_type])

OFFSET

OFFSET(reference, rows, cols, [height], [width])

PIVOTBY

PIVOTBY(row_fields, col_fields, values, function, ...)

ROW

ROW([reference])

ROWS

ROWS(array)

RTD

RTD(ProgID, server, topic1, ...)

SORT

SORT(array, [sort_index], [sort_order], [by_col])

SORTBY

SORTBY(array, by_array1, [sort_order1], ...)

TAKE

TAKE(array, rows, [columns])

TOCOL

TOCOL(array, [ignore], [scan_by_column])

TOROW

TOROW(array, [ignore], [scan_by_column])

TRANSPOSE

TRANSPOSE(array)

TRIMRANGE

TRIMRANGE(range, [trim_rows], [trim_cols])

UNIQUE

UNIQUE(array, [by_col], [exactly_once])

VLOOKUP

VLOOKUP(lookup_value, table_array, ...)

VSTACK

VSTACK(array1, [array2], ...)

WRAPCOLS

WRAPCOLS(vector, wrap_count, [pad_with])

WRAPROWS

WRAPROWS(vector, wrap_count, [pad_with])

XLOOKUP

XLOOKUP(lookup_value, lookup_array, ...)

XMATCH

XMATCH(lookup_value, lookup_array, ...)

Lookup and reference

Lookup and reference functions help to find and retrieve data from different locations.