How To JOIN DATA In Excel Using INDEX MATCH Functions

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: • How To Join Data In SQ...
00:00 Intro
00:35 INDEX & MATCH
03:44 Multiple Criteria
START YOUR BI JOURNEY! - learnbi.online
🎥 RECOMMENDED VIEWING
7 Steps to Your 1st BI Analyst Job - geni.us/7stepstobivid
Learn Basic SQL in 15 Minutes - geni.us/learnbasicsql15-1
BI For Beginners Playlist - geni.us/biforbeginners-play
🎓 RECOMMENDED COURSES
Power BI For Business Intelligence - geni.us/powerbi-udemy
Ultimate Guide to Google Data Studio - geni.us/vbi-edu
Google Data Analytics Course - geni.us/coursera_analytics
Learn SQL - geni.us/learnsql
SKILLSHARE - 30-day free trial! - geni.us/skillshare30day
UDEMY - geni.us/udemy_vb
📕 FREE EBOOKS
7 Top Tips For Better Dashboard Design - geni.us/dashdes-ebook
Skills You Need To Succeed In BI - geni.us/biskills-ebook
🧰 BI TOOLS
Power BI - powerbi.microsoft.com/
Tableau - www.tableau.com/
Data Studio - datastudio.google.com/
📊 DATA HUBS & WEBSITES:
Power My Analytics: geni.us/YLc9Re
Supermetrics: geni.us/5SNn
Data Slayer: geni.us/dataslayer
Kaggle - www.kaggle.com/
Statista - www.statista.com/
Data World - data.world/
📕THE DATA VISUALISATION BIBLE - geni.us/iJTa8
🎥 MY KZbin GEAR
My Camera - amzn.to/3J5lbeo
Most Used Lens - amzn.to/3hXoE2Q
Main Key Light - amzn.to/366KaPI
Softbox - amzn.to/35HrR46
LED Panel Kit - amzn.to/35K3Lpf
Teleprompter - amzn.to/3hWGT8p
Main Mic - amzn.to/3t1n1aK
Lavalier Mic - 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 - learnbi.online/contact
CONSULTING CALL WITH ADAM - geni.us/bookacall-adamfiner
JOIN MY MAILING LIST - geni.us/PSgRsF
FACEBOOK GROUP - geni.us/learnbi-fbg
nodemcu connecting to sql server
#exceltutorial #indexandmatch #businessintelligence

[@LearnBI]

⬇️ START YOU BI JOURNEY HERE ⬇️ 🔥 GET THE ULTIMATE GUIDE TO GOOGLE DATA STUDIO 🔥 HEAD ON OVER TO geni.us/datastudiocourse

[@TheUnsubScribe]

This is one of the only channels we watch where we don’t skip the ads, just to support. 👏😇👍 What fantastic content, good sir!!!

[@LearnBI]

Thank you kind Sir, really appreciate it 🙏

[@abidbhatti3002]

Thank you so much for posting this from data perspective. I've had to watch so many videos from others before finding your video which addresses the exact issue that I was trying to resolve.

[@LearnBI]

You're welcome, glad it helped

[@asciicatface]

thank you so much, you have definitely saved my bacon

[@LearnBI]

You’re welcome. It was a bacon worth saving!

[@smsfasfafd-nz9hv]

what about when i delete the fields that arent needed anymore? the section i need gets deleted cause of the coding. Can you help with this? i need to upload it but i now have 2 extra columns.

[@LearnBI]

You need to copy and paste special > values the columns where you have your formulas

[@ubaidillahmuhammad20]

nice job. please put its excel file in the description ... Thanks

[@LearnBI]

Sure, no problem. Just click this link... mailchi.mp/vitaminbi/indexmatch

[@ubaidillahmuhammad20]

And for other excel file?

[@LearnBI]

@@ubaidillahmuhammad20 Everything you need should be in there

[@ubaidillahmuhammad20]

None

[@pew2pao459]

Xlookup would be easier to use

[@LearnBI]

As they say, there’s more than 1 way to skin a cat. Thanks for your input 👍🏻