Formulas

Deep dives into the functions that do the heavy lifting, and the ones you should stop using.

FormulasMarch 4, 20252 min read

Why your VLOOKUP returns #N/A when the value is clearly there

Nine times out of ten it is not the formula. It is an invisible character, a number stored as text, or an approximate match you never asked for.

EMElena MarshHead of Content, former FP&A Manager

FormulasFebruary 11, 20252 min read

XLOOKUP is better in almost every case. The exceptions are real, though, and worth knowing before you rewrite a model.

EMElena MarshHead of Content, former FP&A Manager