Скачать с ютуб Use the INDEX & MATCH Functions to Perform Lookups в хорошем качестве

Use the INDEX & MATCH Functions to Perform Lookups

Have you every used VLOOKUP to do look ups from table to table? If you have you'd know there were some limitation on how it performs look ups, such as it would only lookup up the item in the first column of the table you are trying to bring data over from. There are multiple ways to get around that limitation, but another method is to use the INDEX & MATCH formulas to perform table look ups. This is not a INDEX MATCH vs VLOOKUP video, but it'll cover the same concepts of what a lookup is supposed to do. It might be scary at first because some consider the INDEX and MATCH pair an advanced lookup technique. Whatever your criteria (or if you have multiple criteria) once you get the hang of using these two function together you'll find it very useful and maybe even easy! Check out the video to see example of how it's done. 🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p 🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr... 📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough ⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53 ⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G ⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101 📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support! 🎁 If you find these videos useful and want to support my channel go to https://www.buymeacoffee.com/dough #excel #msexcel #doughexcel ~-~~-~~~-~~-~ Please watch: "Convert Table in a PDF File to Excel"    • Convert Table in a PDF File to Excel   ~-~~-~~~-~~-~