XLOOKUP in Excel | Excel Tutorials for Beginners

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.

Udemy Excel Courses:

____________________________________________

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:

Udemy Courses:

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

SUPPORT MY CHANNEL - PATREON/MERCH

____________________________________________

Websites:
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*

[dinosaur]

Hi Alex! Been following your channel for nearly a year now and your videos helped me land a Junior Marketing Analyst role! It was from your videos where i learnt what skills i needed and how to showcase these skills through a portfolio. Just wanted to say a massive thank you :)

[georgeashton]

I’m soon to be starting my career as a data analyst for a marketing company in the new year and I wholeheartedly want to thank you for making these videos Alex. The information I’ve learnt from watching your channel has been invaluable during the interview process. Looking forward to the rest of the series and keep up the good work!

[frutonica.studio]

This is my SUM XLOOKUP using string manipulation to get substrings from "February - March". Hope this helps some others with same question in the head.

=SUM(XLOOKUP(LEFT(B6, FIND("-", B6)-1), H1:S1, H2:S2):XLOOKUP(RIGHT(B6, LEN(B6)-FIND("-", B6)), H1:S1, H2:S2))

If "N/A" result, remember to check "February" if it has a space at the end.
With basic programming background, to me, learning Excel nowdays is totally different from 20 years ago, LOL.
Btw, thank you for videos, Alex.

[sj]

THANK YOU Alex! I've decided to write a gratitude comment in every one of your videos as an appreciation for everything you've done for all of us as well as offer feedback/thoughts on each video. I liked how you explained how the VLOOKUP function is used in Excel and the benefits of XLOOKUP/comparison to VLOOKUP. I can't believe all the time and energy you've put into this Bootcamp series. You are AWESOME!

[SigmaCollege-ovoi]

00:01 XLOOKUP is a new feature in Excel that replaces VLOOKUP
01:45 Using XLOOKUP in Excel for lookup and return values
03:39 XLOOKUP allows for returning multiple outputs in Excel.
05:47 XLOOKUP in Excel allows for exact match searching
07:52 Using wild card characters in XLOOKUP for flexible searches
09:45 XLOOKUP allows search modes like exact match and next larger value.
11:48 XLOOKUP function in Excel can be used to search for specific values.
13:52 Using XLOOKUP in Excel for searching specific values and adding them
16:01 Using XLOOKUP to search for a value and return specific data
17:53 XLOOKUP in Excel auto updates data from original array selection.

[the_joerne_supremacy]

Not sure if someone else commented on this, but when you copy/paste formulas, you have to be sure the various cells AND ranges are still the ones you want to use. Like when you had to change the A3 to an A4, when you were wanting to lookup Pam Beasley in the first example after you pasted the formula from the Toby Flenderson XLOOKUP. If you look at the lookup_array and return_array in the Pam Beasley formula, those ranges shifted down, and I suspect IRL you want to continue letting the lookup and return start from Row 2. This can be solved by using absolute signs ($) in the cell references, but that might be a separate tutorial. Great videos!

[harshilparmar]

Hey Alex,
Hello from a former Microsoft intern! I really appreciate what you're doing and it would mean a lot to have a further deeper dive concepts in Excel for Data Analyst. Cheers!

[yqhanliving]

I used to use vlookup a lot and this video about xlookup has helped me think better on my solutions. Thanks!

[rociob]

GREAT video, you have a way of teaching a subject that might be difficult to some and put it in the simplest ways for others and myself to learn. Thank you!

[JeffChavez]

On my journey through the boot camp...

Learning XLOOKUP makes me think of issues that I could have resolved easier before with data. Cool!

[nuriddintursunpulat]

Now I get it after watching why there's extra address column on a sample I've downloaded where there isn't at the beginning of video :) Excellent tutorials, thank you shifu Alex!

[lawaltaofeekolumide]

Awesome . I had check out alot of data analysis courses on youtube but your teaching sytle is the best

[aghthu]

I think we should use F4 or add dollar sign ($) to lock the range before double click to automate applying the function for below rows

[andreyblanket]

Hi Alex!
There is a small issue in this video - when you drag the formula, the arrays go wrong. Though it doesn't affect the results in this particular video it might cause some problems in other situation.

I really appreciate what you are doing!
Wish you all the best!

[rokibchi]

Starting This playlist from today, hope I can complete it ASAP.
Thanks Alex for this.

[ChikoriTak]

Thanks Alex for an amazing course!

I have a little comment regarding the formula. I think "$" should be added for a fix range. For example, in tab "XLookUp", the range H2:H10 and P2:P10 should be fixed. Therefore, the formula should be =XLOOKUP(A3;$H$2:$H$10;$P$2:$P$10), and then it can be applied to other below cells.

[gpguri]

Thank you Alex, I am continuously making progress by watching your videos!🙏

[AkporHari]

Still going through these. Great tutorial again.

[monicabn]

Hey Alex,
Learning alot from your videos,
Your simplicity is truly inspiring.❤

[AljIsHere]

Ok I appreciate the breakdown understanding between XLookup and VLookup and how a pain in the azz with the VLookup doing updates can be. Let me go also do another video of the differences to so I can better understand. Thank U for this helpful video!!