Short, practical answers to the spreadsheet jobs people get stuck on, each with the formula, a free tool and a lesson to practise.
VLOOKUP, XLOOKUP and joining two tables on a shared column.
VLOOKUP returning #N/A even though the values match, the wrong value, or breaking when you drag it down? The 9 usual causes and the exact fix for each.
XLOOKUP vs VLOOKUP side by side: exact match by default, looking left, no column numbers, built-in not-found text. With formulas and when VLOOKUP still makes sense.
Join two Excel files on a shared column such as an ID or email: with XLOOKUP, with Power Query, or in your browser with no formulas. Handles missing and duplicate keys.
Find differences, missing rows and messy data.
Compare two Excel sheets cell by cell or row by row. Formulas to find missing rows and changed values, conditional formatting, and a no-formula option.
The first formulas everyone needs.
The basic Excel formulas every beginner needs, in the order to learn them: +, SUM, AVERAGE, COUNT, ROUND, percentages, IF and $. Each with an example and free practice.
Know someone fighting with a spreadsheet? Send them this page.