VLOOKUP vs XLOOKUP in Excel: When Each Works, When Both Fail, and Why INDEX/MATCH Still Matters VLOOKUP All Excel versions — right-only, breaks on column insertion XLOOKUP Microsoft 365 / 2021 — any direction, fallback value, match modes INDEX/MATCH All Excel versions — two-way, immune to column insertion #N/A All three return this when the […]

Excel Tables: Convert Every Dataset Before You Touch It Ctrl+T Keyboard shortcut to convert any range to an Excel Table Auto Tables expand automatically when new rows or columns are added [@Col] Structured references — formulas that name columns, not cell addresses 1-click Power Query and pivot tables refresh against the full Table automatically An

IF, AND, OR in Excel: Building Conditional Logic Without Losing Your Mind IF Returns one value if condition is true, another if false AND TRUE only when every condition is true OR TRUE when at least one condition is true IFERROR Catches any error and returns a fallback value IF, AND, and OR are the

Absolute vs Relative Cell References in Excel: Why Your Formulas Break When You Copy Them 4 types of cell reference in Excel F4 Keyboard shortcut to cycle all reference types $ The only character that locks a reference #REF! The error that tells you a reference broke Absolute and relative cell references control whether a