Topics

Every VLOOKUP guide, error fix, and modern alternative in one place — basic syntax, multi-criteria, cross-sheet lookups, and the #N/A failures everyone hits.

XLOOKUP — the modern VLOOKUP replacement. Bidirectional, exact-match by default, built-in not-found handling. Every XLOOKUP recipe and fix here.

INDEX/MATCH is the most flexible lookup combo in Excel — works left, right, two-way, and multi-criteria. Every recipe, two-way lookup, and fix collected here.

Conditional sums — total only the rows that match one or more criteria. Every SUMIF / SUMIFS recipe, gotcha, and error fix.

Counting cells that meet a condition — or many conditions — with COUNTIF and COUNTIFS. Every recipe and fix collected here.

Every lookup variant beyond VLOOKUP / XLOOKUP / INDEX-MATCH — HLOOKUP, LOOKUP, two-way, case-sensitive, nth-match. The full lookup toolkit.

Group-by, distinct count, running totals, crosstabs — every pivot-style summary built with formulas, without ever touching the pivot dialog.

LAMBDA lets you define your own reusable functions inside the spreadsheet. Every LAMBDA recipe — BYROW, BYCOL, MAKEARRAY, named LAMBDA — collected here.

LET introduces local variables inside a formula so long expressions become readable and faster to recalculate. Every LET pattern here.

QUERY brings SQL-style data wrangling to Google Sheets — filter, group, pivot, join. Every QUERY recipe and pattern collected here.

ARRAYFORMULA applies a formula across a whole column without dragging. Every Google Sheets ARRAYFORMULA pattern here.

IMPORTRANGE pulls live data from one Google Sheet into another. Setup, gotchas, and the common combinations with QUERY and VLOOKUP.

Every percentage recipe — calculate, increase, decrease, percent of total, year-over-year, market share, percent of target achieved.

Working with dates and times — calculate age, days/months/years between, business days, fiscal quarters, overdue flags. Every date recipe and DATEDIF gotcha.

MRR, ARR, CAC, LTV, NRR, GRR, churn, runway, magic number, rule of 40 — every SaaS metric as a verified formula you can drop in and own.

Conditional logic with IF — single condition, AND/OR combinations, nested ladders, IFS for multi-branch, IFERROR/IFNA for safe defaults.

Split, join, extract, replace, clean — every text-handling pattern from name splitting to building URL slugs to normalizing phone numbers.

Totals at every shape — SUM, SUMPRODUCT, SUBTOTAL, running totals, cumulative sums, conditional and multi-criteria sums.

Count cells by every condition — COUNT, COUNTA, COUNTBLANK, distinct counts, conditional counts, counts within ranges, and overlap counts.

ROUND, ROUNDUP, ROUNDDOWN, MROUND, CEILING, FLOOR, INT, TRUNC — every way to round, plus padding zeros and clean number formatting.

Ranking, percentiles, leaderboards, weighted scores, z-scores, normalization — every statistical aggregate beyond AVERAGE.

AVERAGE, AVERAGEIF/AVERAGEIFS, MEDIAN, MODE, moving averages, weighted averages — every way to summarize a set to one number.

Find duplicates, remove duplicates, build sorted-unique lists, flag repeats, compare two lists for overlap or differences.

Highlight cells that match a rule — duplicates, dates, thresholds, top N, blank rows. Every formula you can use as a Conditional Formatting rule.

Transpose, fill blanks, merge columns, split a cell into rows, auto-number, build sequences and frequency distributions — the data-prep toolkit.

Loans, interest, depreciation, amortization, tax, margin, ROI, CAGR, break-even — every classic finance formula as a verified recipe.

Convert between inches/cm, kg/lb, celsius/fahrenheit, miles/km, feet/m, bytes/KB/MB, minutes/hours — every common unit conversion.