=XLOOKUP(A2,D:D,E:E,"—")

=IFERROR((B2-B1)/B1,0)

=PMT(rate/12,nper,-pv)

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.

Get the PDF — $7

✓20-page PDF

✓European & US syntax

✓Printable A4 + Letter

✓VBA section included

PREVIEW

20 pages of pure reference

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.

Accountant / Controller

“

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

Operations Analyst

“

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

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.