In this Excel index match tutorial I show you how to use Excel's INDEX function and MATCH function to look up data in one spreadsheet and match it with data in another. Very similar to how you join data in SQL. In my previous video I showed you SQL joins. Check it out here: https://www.youtube.com/watch?v=903CTKfJk74 00:00 Intro 00:35 INDEX & MATCH 03:44 Multiple Criteria START YOUR BI JOURNEY! - https://learnbi.online/ 🎥 RECOMMENDED VIEWING 7 Steps to Your 1st BI Analyst Job - https://geni.us/7stepstobivid Learn Basic SQL in 15 Minutes - https://geni.us/learnbasicsql15-1 BI For Beginners Playlist - https://geni.us/biforbeginners-play 🎓 RECOMMENDED COURSES Power BI For Business Intelligence - https://geni.us/powerbi-udemy Ultimate Guide to Google Data Studio - https://geni.us/vbi-edu Google Data Analytics Course - https://geni.us/coursera_analytics Learn SQL - https://geni.us/learnsql SKILLSHARE - 30-day free trial! - https://geni.us/skillshare30day UDEMY - https://geni.us/udemy_vb 📕 FREE EBOOKS 7 Top Tips For Better Dashboard Design - https://geni.us/dashdes-ebook Skills You Need To Succeed In BI - https://geni.us/biskills-ebook 🧰 BI TOOLS Power BI - https://powerbi.microsoft.com/ Tableau - https://www.tableau.com/ Data Studio - https://datastudio.google.com/ 📊 DATA HUBS & WEBSITES: Power My Analytics: https://geni.us/YLc9Re Supermetrics: https://geni.us/5SNn Data Slayer: https://geni.us/dataslayer Kaggle - https://www.kaggle.com/ Statista - https://www.statista.com/ Data World - https://data.world/ 📕THE DATA VISUALISATION BIBLE - https://geni.us/iJTa8 🎥 MY YOUTUBE GEAR My Camera - https://amzn.to/3J5lbeo Most Used Lens - https://amzn.to/3hXoE2Q Main Key Light - https://amzn.to/366KaPI Softbox - https://amzn.to/35HrR46 LED Panel Kit - https://amzn.to/35K3Lpf Teleprompter - https://amzn.to/3hWGT8p Main Mic - https://amzn.to/3t1n1aK Lavalier Mic - https://amzn.to/3vVUi8V DISCLAIMER: Some of the above links are affiliate links where I'll earn a small commission if you make a purchase using them, at no additional cost to you. It really helps support the channel so thanks in advance if you do use them 🙏 ✅ LET'S CONNECT! BUSINESS INQUIRIES - https://learnbi.online/contact CONSULTING CALL WITH ADAM - https://geni.us/bookacall-adamfiner JOIN MY MAILING LIST - https://geni.us/PSgRsF FACEBOOK GROUP - https://geni.us/learnbi-fbg nodemcu connecting to sql server #exceltutorial #indexandmatch #businessintelligence