Data Analyst Explains When to Use VLOOKUP vs XLOOKUP vs INDEX MATCH

Get access to my exclusive content by joining my mailing list ➡ https://mochen.info/

Support me on Patreon ➡   / mo_chen  

Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau, Power BI and Python ➡    • Data Analysis Portfolio Projects  


┋Community & Socials┋

  / discord   ⬅ Join our Discord Data Community

  / mo_chen1   ⬅ My IG is personal -- only follow if you're interested in non-data stuff as well

  / mo-chen1   ⬅ Daily tips & advice on how to enhance your data analysis skills

  / mo_chen_1   ⬅ Figuring out what I want to do in this space...


┋Professional Certificates┋

CourseCareers ➡ https://coursecareers.com/a/mochen

DataCamp Courses & Certifications ➡ https://datacamp.pxf.io/c/4216860/111...

Google Data Analytics Professional Certificate ➡ https://www.coursera.org/google-certi...

Google Advanced Data Analytics Professional Certificate ➡ https://www.coursera.org/google-certi...

Tableau Business Intelligence Professional Certificate ➡ https://imp.i384100.net/TableauBIAnalyst

Microsoft Power BI Data Analyst Professional Certificate ➡ https://www.coursera.org/professional...

IBM Data Science Professional Certificate ➡ https://imp.i384100.net/IBMdataScience

Google Project Management Professional Certificate ➡ https://imp.i384100.net/GoogleProject...


┋Timestamps┋

00:00 Intro
00:41 VLOOKUP
06:19 INDEX MATCH
15:35 XLOOKUP
19:18 Outro