Data Analyst Explains When to Use VLOOKUP vs XLOOKUP vs INDEX MATCH
Mo Chen
@mo-chenAbout
Portfolio, Projects, Courses & Certifications: https://mochen.info Sponsorships: https://mo-chen.notion.site/partnerships Hi, I'm Mo! I'm a Data & Analytics Manager. I'm all about turning complex, big data into insights and actions. I am not interested in building yet another dashboard that nobody looks at - I'm interested in solving the most challenging business problems using data.
Latest Posts
Video Description
Courses & Certifications: https://mochen.info Sponsorships: https://mo-chen.notion.site/partnerships Hi! I'm Mo, and I help career switchers transitioning into Data Analytics. I'm a Data & Analytics Manager, and I've been working in the Financial and Banking Data space for 7 years now. 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
Fit at Home: Must-Have Gym Essentials
AI-recommended products based on this video
6-Tube Pedal Resistance Band, Premium Elastic Tension Rope for Full Body Workout, Natural Latex Fitness Bands for Strength Training,Yoga Stretching Slimming Training, Home Gym Exercise Equipment
Butt Trainer, Smart Adjustable Glute Exerciser, Muscle Toning Stimulator, Portable Home Gym Accessory, Fitness Gear, Ideal for Women, Men, Adults, Strength Training, and Body Sculpting
RENRUI Twister Arm Trainer, Chest & Arm Workout Equipment for Men & Women Adjustable 5 Resistance Levels (40-130 lbs), Ergonomic Home Gym Strength Trainer with Anti-Slip Handles & Carry Bag
Soozier 3-in-1 Wooden Plyo Box, Plyometric Jump Box, Anti-Slip Step up Agility Platform with Handle Openings for Home Gym Workout Training, Black
Invincible Fitness Agility Ladder Full Training Equipment Set, Improves Coordination, Speed, Power and Strength, Includes 10 Cones 4 Hooks and 3 Loop Resistance Bands for Outdoor Workout
MetaLife 100% Pure Creatine Monohydrate Powder, Canada-Made, 1000 g (200 Servings) Micronized Powder, For Muscle Growth, Strength & Performance, No Additives, Unflavored, Ideal for Athletes & Fitness Enthusiasts, Third party lab tested, Vegan, Non-GMO, Gluten Free, Soy Free, Clean & Pure, Improved Performance and Recovery for Men and Women
OSBO GradSeason Unisex Matte Kindergarten Graduation Gown Cap Tassel Set 2025
JaGely 3 Pcs Preschool Grade Graduation Set Graduation Cap with 2025 Tassel Graduation Stole Sash with Diploma Certificates Set for Students Supplies Teachers Parents Graduation Gifts, Multicolor
OSBO GradSeason Unisex Matte Adult Graduation Gown Cap Tassel Set 2025
OSBO GradSeason Unisex Matte Kindergarten Graduation Gown Cap Tassel Set 2025
Figure 8 Fitness Resistance Band 3 Pcs, Elastic Rope Stretch Bands for Working Out, Foot, Leg, Arm, Back, Chest, Portable Home Office Training Exercise Stretcher for Yoga Pilates Physical Therapy
6-Tube Pedal Resistance Band, Premium Elastic Tension Rope for Full Body Workout, Natural Latex Fitness Bands for Strength Training,Yoga Stretching Slimming Training, Home Gym Exercise Equipment
KEY2FUN Treadmills for Home, Walking Pad Treadmill, Portable Foldable Treadmill, Lightweight Folding Treadmill with 300 LBS Capacity, 3.0 HP Portable Foldable Walking Pad with LED Display
Treadmill, FOUSAE 5 in 1 Foldable 7.5 MPH Treadmill for Home with App Compatible, 12 Programes, Powerful 2.5 HP Portable Walking Pad with Manual Incline, Magnetic Remote Control Double Operation
TOPUTURE Foldable Walking Pad with Incline, 2 in 1 Folding Under Desk Treadmill for Home/Office, Portable Compact Treadmill with Remote Control, APP & LED Display, 300lbs Capacity
Grandpa Fathers Day Golf Gift for Men Golf Ball Markers Hat Clip Father's Day Birthday Gifts for Grandpa from Grandchildren Funny Magnetic Golfs Accessories for Men Grandfather Retirement Christmas
Garmin Bounce™, Kids Smartwatch, Two-Way Text and Voice Messaging, Location Tracking, Black Camo
