MENU

Fun & Interesting

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

Mo Chen 85,306 lượt xem 2 years ago
Video Not Working? Fix It Now

I'M HERE TO HELP YOU LAND YOUR NEXT TECH & DATA JOB
🌐 My website: https://mochen.info/

LET'S COLLABORATE
🤝 Sponsorships & long-term partnerships: https://mo-chen.notion.site/partnerships

ABOUT ME
I'm Mo and I work as a data analytics manager / content creator. I make videos about how best to get your next job in the tech & data space; whether you're a beginner, career switcher, or someone looking to take their tech & data career to the next level.

COURSES & CERTIFICATES
🖥️ Get 25% OFF DataCamp's Courses & Certificates: https://datacamp.pxf.io/DataCampMoChen

INDUSTRY RECOGNIZED CERTIFICATIONS
🧑‍💻 Data Analyst Certification Program: https://datacamp.pxf.io/dataAnalystCertDataCamp
📊 PowerBI Data Analyst Certification Program - https://datacamp.pxf.io/PowerBIDataAnalyst
👩‍💻 Data Scientist Certification Program: https://datacamp.pxf.io/DataScientistCert
💻 SQL Associate Certification Program: https://datacamp.pxf.io/SQLAssociateCert

TOP DATA ANALYST COURSES
📈 Data Analyst with Python: https://datacamp.pxf.io/dataAnalystWithPython
👨‍💻 Data Analyst with PowerBI: https://datacamp.pxf.io/dataAnalystPowerBIMoChen
⌨️ Associate Data Analyst in SQL: https://datacamp.pxf.io/AssociateDataAnalystSQL

TOP DATA SCIENTIST COURSES
🧪 Associate Data Scientist in Python: https://datacamp.pxf.io/AssociateDataScientistPython
🧑‍💻 Associate Data Scientist in R: https://datacamp.pxf.io/AssociateDataScientistR

TOP DATA ENGINEER COURSES
👩‍💻 Data Engineer in Python: https://datacamp.pxf.io/DataEngineerInPython

TOP BUSINESS INTELLIGENCE COURSES
💹 PowerBI Fundamentals: https://datacamp.pxf.io/PowerBIFundamentals
📊 Tableau Fundamentals: https://datacamp.pxf.io/TableauFundamentals

TOP PROGRAMMING LANGUAGE COURSES
💻 Python Fundamentals for Data Science: https://datacamp.pxf.io/PythonFundamentalsDataScience
🧑‍💻 Python Fundamentals for Programming: https://datacamp.pxf.io/PythonFundamentalsProgramming
⌨️ SQL Fundamentals: https://datacamp.pxf.io/SQLFundamentals
🎒 R Programming Fundamentals: https://datacamp.pxf.io/RFundamentals

TOP AI COURSES
🤖 AI Engineer for Developers Course: https://datacamp.pxf.io/AIEngineerDevelopers
🦾 AI Engineer for Data Scientists Course: https://datacamp.pxf.io/AIEngineerDataScientists
🦿 Developing AI Applications Course: https://datacamp.pxf.io/AIApplications

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

Comment