May 26

All Excel LOOKUPs Explained


Excel Ultimate Lookup Guide Free Download

Sorry about how late this post is. Some of you might’ve noticed that the video was already out. The reason is because I wrote this really, really long explanation. And, let me tell you, it was a good one. But whenever I tried to save it–it wouldn’t save! I had rewritten it five times–and still, it hadn’t saved. 

Why? Because I was using emojis in my explanation. Most people explain Excel using examples with text and numbers. But I recently started using symbols. And I really like this mode of teaching. 

The problem is that our WordPress Content Management System doesn’t allow me to use emojis in blog posts. It took me forever to figure it out. 

So what I’ve done is add my Ultimate Excel Lookup Guide as a download. 

You can download it by clicking here.

I would also strongly encourage you to watch the video and ask any questions you might have. 

What did you think about this guide? Are you a fan of XLOOKUP? 

Let us know in the comments!


You may also like

February 17, 2022

Edit Excel Formulas in WORD – Spreadsheet Tips and Tricks

February 8, 2021

51: Oz du Soleil & the Global Excel Summit 2021

January 29, 2021

Global Excel Summit 2021

January 22, 2021

50: Randy Austin – Excel for Freelancers

January 8, 2021

49: Theresa Estrada – Microsoft Principal Program Manager Lead

May 26, 2020

All Excel LOOKUPs Explained
  • Hi Jordan,
    I’m surprised why you forgot to include my favorite LOOKUP. For me, it is the most powerful of all Excel functions, other than Dynamic Arrays.

    • That’s fair. Honestly, I think I came in after the LOOKUP craze. I can’t even think of one time I’ve used it. Not saying it’s not useful, but it never really entered into my repertoire. But I have heard, as you say, that it is a favorite among the LOOKUP-ers. I appreciate you letting people know that it’s there and one of your Go-Tos!

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    Free Power User Quick Guide

    Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

    With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.