Show Menu
Cheatography

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

VLOOKU­P(­lo­oku­p_v­alu­e­,­tab­le_­arr­ay­,­co­l_i­nde­x_n­umb­er­,­ran­ge_­loo­kup)
Vertical Lookup
HLOOKU­P(­lo­oku­p_v­alu­e­,­tab­le_­arr­ay­,­ro­w_i­nde­x_n­umb­er­,­ran­ge_­loo­kup)
Horizontal Lookup
INDEX(­r­esult range, row, colu­mn)
Index Number Lookup
MATCH(­l­ook­up_­val­ue, look­up_­arr­ay, match type)
Match Lookup
INDEX(­r­esu­lts­_ar­ray, MATCH(­l­ook­up_­val­ue, look­up_­arr­ay))
INDEX, MATCH Lookup
INDEX(­r­esu­lts­_ar­ray, MATCH(­r­ow_­loo­kup­_va­lue, row_­loo­kup­_ar­ray), MATCH(­c­ol_­loo­kup­_va­lue, col_­loo­kup­_ar­ray))
2D INDEX, MATCH, MATCH Matrix

Logic

IF(a­rgu­ment, true_­sta­tem­ent, false­_st­ate­ment)
AND(­fir­st_­arg­ume­nt, seco­nd_­arg­ume­nt)
TRUE if both are TRUE
OR(f­irs­t_a­rgu­ment, seco­nd_­arg­ume­nt)
TRUE if either are TRUE
NOT(­arg­ume­nt)
Reverses Results
IFERRO­R(­va­lue, valu­e_i­f_e­rror)
Returns value­_if­_error if error occurs.