Understand any Excel formula
Paste a formula and see what each part does, or let a tool write the formula for your own cells.
2 functions, 2 levels deep
This formula uses 2 functions (IFERROR, VLOOKUP), nested 2 levels deep, and reads A2, Prices!$A$2:$C$50.
VLOOKUP(A2,Prices!$A$2:$C$50,3,FALSE)VLOOKUP finds a value in the first column of a table and returns a value from the same row.
Expects: value, table, column number, match type (FALSE means exact)
- Argument 1: cell A2
- Argument 2: the range $A$2:$C$50 on sheet Prices (the $ keeps it fixed when copied)
- Argument 3: the number 3
- Argument 4: FALSE
IFERROR(VLOOKUP(A2,Prices!$A$2:$C$50,3,FALSE),"Not found")IFERROR returns a fallback when the first argument gives any error.
Expects: value, fallback
- Argument 1: the result of VLOOKUP
- Argument 2: the text "Not found"
Read from the innermost function outward: Excel works out the inner results first.
- 7 free formula tools
- 137 functions the explainer knows
- 0 uploads: tools run in your browser
Browse by topic
Guides grouped the way you search for them.
Formulas & functions
How each function works, with examples you can paste.
1,671 guidesOpen section →How-to basics
Sorting, filtering, formatting, printing and shortcuts.
5,676 guidesOpen section →Charts & pivot tables
Build, format and fix charts and pivot tables.
1,386 guidesOpen section →Errors & fixes
What each error means and the change that clears it.
1,070 guidesOpen section →VBA & macros
Automate repeat work with short, commented macros.
1,289 guidesOpen section →All formula tools
Lookups, dates, loans, percentages, serials and columns.
7 toolsSee all tools →New guides
The latest additions across every section.
- Excel Script: Set Number Format in a Range
- Excel Savings Plan Template: Build a Monthly Goal Tracker
- Excel Save Failed Error: Causes, Recovery, and Fixes
- Excel Save Custom Number Formats: A Practical Guide
- Excel Runtime Error 9: Subscript Out of Range?
- Excel Rule for Dates Before Today: Formula and Setup
- Excel Row Autofit Not Working? Fix Height Problems
- Excel Row and Column Select Shortcut Keys Explained
How the tools work
Short version: your numbers stay on your device, and every formula we print is one you can paste into Excel.
Runs in your browser
Calculations happen on this page. Nothing you type is sent to us or stored.
Checked against worked examples
Each calculation is compared with known answers, and the generated formulas are run in the open-source HyperFormula engine. Function behaviour follows Microsoft's function reference. Method & sources
Corrections are public
Found a mistake? Tell us, and fixes are listed on the corrections page.