TRENDING:
What is Zero Trust Security
How to Uninstall Windows Microsoft Store?
Using Password Managers: A Simple Solution to Password ...
About
Learning Hub
Tutorials
Functions
Formulas
Shortcuts
Archives
Contact Us
Select Page
Formula Library
Excel & Google Sheets
Formulas
Browse 361 practical formulas by category, search by name, or scroll A to Z.
Count
Sum
Lookup
IF & Logic
Date & Time
Text
Dynamic Array
361 formulas • Excel and Google Sheets • all on one page
Tutorials
Videos
Templates
Functions
Formulas
Shortcuts
Articles
All
30
Average
1
Count
12
Date and Time
3
Financial
1
If and Logic
4
Lookup
4
Percentage
1
Sum
2
Text
2
Quick Formula Index
Type a formula name to search, or jump to a letter.
×
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
I
Lookup
X
G
INDEX MATCH Basic Example in Excel and Google Sheets
INDEX MATCH is the lookup combination that power users swear by. While VLOOKUP is simpler to…
→ View formula
V
Lookup
X
G
VLOOKUP Basic Example in Excel and Google Sheets
VLOOKUP is the lookup formula most people learn first, and for good reason — it solves…
→ View formula
Lookup
X
G
VLOOKUP with IFERROR in Excel and Google Sheets
VLOOKUP with IFERROR is one of the first formula combinations I teach anyone who uses lookups…
→ View formula
X
Lookup
X
G
XLOOKUP Basic Example in Excel and Google Sheets
XLOOKUP is the formula I now reach for every time I used to write VLOOKUP. Microsoft…
→ View formula
×
Syntax
Syntax description