Dynamic arrays
XLOOKUP returning multiple values
Learn how XLOOKUP can return multiple columns, when FILTER is a better fit, and how to avoid spill errors.
XLOOKUPFILTERCHOOSECOLSTOCOL
Formula guides
Specific answers for real spreadsheet formula problems.
Short, practical guides focused on Excel formulas, Google Sheets equivalents, and the kind of spreadsheet problems that show up in classes, internships, and analyst work.
Dynamic arraysLogical formulasLookup formulasDate and time formulas
Logical formulas
SUMIFS with multiple OR conditions in Excel
Learn practical ways to use SUMIFS with OR logic, including helper formulas, array constants, and mistakes that cause duplicated totals.
SUMIFSSUMCOUNTIFSFILTER
Lookup formulas
INDEX MATCH with multiple criteria
Use INDEX MATCH with multiple criteria when one lookup value is not enough, with examples, pitfalls, and performance guidance.
INDEXMATCHXLOOKUPFILTER
Date and time formulas
Excel IF with dates
Write IF formulas with dates safely in Excel, including TODAY, DATE, date thresholds, and common serial-number mistakes.
IFTODAYDATEWORKDAY
Dynamic arrays
FILTER function examples for practical spreadsheet problems
Practical FILTER examples for Excel dynamic arrays, including multiple conditions, blank results, spill errors, and Google Sheets equivalents.
FILTERSORTUNIQUECHOOSECOLS