Every Excel function, explained
Syntax, real-world examples, common mistakes, and a free practice exercise for every function. No account required.
=VLOOKUP
Look up a value in the first column of a table and return a value in the same row from another column.
=HLOOKUP
Look up a value in the first row of a table and return a value in the same column from another row.
=INDEX
Return a value from a table or range based on a row and column number.
=MATCH
Return the relative position of an item in a range that matches a specified value.
=INDEX MATCH
The pair that replaces VLOOKUP entirely. Looks left, up, anywhere - and supports two-way lookups across rows and columns.
=XLOOKUP
Search a range or array and return an item corresponding to the first match found.
=INDIRECT
Return the reference specified by a text string, allowing dynamic cell references.
=OFFSET
Return a reference offset from a starting point by a given number of rows and columns.
=SUM
Add all the numbers in a range of cells.
=SUMIF
Add the cells specified by a given condition.
=SUMIFS
Add the cells that meet multiple criteria.
=SUMPRODUCT
Return the sum of the products of corresponding ranges or arrays.