Exceljet

Quick, clean, and to the point

Excel function reference - Lookup and reference

Optional arguments in white. See also: 500 Formulas and 101 Functions.

Lookup and reference

Create a cell address from a given row and column
row_numcol_numabs_numa1sheet
Get the number of areas in a reference.
reference
Get a value from a list based on position
index_numvalue1value2...
Get the column number of a reference.
reference
Get the number of columns in an array or reference.
array
Get the formula in a cell
reference
Retrieve data from a pivot table in a formula
data_fieldpivot_tablefield1, item1...
Look up a value in a table by matching on the first row
valuetablerow_indexrange_lookup
Create a clickable link.
link_locationfriendly_name
Get a value in a list or table based on location
arrayrow_numcol_numarea_num
Create a reference from text
ref_texta1
Look up a value in a one-column range
lookup_valuelookup_vectorresult_vector
Get the position of an item in an array
lookup_valuelookup_arraymatch_type
Perform matrix multiplication
array1array2
Create a reference offset from given starting point
referencerowscolsheightwidth
Get the row number of a reference
reference
Get the number of rows in an array or reference.
array
Flip the orientation of a range of cells
array
Lookup a value in a table by matching on the first column
valuetablecol_indexrange_lookup