Loading…
Loading…
Paste any Excel formula and see what it does, step by step, in plain English. Great for formulas you inherited, found online or got from AI.
Returns INDEX(C2:C100, MATCH(F2, A2:A100, 0)), but if that gives an error (like #N/A or #DIV/0!), shows “Not found” instead. Excel works it out in 3 steps, from the inside out.
MATCH(F2, A2:A100, 0)Finds the position of cell F2 in A2:A100 (column A, rows 2–100) (1 = first item). It needs an exact match.
Learn MATCHINDEX(C2:C100, MATCH(F2, A2:A100, 0))Returns the value from C2:C100 (column C, rows 2–100) at the position found in step 1.
Learn INDEXIFERROR(INDEX(C2:C100, MATCH(F2, A2:A100, 0)), "Not found")Returns the result of step 2, but if that gives an error (like #N/A or #DIV/0!), shows “Not found” instead.
Learn IFERRORIt reads your formula the way Excel does and explains it in plain English: a one-line summary, then each step in the order Excel works it out, starting with the innermost function. It also points out common mistakes, like a VLOOKUP that does an approximate match by accident.
Yes. Nested functions such as IFERROR(INDEX(…, MATCH(…))) are broken into separate steps, so you can see what each part does and how the result of one step feeds the next.
No. It explains the formula itself, so you only paste the formula. Nothing is uploaded: the explanation is worked out in your browser.
All 521 Excel functions SheetSkill covers, from SUM and IF to XLOOKUP, FILTER, LET and the finance and engineering functions. The most common ones get hand-written explanations.
Understood the formula? Now practise writing it yourself: browse exercises or open the Playground.