Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Lookup values across multiple worksheets: VLOOKUP / INDEX MATCH in Excel. That video is uploaded by Leila Gharani at 2017-11-17T00:49:02-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [2erErC7LvPY]
| Name | Lookup values across multiple worksheets: VLOOKUP / INDEX MATCH in Excel |
| Video Uploader | Video From Leila Gharani |
| Upload Date | This Video Uploaded At 17-11-2017 08:49:02 |
| Video Discription | Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-courses 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. ⬇️ Download the workbook here: https://pages.xelplus.com/lookup-different-sheets 👩💻 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: VLOOKUP explained ► https://youtu.be/E7gQ-PgYkMc INDEX MATCH Basics ► https://youtu.be/F264FpBDX28 INDIRECT explained ► https://youtu.be/GUClkvJ7Gag ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ 🚩Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus 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 2erErC7LvPY |
| Category | Education |
| Tags | vlookup different sheets | lookup across multiple tabs | table names | excel vlookup multiple sheets | index match across multiple sheets | Excel table references | excel indirect | excel index match | excel substitute formula | sheet reference | excel vlookup | vlookup in multiple sheets | XelplusVis | Advanced Excel Tutorials | Leila Gharani | Excel 2016 | Excel 2013 | Excel 2010 | Advanced Excel tricks | Excel online course | Excel tips and tricks | Excel for analysts |
