Excel cheatsheet

Formulas by task — lookup, aggregation, text, dates, logic

Category

A cheatsheet of productive Excel/Google Sheets formulas. In Sheets, local locales use ; as argument separator, English uses commas. 365 formulas (XLOOKUP, FILTER, LET) work in newer versions and Sheets.

Formulas

XLOOKUP(знач; стовп; стовп_рез)

Modern VLOOKUP replacement — finds and returns

INDEX(діап; MATCH(знач; стовп; 0))

Classic for older versions

FILTER(діап; умова)

All rows matching condition (365)

IFERROR(формула; значення)

Replace errors with a value