MENU
Donate
=EXCELBACK

The Excel reference you'll actually keep open.

130 functions explained argument by argument, 27 topics mapped from basics to VBA, 407 curated resources and 10 free tools — with no account to create.

Look up a functionTry the formula builder
  • 407 curated resources
  • 27 Excel topics
  • 10 free tools
  • no account needed
Lookup & Reference

XLOOKUP()

XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

lookup_value
The value to search for.
lookup_array
The range to search.
return_array
The range to return a value from — same size as lookup_array.
=XLOOKUP(D2, A:A, B:B)
→$14.99
All 5 arguments and 2 worked examples

Sources we reference — not partners

26 places we cite for accuracy. We link to them; none has reviewed, endorsed, or collaborated on this site.

Official documentation

Educators and channels

Course platforms

AI & data tools

=TOOLS

Free tools, no sign-up

TOOLS.A1

Formula builder

Pick what you're trying to do, fill in your cells, get the exact formula.

Open tool ->TOOLS.A2

CSV cleaner

Dedupe, remove blanks, and trim messy data in your browser.

Open tool ->TOOLS.A3

Formula explainer

Paste any formula and see a plain-English breakdown.

Open tool ->TOOLS.A6

Date calculator

Days between two dates, or add/subtract workdays from a start date.

Open tool ->TOOLS.A7

Practice data generator

Pick row count and column types, download realistic sample data as CSV.

Open tool ->TOOLS.A8

Text case converter

UPPERCASE, lowercase, Proper Case, Sentence case, or camelCase.

Open tool ->TOOLS.A9

Percentage calculator

Percent of, percent change, and percent-of-a-number — instantly.

Open tool ->TOOLS.A10

Column splitter

Text to columns in your browser — comma, tab, custom, or fixed width.

Open tool ->TOOLS.A11

Duplicate finder

Highlight duplicates in a pasted list, then copy unique or dupes only.

Open tool ->TOOLS.A12

Reference converter

A1 to R1C1 both ways, plus a relative/absolute reference helper.

Open tool ->
=EXCEL.TOPICS

Browse by topic

All 27 topics ->
Excel Basics5 subtopicsFormulas & Functions7 subtopicsData Cleaning5 subtopicsCharts & Visualization5 subtopicsPivot Tables5 subtopicsDashboards & Reporting5 subtopicsPower Query5 subtopicsData Analysis5 subtopicsAutomation, Macros & VBA5 subtopics+18more topics
=FUNCTIONS

A searchable function reference

130 functions with plain-English explanations, every argument spelled out, and worked examples — not just Microsoft's docs copy-pasted.

Browse the function reference
VLOOKUP()XLOOKUP()SUMIFS()INDEX()MATCH()IFERROR()
=DIRECTORY

A directory of the best Excel resources

407 hand-picked sites, courses, add-ins, and templates — organised by type so you find what is worth your time without sorting through noise.

Browse the directory
201Sites & blogs66Courses58Templates39Add-ins
=ARTICLES

Latest tutorials

All articles ->
intermediate

Ablebits vs Kutools: which Excel add-in suite should you buy?

A practical comparison of Ablebits Ultimate Suite and Kutools for Excel to help you choose the right add-in for your work.

Read ->intermediate

Claude for Excel vs Microsoft Copilot: which AI tool should you use?

A practical look at using Claude and Microsoft Copilot for Excel work — where each one helps, where each one falls short, and how to combine them.

Read ->intermediate

Combo charts and dynamic chart ranges in Excel

Two chart techniques that come up in almost every real report: combining two chart types on a secondary axis, and building a chart that grows on its own as new data arrives.

Read ->