Take my Full Excel for Data Analytics Course! https://www.analystbuilder.com/courses/excel-for-data-analytics

Excel is one of the most used skills in the data world. In this series we will be walking through all of the most important topics that Data Analysts need to know in order to be proficient in Excel.

Excel XLOOKUP Template: https://bit.ly/314BWFV

Microsoft XLOOKUP Documentation: https://bit.ly/3mF3dGx

Udemy Excel Courses:
Pivot Tables in Excel: https://bit.ly/3peELgG
Visualizations and Charts in Excel: https://bit.ly/30MU9HT
All Excel Essentials: https://bit.ly/3Fdk6iG

____________________________________________

SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________

RESOURCES:

Coursera Courses:
Google Data Analyst Certification: https://coursera.pxf.io/5bBd62
Data Analysis with Python - https://coursera.pxf.io/BXY3Wy
IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR
Tableau Data Visualization - https://coursera.pxf.io/MXYqaN

Udemy Courses:
Python for Data Analysis and Visualization- https://bit.ly/3hhX4LX
Statistics for Data Science - https://bit.ly/37jqDbq
SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij
Tableau A-Z - http://bit.ly/385lYvN

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________

SUPPORT MY CHANNEL - PATREON/MERCH

Patreon Page - https://www.patreon.com/AlexTheAnalyst

Alex The Analyst Shop - https://teespring.com/stores/alex-the-analyst-shop

____________________________________________

Websites:
GitHub: https://github.com/AlexTheAnalyst
Instagram: @Alex_The_Analyst
____________________________________________

0:00 Intro
0:59 XLOOKUP Overview
4:14 XLOOKUP w Multiple Rows
6:16 XLOOKUP Exact Match
9:29 XLOOKUP Search Order
12:12 XLOOKUP Horizontal Search
12:55 XLOOKUP w SUM()
14:51 XLOOKUP vs VLOOKUP


*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*