Excel Functions & Formula Finder
Look up everyday Excel functions with worked examples, find a formula by what you want to do, and build it by filling in the blanks
Loading the tool…
A reference of 143 everyday Excel functions, such as VLOOKUP, XLOOKUP, INDEX and MATCH, SUMIFS and IF, with syntax and worked examples. You can also find a formula by task and build one by filling in the arguments.
How to use
- On "Functions", search by function name or a word from the description, or choose a category.
- Open a function to see its syntax, arguments and example tables. Change the values in a table and the result recalculates.
- If you do not know the function name, search "Find by task", for example for "duplicates", "working days" or "rank".
- On "Build a formula", choose a function, fill in the argument boxes and press "Copy formula" to paste it into a cell.
- Star the functions you use often and print them from "Printable summary".
How it works
- Example results are calculated by a small calculator built into the page. Function behavior and versions follow the Microsoft support articles, and Google Sheets availability follows Google's function list (checked 2026-10-10).
- Each function shows where it is "Available in". For example, XLOOKUP, FILTER and UNIQUE need Excel 2021 or later or Microsoft 365.
- Switching the "Argument separator" to "Semicolon ;" writes formulas the way Excel does in regions that use a decimal comma.
- Favorites and settings are saved in this browser.
Questions and answers
- How do I use VLOOKUP?
- =VLOOKUP(lookup value, table range, column number, FALSE). The lookup value must be in the first column of the range, and FALSE as the last argument finds exact matches only.
- What is the difference between XLOOKUP and VLOOKUP?
- XLOOKUP takes the lookup range and the return range separately, so it can return a column to the left, and it matches exactly by default. It needs Excel 2021 or later or Microsoft 365.
- How do I sum with several conditions?
- Use SUMIFS: =SUMIFS(sum range, criteria range 1, criterion 1, criteria range 2, criterion 2). The sum range comes first. COUNTIFS counts rows in the same way.
- Do these functions work in Google Sheets?
- Most of them do. Each function shows under "Google Sheets" whether it is in Google's function list; a few, such as XMATCH and TEXTSPLIT, are not.