Lookup values across multiple worksheets: VLOOKUP / INDEX MATCH in Excel

Learn how to use Excel for looking up values across multiple worksheets. Ideal for users of all levels, this video guides you through different methods, including VLOOKUP and INDEX & MATCH, to handle complex data sets efficiently.

👩‍💻 What You'll Discover:
▪️ Dynamic Lookup Techniques: Learn how to retrieve data dynamically from multiple tabs using VLOOKUP and INDEX & MATCH.
▪️ Practical Scenarios: Understand the process through practical examples, like summarizing invoiced amounts from different divisions.
▪️ Table Conversion and Use: See how converting data into Excel tables can simplify your lookup processes.
▪️ Indirect Function for Flexibility: Explore the power of the INDIRECT function for creating dynamic references in your formulas.

In this Excel tutorial I show you how to lookup values from multiple Excel Sheets or tabs. In Excel it's relatively easy to lookup values in one specific tab. But how do you lookup values in multiple tabs using just one single formula?

00:00 Lookup Values in Multiple Worksheets in Excel
02:15 VLOOKUP Across Multiple Worksheets
07:43 INDEX & MATCH Across Multiple Worksheets

In the video, I show you different versions of getting this done. One version uses VLOOKUP and direct worksheet and cell references. The other version uses INDEX & MATCH and Excel table names and references. The key here is the INDIRECT function which acts as the messenger which returns the correct address to the different lookup formulas.

Of course, you can apply this (indirect) method inside other formulas.

Links to related videos:

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel

[BoardgameBaker]

I feel like a kid watching Wayne Gretzky play ice hockey. This level of Excel knowledge borders on witchcraft. Really impressive, Leila!

[prakashreddy]

Leila You are always inspiring me, thank you so much for your detailed explanation.
You've always sounded good, but this was your best! big fan of your sweet voice.😊

[johnnyfiver]

I've watched it several times and still confused. Guess I've got to back up and learn the basics of VLOOKUP and INDIRECT before trying to tackle this one. Thought I knew Excel until I found this series. She is the MASTER of Excel, thats for sure. I'm impressed with her knowledge.

[stephanetrottier]

FINALLY!!! Someone who can explain things in a clear way and make it look easy!! I've subscribed because of your entire series on INDEX MATCH & VLOOKUP...!!!! Thanks for these videos, even if it's 3 years old!!!

[WintaLe]

You helped me solve an excel problem that I've been stuck on for 3 days. Thank youuu!! Subscribed.

[aaronwait]

I've been trying to work out how to do this for my assessment for the past couple of hours. Watched 4 minutes of your video and I've nailed it.

[ajaysharma-gwvy]

have re-winded the video couple of times to fully understand the concept..but every second worth it. thanks

[orcniffp]

Everytime I hear this girl say "Today, I am gonna show you..." I get the shivers!

[unforgetable]

Saved me a lot of time that otherwise would have wasted on making nested if formulas for 10 worksheets. Thanks a lot. Your channel is really the best one out there.

[apwnew]

Leila - the session is incredibly supportive. Thank you for that one! :) I appreciate it.

[lucasb]

currently pulling my hair out trying to figure out a solution. But your videos make my life much easier. Thank you.

[rinaful]

I am blown away Excel has a lot to offer!

[kbalaji]

great... its very easy to understand the way you are explaining complex things in simple way..

[ernahubbard]

Thank you so much for the explanation, finally got it working with your video and example file, the brackets and other tiny details are killing me.

[MrLinkolin]

This is sooo helpful, thanks for these tips! The INDEX(INDIRECT really helped me!

[kevinerickson]

You have helped me countless times! Thank you so much for all your videos.

[maherhadi]

excellent and crystal clear explanation, many thanks for sharing.

[excelisfun]

Great video : ) Such a useful set of tricks!

[propixelperfect]

Thank you very much Leila...You will be remembered😌😌

[ulrichboussouka]

Leila you are one of the best ever.im from Gabon very passionated with your excel classes.thanks a lot for what your help to humanity