Excel Error fix
XLOOKUP Returns #N/A Even Though the Value Exists: 7 Fixes
XLOOKUP shows #N/A even though the value is there? Find the cause fast: spaces, text numbers, ranges, match_mode and more, with copy-paste fixes.
🔎 Topic hub · 4 tutorials
Lookup & Conditional Sums
XLOOKUP, VLOOKUP, INDEX MATCH, SUMIFS and COUNTIFS: why lookups fail and how to sum or count with conditions.
Tutorials in this topic
Excel Error fix
VLOOKUP Returning the Wrong Value? The Approximate Match Trap (and 4 Other Causes)
VLOOKUP returning the wrong value in Excel or Google Sheets? Fix the missing FALSE argument first, then check duplicates, column numbers, relative ranges and wildcards.
Excel How-to
SUMIFS with Multiple Criteria in the Same Column (OR Logic) in Excel & Google Sheets
SUMIFS returns 0 when you give one column two criteria. Sum North OR West with an array constant, a criteria list, FILTER or SUMPRODUCT, without double counting.
Excel Comparison
COUNTIF vs COUNTIFS vs SUMPRODUCT: When to Use Each (With Examples)
COUNTIF, COUNTIFS or SUMPRODUCT? A decision table plus tested examples for AND, OR, case-sensitive, row-by-row and month counts, and the edge cases that give wrong totals.