What VLOOKUP does
Full content coming soon.
Syntax breakdown
Full content coming soon.
Worked example
Full content coming soon.
Common pitfalls
Full content coming soon.
Excel Tools
Free Excel and spreadsheet tools — formula helpers, converters, and data cleaners.
Open Excel ToolsFrequently asked questions
More Excel Tools guides
What Is Microsoft Excel?
A friendly introduction to Microsoft Excel: what the app does, where it shines, and why it's still the world's default spreadsheet.
Read articleExcel vs Google Sheets
Excel and Google Sheets do 90% of the same things — but the last 10% matters. Here's how they compare on formulas, collaboration, performance, and price.
Read articleThe Most Useful Excel Functions
Learn these ten Excel functions and you'll handle 90% of everyday spreadsheet work. Examples, syntax, and when to reach for each one.
Read articleHow Excel Formulas Work
A plain-English guide to how Excel actually evaluates a formula — references, operators, functions, and the rules behind = signs and $ pinning.
Read articleCommon Excel Errors and How to Fix Them
Decode Excel's six most common formula errors and learn the quickest way to fix each one — without rewriting your whole spreadsheet.
Read articleExcel for Beginners
Start here if Excel feels intimidating: the core concepts and habits that unlock everything else.
Read articleHow to Use XLOOKUP
The newer, smarter lookup — and why it's worth switching from VLOOKUP whenever you can.
Read articleBest Excel Functions for Work
If you only learn a handful of Excel functions, learn these. They cover most real-world office tasks.
Read articleExcel Productivity Tips
The shortcuts and habits that separate slow Excel users from fast ones.
Read article