Show Menu
Cheatography
  1. Home >
  2. Cheat Sheets >

Excel Formulas Reference Cheat Sheet (DRAFT) by

Commonly Used Formulas

This is a draft cheat sheet. It is a work in progress and is not finished yet.

Lookup

VLOOKUP(lookup­_value,table_­array,col_in­dex­_number,range_­lookup)
Vertical Lookup
HLOOKUP(lookup­_value,table_­array,row_in­dex­_number,range_­lookup)
Horizontal Lookup
INDEX(result range, row, column)
Index Number Lookup
MATCH(lookup­_value, lookup­_array, match type)
Match Lookup
INDEX(result­s_array, MATCH(lookup­_value, lookup­_array))
INDEX, MATCH Lookup
INDEX(result­s_array, MATCH(row_lo­oku­p_value, row_lo­oku­p_array), MATCH(col_lo­oku­p_value, col_lo­oku­p_array))
2D INDEX, MATCH, MATCH Matrix

Logic

IF(argument, true_s­tat­ement, false_­sta­tement)
AND(first_­arg­ument, second­_ar­gument)
TRUE if both are TRUE
OR(first_­arg­ument, second­_ar­gument)
TRUE if either are TRUE
NOT(argument)
Reverses Results
IFERROR(value, value_­if_­error)
Returns value_­if_­error if error occurs.