Spreadsheet
Excel Formula Generator
Pick the task you're trying to do, fill in your cell references and conditions, and get a ready-to-paste Excel formula.
What do you want to do?
Find a value in the first column of a range and return a value from another column in the same row.
Fill in the details
Generated formula
=VLOOKUP(A2, Sheet2!A:D, 3, FALSE)
How it works
Instead of memorizing exact argument order and syntax, choose what you're trying to accomplish — a lookup, a conditional sum, joining text, or handling errors — and this tool assembles the correct formula from your inputs. Every field maps directly onto a real formula argument, so you always know exactly what you're generating.
Already have a formula and want to understand it instead? Use the Excel Formula Explainer.
Examples
VLOOKUP
Find a value from another sheet.
=VLOOKUP(A2, Sheet2!A:D, 3, FALSE)
SUMIFS
Sum with two conditions.
=SUMIFS(C:C, A:A, "West", B:B, ">100")
IFERROR
Show a fallback instead of an error.
=IFERROR(VLOOKUP(A2,Sheet2!A:D,3,FALSE), "Not found")