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,290 guidesOpen section →How-to basics
Sorting, filtering, formatting, printing and shortcuts.
5,185 guidesOpen section →Charts & pivot tables
Build, format and fix charts and pivot tables.
1,094 guidesOpen section →Errors & fixes
What each error means and the change that clears it.
923 guidesOpen section →VBA & macros
Automate repeat work with short, commented macros.
1,266 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 PivotTable Tips for Clearer Reports
- Excel Not Responding and Unsaved? Recover Your Work
- Excel Insert X Rows: Fast Methods for Any Worksheet
- Excel VBA Button: Add One to a Worksheet Step by Step
- Excel Insert Slicer: Why No Connections Are Found?
- Excel Insert Row Ruins My Formulas? Fix the References
- Excel Insert Row Greyed Out? Causes and How to Fix It
- Excel Insert a Row Every X Rows: Methods That Work
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.