VLOOKUP not working? 9 causes and how to fix each one
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.
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 fits.
How INDEX MATCH works in Excel, step by step: look up to the left, match on two or more criteria, two-way lookups, and fixes for #N/A and wrong rows.
Join two Excel files on a shared column like an ID or email: with XLOOKUP, 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 Excel formulas every beginner needs, in the order to learn them: +, SUM, AVERAGE, COUNT, ROUND, percentages, IF and $. Each with an example to practise.
Know someone fighting with a spreadsheet? Send them this page.