20 Pages · 150+ Formulas · $7 One-Time

Formula Cheat Sheet

The permanent desk reference you'll reach for every single day. Every formula, every syntax, both locales — on 20 tight, beautiful pages.

20-page PDF
European & US syntax
Printable A4 + Letter
VBA section included
PREVIEW

20 pages of pure reference

S
SheetMaster Formula Cheat Sheet
Page 4 / 20
SECTION 1 — LOOKUP & REFERENCE
XLOOKUPExcel 365 / 2021+
=XLOOKUP(lookup, range, return, [not_found], [match], [search])
🇪🇺 European
=XLOOKUP(A2;D:D;E:E;"—")
🇺🇸 US / Sheets
=XLOOKUP(A2,D:D,E:E,"—")
INDEX + MATCHAll versions
=INDEX(return_range, MATCH(lookup, lookup_range, 0))
🇪🇺 European
=INDEX(C:C;EQUIV(A2;B:B;0))
🇺🇸 US / Sheets
=INDEX(C:C,MATCH(A2,B:B,0))
+ 16 more formulas in this section…
TABLE OF CONTENTS

7 sections · 150+ formulas

18 formulas
§01

Lookup & Reference

  • VLOOKUP / RECHERCHEV
  • XLOOKUP
  • INDEX + MATCH
  • OFFSET
  • INDIRECT
  • CHOOSE
14 formulas
§02

Logic & Conditions

  • IF / IFS / SWITCH
  • AND / OR / NOT
  • IFERROR / IFNA
  • MAXIFS / MINIFS
22 formulas
§03

Text & Strings

  • LEFT / RIGHT / MID
  • FIND / SEARCH
  • SUBSTITUTE / REPLACE
  • TRIM / CLEAN
  • TEXT / TEXTJOIN
  • CONCAT / &
16 formulas
§04

Dates & Time

  • TODAY / NOW
  • EOMONTH / EDATE
  • NETWORKDAYS / WORKDAY
  • DATEDIF
  • YEAR / MONTH / DAY
  • WEEKNUM / WEEKDAY
24 formulas
§05

Statistics & Aggregates

  • SUM / SUMIF / SUMIFS
  • COUNT / COUNTIF / COUNTIFS
  • AVERAGE / AVERAGEIF
  • MEDIAN / MODE
  • LARGE / SMALL / RANK
  • STDEV / VAR
12 formulas
§06

Finance

  • PMT — loan payment
  • NPV — net present value
  • IRR — internal rate of return
  • FV / PV / RATE
  • XNPV / XIRR
  • YIELD / PRICE
10 macros
§07

VBA Basics

  • Loop through rows
  • Delete blanks/duplicates
  • Auto-filter & sort
  • Export sheet as PDF
  • Send email with attachment
  • Format range on open

Both syntaxes, always

Every formula shows the European (;) and the US/Sheets (,) version side by side. Switch locales — never look up syntax again.

🇪🇺 ; · 🇺🇸 ,
WHO IT'S FOR

Made for professionals, loved by everyone

Finally a reference that shows both French and English formula names. I keep it open in a second monitor every day.

M
Accountant / Controller

The VBA section alone saved me from hours of documentation hunting. Clear, commented, copy-paste ready.

R
Operations Analyst

I'm not a formula expert but this PDF makes me look like one. Date and conditional formulas explained perfectly.

A
Project Manager
PERMANENT REFERENCE

Stop Googling formulas.
Own your reference.

20 pages. 150+ formulas. A one-time $7 investment that pays back on the first formula you no longer have to look up.

Get the PDF — $7

One-time payment · Instant download · Print or use digitally