Essential Excel Formulas Index
Master Microsoft Excel with our interactive dictionary of the most important formulas. Filter by category, view code syntax, and download free practice sheets.
VLOOKUP Function
Vertically searches for a value in the first column of a table array and returns a value in the same row from a specified column.
HLOOKUP Function
Horizontally searches for a value in the top row of a table array and returns a value in the same column from a specified row.
XLOOKUP Function
The modern successor to VLOOKUP and HLOOKUP. Searches a range or array, and returns the corresponding item in vertical or horizontal directions.
INDEX Function
Returns a value or reference of the cell at the intersection of a particular row and column within a given table range.
MATCH Function
Searches for a specified item in a range of cells, and then returns the relative position index number of that item.
IF Function
Checks whether a logical condition is met, and returns one custom value if TRUE, and another value if FALSE.
IFS Function
Evaluates multiple logical conditions and returns a value corresponding to the first condition that evaluates to TRUE.
IFERROR Function
Returns a custom value you specify if a formula evaluates to an error; otherwise, returns the normal result of the formula.
IFNA Function
Returns the value you specify if the expression resolves to #N/A (not available) error; otherwise, returns the result of the expression.
SUM Function
Adds all the individual numbers, cell references, or range of cells that you specify together.
SUMIF Function
Adds the values in a specified cell range that meet a single set criteria or condition you define.
SUMIFS Function
Adds the values in a cell range that meet multiple defined conditions or criteria simultaneously.
COUNT Function
Counts the total number of cells in a specified range or array that contain numerical values.
COUNTIF Function
Counts the number of cells within a specified range that meet a single given condition or criteria.
TRIM & CLEAN Functions
Removes unnecessary spaces from text lines (TRIM) and deletes all non-printable characters (CLEAN) to repair messy data.