All Guides
📋 Reference
Excel Formula Cheat Sheet 2026 — 50 Must-Know Formulas
The complete reference — 50 essential formulas organised by category with syntax and examples. VLOOKUP, SUMIF, IF, dates, text, and more.
Read guide →
🔍 Lookup
VLOOKUP vs XLOOKUP: Which Should You Use in 2026?
Complete comparison — left lookups, error handling, column insertion, and when to keep using VLOOKUP. With 5 side-by-side examples.
Read guide →
🔧 Troubleshooting
Excel Formula Not Working? 9 Fixes for Every Error
Fix #VALUE!, #REF!, #N/A, formulas showing as text, wrong results, and formulas that break when copied down. Every error explained.
Read guide →
➕ Math
SUMIF With Multiple Criteria: SUMIFS, OR Logic & Date Ranges
Complete SUMIFS guide — two conditions, date ranges, partial text matching, OR logic, and common mistakes. With copy-paste formulas.
Read guide →
🔍 Lookup
INDEX MATCH vs VLOOKUP: Why Experts Prefer INDEX MATCH
The 3 problems with VLOOKUP that INDEX MATCH solves — left lookups, column insertion resilience, multiple criteria. With side-by-side examples.
Read guide →
🔍 VLOOKUP
How to VLOOKUP From Another Sheet in Excel
Step-by-step guide to cross-sheet VLOOKUP — sheet references, different workbooks, common errors, and the XLOOKUP alternative.
Read guide →
⚖️ Logic
Excel IF Formula With Multiple Conditions: AND, OR, Nested IF
Complete IF guide — AND/OR logic, nested IF, IFS function, common mistakes, and when to use SWITCH instead.
Read guide →
🔢 Count
COUNTIF & COUNTIFS With Multiple Criteria: Complete Guide
Count cells with conditions — AND logic, OR logic, date ranges, partial text matching, and counting unique values.
Read guide →
💼 Finance
10 Excel Formulas Every Finance Professional Must Know
SUMIFS, INDEX MATCH, NPV, XIRR, DATEDIF, OFFSET, and more — with real financial modelling examples.
Read guide →
📊 Sheets
Google Sheets vs Excel Formulas: Key Differences
Functions that only exist in one platform, array formula differences, IMPORTRANGE, QUERY, and how to convert formulas between the two.
Read guide →