Sarah Schlott
  • Home
  • About
  • Services
    • FP&A Consulting
      • Forecasting & Planning
      • Scenario Modeling
      • Management Reporting
      • Cash Forecasting
      • FP&A Systems & Processes
      • Variance Analysis
      • KPI Dashboards
      • Board Reporting
      • FP&A for PE-Backed Companies
    • Accounting Services
      • Bookkeeping Support
      • Month-End Close
      • Financial Statements
      • Accounts Payable
      • Accounts Receivable
      • Accounting Cleanup
  • FP&A Resources
    • FP&A Library
    • Tools & Templates
    • Blog
  • Contact
  • Click to open the search input field Click to open the search input field Search
  • Menu Menu
Excel, Finance

How to VLOOKUP Your Will to Live: A Beginner’s Guide

Let’s not pretend anyone enjoys Excel.

You don’t crack open a spreadsheet because life is bursting with meaning.
You open Excel the way a mid-century housewife opened gin at 2pm: quietly, with dread, and because someone just asked about KPIs again.

So today, we’re doing something useful with it.
We’re going to use Excel to find your will to live.

Specifically:
We’re going to VLOOKUP the part of you that died three budget cycles ago.

Step 1: Open Excel. Feel the Shame.

The second that green icon loads, you know you’ve lost.

There’s no serotonin here. Only #REF! errors, passive-aggressive tabs named “Final_Final_v7,” and one cell whispering:

“You’re not paid enough for this.”

Step 2: Input Your Lookup Value (a.k.a. “Hope”)

In cell A1, type something that used to bring you joy:

  • "Purpose"
  • "Quiet focus time"
  • "Being able to pee without Slack notifications"

Hit enter. Watch it stare back like a hostage with Stockholm syndrome.

Step 3: Build Your Table Array (The Corporate Trauma Index)

Situation Outcome
“Quick re-org” 6 new bosses, no job description
“Culture refresh” No raises, but now with murals
“We need to be scrappier” You’re now Finance and HR
“Let’s be data-driven” Gut decisions, backfilled with charts

You’ve just built your first model of despair. Congratulations.

Step 4: Column Index Number (Choose the Flavor of Burnout)

Column 1 is what you signed up for.
Column 2 is what you actually do.
Column 3 is the quiet sound your soul makes when the Zoom call says “connecting…”

Pick a column. Any column. They all lead to therapy.

Step 5: Range Lookup (You Want the Ugly Truth, Not a Vibe)

Set this to FALSE, obviously.
We don’t approximate pain. We excavate it.

So your formula becomes:

=VLOOKUP("joy", A2:B20, 2, FALSE)

And Excel spits out: #N/A

Which is a deeply honest answer.

Step 6: Add Some IFERROR Logic (a.k.a. Emotional Buffering)

Protect yourself.

=IFERROR(VLOOKUP("meaning", A2:B20, 2, FALSE), "Apply to Patagonia")

Or, if you’re already broken in:

=IF(VLOOKUP("will_to_live", A2:B20, 2, FALSE)="", "Schedule fake dentist appointment", "Continue pretending")

Excel doesn’t judge.
It just enables.

Step 7: Conditional Formatting (Make the Breakdown Look Branded)

Now let’s add some color to the existential collapse:

  • If cell contains “synergy” → fill red
  • If column G > 80 hours → font color = white on white
  • If Slack status = “offline” → mark row as emotionally stable

You’re not just formatting cells.
You’re crafting your suicide note in Helvetica.

Final Step: Add a Pivot Table of Regret

Create a new sheet.

  • Rows: Years in this role
  • Columns: Promises made by leadership
  • Values: Broken dreams, summed

Filter by “Strategic Initiative.”
Cry.

Bonus Feature: Create a Dashboard for HR

Why not?

  • KPI 1: “Time Since Last Joyful Moment”
  • KPI 2: “Number of Passive-Aggressive Slide Edits”
  • KPI 3: “Instances of ‘Let’s circle back’ causing psychic harm”

Then present it. Watch their eyes glaze over.
You just got yourself invited to another “Wellness” offsite with no actual PTO.

Epilogue: The Spreadsheet Was Always Honest

You came looking for your will to live.
You didn’t find it.

But in the process, you built a functioning model of your corporate disillusionment.
And for once, the math reflected reality.

Not the version you present at the board meeting.
The version where you’re Googling “espresso machine repair certification” at 1am because that seems less chaotic than one more headcount sync.

So no—VLOOKUP can’t restore your spirit.

But it can tell you where it got buried.

And maybe that’s enough to start digging.

Now save the file as “Q3_Operating_Plan.xlsx” and send it to leadership with a smile.
They’ll never open it.
Which is fine—neither will your therapist.

August 6, 2025/1 Comment/by Sarah Schlott
Tags: Burnout, Excel, VLOOKUP
Share this entry
  • Facebook Facebook Share on Facebook
  • X-twitter X-twitter Share on X
  • Linkedin Linkedin Share on LinkedIn
  • Reddit Reddit Share on Reddit
  • Mail Mail Share by Mail
https://sarahgschlott.com/wp-content/uploads/2025/08/ChatGPT-Image-Aug-6-2025-11_49_07-AM-1.png 800 1200 Sarah Schlott https://sarahgschlott.com/wp-content/uploads/2026/08/icon-10c-two-blob-light_clearspace-300x300.png Sarah Schlott2025-08-06 11:55:232026-10-02 09:04:19How to VLOOKUP Your Will to Live: A Beginner’s Guide
You might also like
Why My VLOOKUP Has More Trust Issues Than My Ex
The CFO’s Guide to Scaling Financial Data Prep: From Manual to Automated Workflows
How Small Excel Tweaks Can Save You Hours in Month-End Reporting
Building FP&A From Absolute Zero: Katelyn Stienen on Budgets, Business Partnership, and the Stories Behind the Numbers
FP&A software planning and evaluation FP&A Software: When Does Your Finance Team Actually Need It?
7 Excel Functions That Will Replace Your Therapist (and Probably Your Job Too)
1 reply
  1. Sarah Schlott
    Sarah Schlott says:
    October 2, 2026 at 12:34 pm

    Are you still using VLOOKUP regularly, or has XLOOKUP finally won the argument in your models?

    Reply

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Join the Discussion Cancel reply

What do you think? No account or email required.

Latest Posts

  • Contractor+ Is Growing. I’m More Interested in What the Cash Has to Do Next.
  • Private Colleges Have a Revenue Problem That Looks Familiar
  • The Orlando Housing Story I’m Watching Isn’t Home Prices. It’s Household Pressure.
  • Bookkeeping vs. Accounting: What Does Your Business Actually Need?
  • The 2,232-Acre Osceola Data Center Story Needs One Important Asterisk
  • Orlando Tourism Doesn’t Get to Coast on Being Orlando
  • Statusphere Just Made a Very Physical Bet on Scaling Software
  • A $103 Million Orlando Industrial Deal Says More Than the Price Tag
  • How Much Do Accounting Services Cost in Orlando?
  • Carvana Is Adding 100 Orlando-Area Jobs. The Number I’m Watching Is What Comes Next.
  • Accounting Services in Orlando: What Should a Growing Business Actually Expect?
  • The FP&A Calendar: Build a Finance Rhythm That Leaves Time to Think
  • How Often Should You Update a Financial Forecast?
  • Capital Expenditure Forecasting: The Annual CapEx Number Is Not the Forecast
  • Gross Margin Forecasting: Revenue Can Be Right and the Economics Still Be Wrong
  • Forecast Assumptions: The Model Should Remember What Changed
  • Working Capital Forecasting: Why the P&L Can Be Right and Cash Still Be Wrong
  • Operating Expense Forecasting: Stop Treating Every Cost the Same
  • Month-End Close and FP&A: When Are the Actuals Actually Ready?
  • Ad Hoc Reporting in FP&A: When the Same Quick Question Keeps Coming Back
  • Headcount Forecasting: Why Approved Hires Keep Breaking the Plan
  • Management Reporting Pack: What CFOs Actually Need Every Month
  • Budget Variance Analysis: How FP&A Finds What Actually Matters
  • FP&A Software vs. Excel: When Has Finance Actually Outgrown Spreadsheets?
  • What Is FP&A? A Practical Guide to Financial Planning & Analysis
  • FP&A Software: When Does Your Finance Team Actually Need It?
  • Driver-Based Forecasting: How to Find the Right Business Drivers
  • Financial Forecasting Methods: How to Choose the Right One
  • Financial Scenario Planning: How FP&A Can Build Scenarios That Actually Help Management
  • AI Agents in Finance: What Should CFOs Actually Let Them Do?

Sarah Schlott

FP&A consulting, forecasting, accounting support and finance strategy for CFOs and growing finance teams.

Work With Sarah →

FP&A

FP&A ConsultingForecasting & PlanningScenario Modeling & Decision SupportManagement ReportingCash ForecastingFP&A Function & Finance SystemsVariance AnalysisKPI DashboardsBoard ReportingFP&A for PE-Backed CompaniesOrlando FP&A Consulting

Accounting

Accounting ServicesAccounting & Bookkeeping SupportMonth-End Close & Financial ReportingFinancial Statements & ReportingAccounts Payable SupportAccounts Receivable SupportAccounting Cleanup & Catch-UpOrlando Accounting Services
© Copyright - Sarah Schlott
Link to: What a 13-year-old babysitter taught me about financial leadership Link to: What a 13-year-old babysitter taught me about financial leadership What a 13-year-old babysitter taught me about financial leadership Link to: You Won’t Believe What This IF Statement Did to My Marriage Link to: You Won’t Believe What This IF Statement Did to My Marriage You Won’t Believe What This IF Statement Did to My Marriage
Scroll to top Scroll to top Scroll to top