Excel Functions

Returns a corresponding value to the right of a specified lookup value in a table.

Returns a corresponding value beneath a specified lookup value in a table.

Returns a value from a table, combining the power of VLOOKUP and HLOOKUP into one flexible function.

Returns the value from a cell in a list at a specified position. Often paired with MATCH.

Returns the position of a specified value in a list. Pairs with INDEX to create lookups more flexible than VLOOKUP.

Adds together different numerical values into a total.

Adds together all numerical values that meet a user-specified criterion.

Adds together all numerical values that meet multiple user-specified criteria.

Returns the average (arithmetic mean) of a group of numbers.

Counts the number of cells in a range that contain numerical values.

Counts the number of cells in a range that meet one specified criteria.

Counts the number of rows or columns in a range that meet multiple specified criteria.

Return the minimum and maximum numerical values from a group of numbers.

Returns the n^th largest or smallest value from a group of numbers — e.g., the 2^nd largest.

Joins together different pieces of text into one string.

Joins different strings of text with a common delimiter or separator between each string.

Extracts all text that appears after a specified delimiter. Useful for extracting the last word.

Extracts all text that appears before a specified delimiter. Useful for extracting the first word.

Return different sections of a string — the leftmost 5 characters, the last 3, or a middle slice.

Returns a specified number of the leftmost characters of a string of text.

Returns the length of a text string in number of characters.

Returns a substring of text from within the middle of a larger string.

Searches for a case-specific substring within a string and returns its position.

Replaces one string of text with another string of text.

Change the case of text to uppercase, lowercase, or proper case.

Learn how to extract the first word from a string of text in Excel.

Learn how to extract the last word from a string of text in Excel.

Add logical decisions to your spreadsheet and return different values based on whether a condition is true or false.

Similar to IF, but lets you test multiple criteria with a single formula.

Compares a specific value against multiple criteria and returns a result for the first match.

Return true or false based on different combinations of conditions.

Greater Than, Less Than, Equal To, and more — compare two values and return true or false.

Reference the same cell(s) no matter where a formula is copied in the worksheet.

Specify a list of data that a user can pick from to populate a cell.

Quickly and easily copy formatting from one cell to another.

Replace text when searching for matches — using *, ?, and ~ characters.

Returns the current date. Updates automatically every time the workbook recalculates.

Learn how to ace Indeed's Excel Assessment and land the job.

Learn how to pass Microsoft's MO-200 Excel certification exam.

Learn how to pass Microsoft's MO-201 Excel Expert certification exam.