Browse formulas
Choose a formula page for copy-paste examples, step-by-step notes, and common mistakes.
XLOOKUP Formula
Look up a value and return a related result from another column.
fxVLOOKUP Formula
Find a value in the first column of a table and return a value from another column.
fxHLOOKUP Formula
Look across the top row of a table and return a value from a lower row.
fxINDEX MATCH Formula
Use INDEX and MATCH together for flexible lookups.
fxMATCH Formula
Return the position of a matching value.
fxXMATCH Formula
Return the position of an item with modern matching options.
fxINDEX Formula
Return a value from a specific row and column position.
fxLOOKUP Formula
Perform a simple approximate lookup in sorted data.
fxFILTER Formula
Return only rows that match a condition.
fxUNIQUE Formula
Return unique values from a range.
fxSORT Formula
Sort a range by a selected column.
fxSORTBY Formula
Sort a range using another range as the sort key.
fxTAKE Formula
Return the first or last rows/columns from an array.
fxDROP Formula
Remove rows or columns from the start or end of an array.
fxCHOOSECOLS Formula
Return selected columns from a range.
fxCHOOSEROWS Formula
Return selected rows from a range.
fxHSTACK Formula
Combine arrays horizontally.
fxVSTACK Formula
Combine arrays vertically.
fxTRANSPOSE Formula
Turn rows into columns or columns into rows.
fxINDIRECT Formula
Build a cell reference from text.
fxOFFSET Formula
Return a range a set distance from a starting cell.