1
A1:L1 · Cell value
Formula guides.
A22
Step-by-step guides to the formulas people search for most — for Excel, Google Sheets and Apple Numbers. Describe what you need and FormulaAI writes it for you.
3
All guides
VLOOKUP Guide
How to use VLOOKUP in Excel, Google Sheets & Numbers — syntax, examples and common errors.
XLOOKUP Guide
The modern replacement for VLOOKUP: search in any direction with built-in error handling.
INDEX MATCH Guide
The most flexible lookup combination — robust against inserted columns and left lookups.
SUMIF & SUMIFS Guide
Conditional sums by one or more criteria.
SUMIFS with Multiple Criteria
Multiple conditions, date ranges, wildcards, OR logic and the #VALUE! size-mismatch error.
IF Formula Guide
Conditional logic: nested IF, IFS, AND/OR and IFERROR.
Fix the #REF! Error
What causes the #REF! error and how to fix it step by step.
Google Sheets Formulas
QUERY, FILTER, ARRAYFORMULA, IMPORTRANGE and other Sheets-only functions.
Google Sheets QUERY
SQL-like queries over your data: SELECT, WHERE, ORDER BY, GROUP BY.
Apple Numbers Formula Help
How Numbers differs from Excel — VLOOKUP, INDEX/MATCH and supported functions.
4