- The Workbook
- Posts
- My 1 favorite life hack đĄ
My 1 favorite life hack đĄ
Do you *actually* know how to use XLOOKUP?
Hey there! Is 2024 the year you plan on landing your dream job or securing a raise? đ Then donât miss my (free!) XLOOKUP and VLOOKUP classes. In just one hour, youâll upgrade your Excel skills, making you more valuable at workâleveraging your time, salary, and title. đ There are only two classes left:
Thursday, November 9th at 3 PM EST
Friday, November 10th at 12 PM EST
If none of the dates work for you, you can register to get the free replay!
Grab your seats here. I canât wait to see you there!


How to Use XLOOKUP With Multiple Criteria
Imagine youâre at the office (or if youâre reading this from the officeâŠhey đ).
Itâs 4:58 PM, and youâre about to log out for the day when your boss asks you to find some data from a spreadsheet.
âNot a problem! Iâll just XLOOKUP,â you think. But then you realize that what youâre looking for has multiple criteria. Those happy hour plans start to slowly fade away⊠đ«
You may have only ever used XLOOKUP for one conditionâbut I have a tip that allows you to use it for multiple criteria. The best part? Happy hour plans can stay on the cal. Letâs dive in:
Say you want to find the price of a Hersheyâs. We have four criteria: candy, size, nuts or no nuts, and price (yes, Halloween just passed but its spirit lives on).
Step 1) In your desired cell, start with XLOOKUP(1

Step 2) Select the first array that includes the first condition youâre searching forâin our example, thatâs the type of candy. Our formula is now XLOOKUP(1,(A2:13=G3)*

Step 3) Select the second array that includes the second criteria you need (for us, thatâs size!). The formula is now XLOOKUP(1,(A2:A13=G3)*(B2:B13=G4)*

Step 4) Now, highlight the third array (nuts). The formula is now XLOOKUP(1,(A2:A13=G3)*(B2:B13=G4)*(C2:C13=G5),

Step 5) Almost there! Highlight the last array, which has the criteria youâre ultimately searching for, and close it out with parentheses. The final formula is XLOOKUP(1,(A2:A13=G3)*(B2:B13=G4)*(C2:C13=G5),(D2:D13))

There you have it! We go over XLOOKUP tips just like these (and tons more!) in my Excel class today and tomorrow. Itâs not too late to join and level up your skill set so youâll never miss another after-work hang again. đ


One of My Favorite Life Hacks

The #1 life hack I swear by? Itâs not getting up at 5 AM. Itâs not cold plunges, breathing exercises, or celery juice. Itâs not even meditationâand if you know me, you know how much meditation has changed my life!
Itâs constantly switching up my routine.
For the past few months, I've been adding some âš pizzazz âš to my day-to-day. In September, I visited a glacier cave 10,000 feet above a mountain. The next week, I was traveling the Arizona desert. But I was also adding in some smaller changes: trying a new coffee shop, workout class, dinner recipe, etc.

Mike and I up in the glacier đ
Why I go out of my way to do new things?
Neuroplasticity. Hereâs what I mean:
Neuroplasticity is the brainâs ability to form synaptic connections. When we follow our routine, our brain uses the same neural pathways.
Over time, these pathways become highly efficient. But thereâs a tradeoff: a cognitive ârigidityâ where weâre less able to adapt to new information or situations.
The key to melting that rigidity? You guessed itâswitching up our routines. It snaps us out of autopilot so we can develop new brain pathways, improving cognitive functions such as memory, problem-solving, and creativity.
When you adapt to something new (whether itâs as small as trying a new grocery store or as big as moving to a new city), youâre enhancing your ability to learn and grow. This propels you toward your goals instead of keeping you in your comfort zone.
Author Jen Sincero has a great way of explaining just how trying new things is key to our personal growth:
âIf you want to live a life youâve never lived, you have to do the things youâve never done.â
So go out there and break your routine. I promise itâll pay off in more ways than one! đ


This list of 100 productivity tips for Excel, PowerPoint, Word, and Outlook is incredible. đ€©
11 features in Windows 11 you wonât want to miss (the file explorer tab is my favorite!).
The No Straight Path podcast aims to humanize successâwithout the shiny resumes and social media highlights. Check out their latest conversation with author and psychiatrist Justin Key.*
How to have a âBare Minimum Mondayâ and still crush your to-do list. đȘ
Why sometimes the best thing you can do is figure out what not to do.
*This is sponsored advertising content.


Thanks for being here and hope to see you in class! Almost 40,000 of you saved your seat and my excitement levels are through the roof. To deal, your girl is swapping out the coffee for tea this week so I don't bounce off the walls. đ€Ł
Stay Exceling,
Kat