May 26

All Excel LOOKUPs Explained



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!

Loved this? Spread the word

About the Author

Jordan Goldmeier

Related posts

How to: Power Query File From Folder

Read More

2020 – I can’t wait!

Read More

Oz’s Excel Tip: Keep a Workbook for Random Data in Excel

Read More

Monte Carlo Simulation in Excel with a Poisson Distribution

Read More
  • 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"}

    Subscribe to our newsletter now!