Stop searching by formula name.
Search by what you actually want to do.
I built Excel Translator because every Excel reference I tried was alphabetical — useful only if you already knew the function name. When I'm stuck describing a problem ("running total", "split text by comma", "filter rows where status is active"), I want a tool that flips the question. So I built one.
XLOOKUP example · /img/hero-illustration.svg
What do you want Excel to do?
A goal-first reference, not an A-to-Z manual
Describe, don't recall
You don't need to remember whether it's INDEX/MATCH or XLOOKUP. Tell us the goal and we'll show the modern formula plus the legacy fallback.
Read the red text
Every Excel error — #N/A, #REF!, #SPILL!, #CALC! — explained with the real-world cause and the fix that actually works.
Industry-specific
Curated formula sets for Finance, HR, Students, and Data Cleanup — so you spend less time inventing patterns from scratch.
Where to start
Formula Translator
Convert an Excel formula between English, German, French, Spanish, Italian, Portuguese, Dutch, and Polish — function names + argument separators, with a verification round-trip.
Open the Translator →Use-Case Formula Finder
An interactive search where the input is what you want to do — not a function name. Best entry point if you're new or unsure.
Open the Finder →Function Reference
Every function across 14 categories, side-by-side in 8 languages. Searchable by any localized name or description.
Browse the Reference →Curated Formula Library
Hand-picked, opinionated formulas grouped by use-case: Lookups, Logic, Text, Dates, Aggregation, Dynamic Arrays.
Browse the Library →Error Decoder
Paste an error or pick from the list — get the meaning, root causes, and a copy-paste fix. All 12 modern error codes covered.
Decode an Error →CELL & INFO Args
The localized argument strings for the two functions that bite you when a workbook crosses locales. The bug nobody tells you about.
See the args →Modern vs Legacy
Side-by-side: VLOOKUP vs XLOOKUP, IF nesting vs IFS, CONCATENATE vs TEXTJOIN. Keep what's still useful, ditch what isn't.
See the comparisons →Field Notes
Deep-dives on translation pitfalls, dynamic-array gotchas, and patterns worth memorizing.
Read the blog →Why LET changes how you write formulas
Most spreadsheet formulas grow long because the same expression gets repeated. LET lets you name a sub-expression once and reuse it — like variables in code. Easier to read, faster to recalc.
=LET( net, A2 - B2, taxRate, 0.18, tax, net * taxRate, net + tax )
Three named pieces (net, taxRate, tax) and a final result. No repeated arithmetic, no hidden helper cells. This is one of those features that quietly improves every formula longer than two lines.