• 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