The Formula Cheat Sheet — The 50 Most Important Excel Formulas
Forget googling formula syntax. Download our complete reference with the 50 most useful Excel formulas — with examples and practical tips.
What is included?
- ✓ 50 formulas organised by category (Mathematical, Logical, Lookup, Text, Date & time)
- ✓ Practical examples for every formula
- ✓ Common error messages and solutions
- ✓ Tips for combining formulas
- ✓ Swedish formula name + English (for international Excel)
Examples from the PDF
VLOOKUP
=VLOOKUP(lookup_value, table_array, col_index_num, [intervalluppslag])
Use case: Look up a product price based on a product code
Example: =VLOOKUP(A2, Pricelist!A:D, 3, FALSE)
Common error: #N/A — Check that the lookup value exists in the first column
Get the Formula Cheat Sheet in your inbox
Enter your e-mail and we will send you the PDF in 30 seconds. Completely free.
Created by Lukas Lilja, Excel consultant since 2010.
