Why My VLOOKUP Has More Trust Issues Than My Ex

“If your forecast only works when you believe in it, it’s not a forecast—it’s a faith-based initiative.”

It started with a spreadsheet.
Doesn’t it always?

One column of “Actuals,” one column of “Plan,” and a third column that looked like it was about to ghost me. That’s where VLOOKUP lived—dragged across 400 rows, promising to unite my pristine model with the messy, contradictory truths of real-world data.

And then it lied.

Not an outright lie—more like the kind of half-truth your ex would tell:

“Oh, I thought that was the right range.”
“We must have miscommunicated.”
“It’s not me—it’s the reference cell.”

Half the numbers were wrong. Not catastrophically wrong—just wrong enough to quietly blow up every forecast downstream: headcount plans bloating like a housing bubble, CAC shrinking like it’s been on Ozempic, cash runway stretching into the future like a mirage you really want to believe in.

And the worst part? No one noticed for three weeks. Because in FP&A, “the model” is like that friend you don’t question because they sound confident.

The Unspoken SaaS Finance Problem

“We’ve built a religion around manual, brittle tools that demand faith over evidence.”

This isn’t about one formula. It’s a cultural flaw.
We’ve built a religion around manual, brittle tools that demand faith over evidence. Excel is the high priest. VLOOKUP is the unreliable altar boy.

And SaaS founders and CFOs are making real hiring and funding calls on the back of functions that break if someone sneezes on column B.

How a Broken VLOOKUP Wrecks a Business

A single glitch in your revenue table can trigger:

• Phantom hiring for roles you can’t actually afford.
• ARR lies that make the board think you’re winning while MRR quietly bleeds out.
• Dashboard theater—pretty formatting hiding numbers that wouldn’t survive one honest question.

“A spreadsheet that ‘looks fine’ can be more dangerous than one that’s obviously broken.”

The FP&A Advice That’s Making This Worse

Old-school fixes—“better hygiene,” “more consistent range names”—are like putting a fresh coat of paint on a condemned building.
They don’t fix the foundation.

If your process relies on you catching errors at the last minute, you don’t have a forecasting system—you have a spreadsheet haunted house.

The Three-Step Cure for Spreadsheet Betrayal

1. Kill fragile lookups. Use persistent joins in a database.
Excel is a great calculator. It’s a terrible database.

2. Build metrics that self-heal.
If definitions change, your entire reporting layer should update instantly.

3. Make reconciliation continuous, not ceremonial.
Daily automated checks keep “trust” from being a quarterly leap of faith.

Stop Treating Your Forecast Like a Religion

Your finance stack should work like air traffic control—visible, verifiable, and built to withstand chaos.

If your forecast only works when you believe in it, it’s not a forecast—it’s a faith-based initiative.

And faith won’t make payroll.