- The Workbook
- Posts
- How to (actually) see obstacles as opportunities š”
How to (actually) see obstacles as opportunities š”
Plus: VLOOKUP to return multiple columns
Hey there! The other day, somebody asked me the other day: Why do you love Excel so much?
I get it. At first glance, Excel seems boring at best and intimidating at worst. But when you learn how to use Excel, it opens up your entire world. Itā¦
Saves you hours each week
Helps you secure your dream job
Makes you more confident at work
This is why I love Excel and why I do what I do. On that note: Iām rolling out free Excel classes this June about my most highly-requested topic yet. Stay tuned!


Seamlessly Return Multiple Columns in Seconds
Hereās how Excel users at different levels would handle this request: š
āCan you find Garciaās sales numbers for the year and Q1?ā
Excel Beginner: ā āIāll just manually scan the spreadsheet.ā
Excel Intermediate: ā āIāll use basic filtering to find Garciaās sales.ā
Excel Pro: ā āIāll use a VLOOKUP formula to return multiple columns.ā
Want to be on the Excel prosā level? Of course you do (you wouldnāt be here otherwise)! Hereās how youād do it:
Step 1) Type =VLOOKUP(
Step 2) Select the Lookup Value (in our case, thatās E5).
Step 3) Select the entire table array. Our formula is: =VLOOKUP(E5,A1:C26,
Step 4) Enter the index numbers of the return columns in curly braces. Our formula is =VLOOKUP(E5,A1:C26,{3,2},
Step 5) Select FALSE for an exact match before closing the formula. The final formula is =VLOOKUP(E5,A1:C26,{3,2},FALSE)
All done. Now you no longer have to run several VLOOKUPs to return multiple columns and are *this* š¤ much closer to becoming an Excel pro.


How to (Actually) See Obstacles as Opportunities
Youāve heard it a million times: Obstacles are opportunities in disguise.
But letās be real: Itās hard to see the silver lining during tough timesālike getting ghosted by a recruiter, a client pitch gone awry, or being let go from your dream job.

When those obstacles just make you want toā¦ āļø
But something thatās always helped me see the bigger picture?
This analogy from life coach Marie Forleo:
āSay youāre watching a two-hour movie, and 45 minutes in, all hell breaks loose. If you walked out at that very moment, youād think the character was a total failure. But thatās just an inflection point. Their story isnāt over. And neither is yours.ā
When I first heard this, I realized:
Obstacles are normal in the main characterās journey. Imagine if your favorite character never went through any hardships, or worse, gave up the second they ran into setbacks. Thatād be a terrible movie, right?
So to see obstacles as opportunities, see yourself as the main character.
And you do that by asking yourself: āIf I were watching my life as a Netflix movie, what would I want my character to do?ā
For example: Does your characterā¦
Forgo the job search after a recruiter ghosts themā¦or keep going?
Never present again after pitch goes awryā¦or learn how to present?
Quit after not getting a promotionā¦or use it as a catalyst for growth?
āSetbacksā are just one part of your story. By seeing your life as a movie (and adopting that āØ main character energy āØ), you can turn your next scene into something great.


Short Squeeze is a bite-sized newsletter that gives you all the Wall Street news in five minutes. Join its 200K finance professionals today.*
Have zero idea what to do with your life? Thereās a guide for that.
Iām looking for a man in finance: 6ā 5ā, blue eyes: Excel version.
How I navigate perfectionism, people pleasing, and imposter syndrome.
The most common mistake I see in Excelāand how to fix it. š§
*This is sponsored advertising content.


Thanks for being here! Are you looking for a summer read thatāll help you grow? I got you. Hereās a list of my favorite books (plus music, podcasts, and documentaries!) that have been huge contributors to my personal growth.
Stay Exceling,
Kat