Formula library
Quick references for the formulas people ask about most — each with a paste-ready example for Excel and Google Sheets. Or just describe what you need.
Lookup
VLOOKUP
→Look up a value in the first column of a range and return a value from another column in the same row.
XLOOKUP
→The modern replacement for VLOOKUP and INDEX/MATCH — look up a value and return a match in any direction.
INDEX / MATCH
→A flexible two-function lookup that can return values to the left of the lookup column.
QUERY (Google Sheets)
→Run SQL-like queries over a range in Google Sheets to filter, sort, and aggregate.
ARRAYFORMULA (Google Sheets)
→Apply a formula down an entire column at once in Google Sheets.
Math & Aggregation
SUMIF
→Add up the cells in a range that meet a single condition.
SUMIFS
→Sum values that meet multiple conditions at once.
COUNTIF
→Count the cells in a range that meet a condition.
COUNTIFS
→Count cells that meet several conditions simultaneously.
AVERAGEIF
→Average the values in a range that meet a condition.
UNIQUE
→Return the distinct values from a range, removing duplicates.