formulastreak

Formula explainer

Paste an Excel or Google Sheets formula. Get it in plain English, step by step. It runs in your browser: nothing is sent anywhere.

In plain English

Returns the value in column 3 of $A$2:$C$9 on the row where F2 is found, but if that gives any error, shows "Not found" instead. Careful: it hides every error, typos included.

Works in: all current Excel versions, Google Sheets

Where each function is taught

Step by step

Inside out: the order the spreadsheet works it out.

  1. 1VLOOKUP=VLOOKUP(F2, $A$2:$C$9, 3, FALSE)= 65

    Looks for F2 in the first column of $A$2:$C$9 and returns the value in column 3 of that row. FALSE means exact match: if the value isn't there, you get #N/A.

    keyF2what to look for
    table$A$2:$C$9the whole table, key column first
    column3which column to return, counting the table's first column as 1
    FALSEFALSEexact match. Without it VLOOKUP assumes a sorted table and can quietly return a wrong row

    From the course: VLOOKUP finds a key in the first column of a table and returns a value from the same row, from the column you name, counting from 1.

    Lesson 15
  2. 2IFERROR=IFERROR(VLOOKUP(F2, $A$2:$C$9, 3, FALSE), "Not found")= 65

    Returns the result of step 1, but if that gives any error, shows "Not found" instead. Careful: it hides every error, typos included.

    valuethe result of step 1the calculation that might fail
    fallback"Not found"what to show instead of an error

    From the course: IFERROR shows the value when it works and a fallback when it's any error. That's quick, and also risky: it hides typos and broken references too, so prefer testing the cause when you know it.

    Lesson 14

Try it on a sample sheet

We filled the cells your formula reads with sample numbers and put the formula in H2. Type your own values (text works too) and watch the result and the steps above update.

Click a cell (or use the arrow keys) to insert its address · Enter shows the resultH2 = 65
ABCDEFGH
1
24764813165
3841128
4314865
5688512
6153249
7526986
8891633
9365370

Practise this in 5 minutes

Everything this formula uses is taught in Lesson 15: VLOOKUP (Unit 4, Lookups), on a live sheet with instant feedback. Pro

Open “VLOOKUP”

Get the formulastreak newsletter

Bite-sized formula tips you can use at work the next day, plus a heads-up when new free tools and lessons land. It arrives now and then, never in a flood.

No spam, unsubscribe in one click. We store your email, this consent and when you gave it. Details in our privacy policy.

Need a quick reference? The formula cheat sheet is free to read and print.

How the formula explainer works

It reads your formula with the same engine that grades formulastreak's lessons, then describes each function in the order a spreadsheet calculates it: the innermost first. Every argument gets a name and a plain-English meaning, taken from the lesson that teaches that function.

Then it builds a small sample sheet around the cells your formula reads, so you can see what each step returns and change the numbers to test it. Nothing is uploaded: it all happens in this page.

Want to understand the errors instead? Try the Excel error decoder, or read the formula guides.

Popular formulas, explained

Questions

Which formulas can it explain?+

Any formula written for Excel or Google Sheets: it reads cell references, ranges, operators, text, nested functions, LET and LAMBDA. It describes about 150 functions in detail. If it meets a function it doesn't know yet, it says so and still explains the rest.

Does my formula leave my computer?+

No. The explanation and the sample sheet run entirely in your browser. Nothing you paste is sent to our server.

Why does it explain the formula inside-out?+

That's the order a spreadsheet works it out: the innermost functions first, then the functions that use their results. Reading it in that order makes long formulas much easier to follow.

Does it work for formulas from another sheet or workbook?+

Yes. References like Prices!A2:C9 are explained without the sheet name. Excel table references like Table1[Amount] aren't supported yet.

Is it the same in Excel and Google Sheets?+

Most formulas are. Below each explanation you'll see which versions of Excel and whether Google Sheets support every function it uses.