Using Excel's XLOOKUP Function

[@razor7music]

Finally! XLOOKUP in plain English! Thank you!

[@Ro-bx6ss]

I have never seen a more clear lecture/teaching/demonstration in all the years that I've been in school, from high school to college. You are a true gift to the world and I'm more than grateful to have found your channel. You are awesome!!

[@techteachersandstudents]

Glad it was helpful! Thanks for your kind comments. You've made my day.

[@Jalyauba]

I watched many other videos on xlookup. They went too quickly and I could not follow along. I found your video and was carrying out xlookup minutes later with your fantastic explanation. Thank you taking the time to post this video to help us.

[@godwinuche4669]

Honestly I have like 9 channels I’m following to learn excel but this page stands out for me. This is simply because he doesn’t give one example when explaining I really notice that and I like that about this tutor. I also appreciate how you don’t let us struggle with viewing it clearly. Thanks for not been supersonic when explaining and showing things on the screen. I will share this page on all my social media handle

[@sophia.lemos98]

I have never taken an Excel class before, and I've been binge watching your videos for a while now, and they are real life savers. Plus, I'm Brazilian, so it's also a good way for me to practice my English. Thank you so much!

[@bikramjit1755]

Hahaha, exactly the same story, I am an INDIAN though 😂

[@DinaSmiley20]

As usually- thank you so much for easy explanation of xlook up!!! Great tutor!!!!

[@lorata966]

Love how you explain and demonstrate the process of xlookup. Now I can say, I definitely will use this going forward. Thanks for sharing.

[@GrahamBrook]

Thanks everyone who came to my help

[@michaelguthrie2344]

Used your vid for showing my boss that using Excel Xlookup is the answer. After watching your vid she now agrees. Thankyou for your simple easy to follow method.

[@peekaboo5709]

YOU EXPLAINED IT BETTER!! Super valuable teachings because you explain the excel language - the why the way things are. Your version of teaching is helpful, easy, and digestible learning to the mind. Thank you!!

[@kylestopadfs8514]

A gift from God I found this channel. I’ve been trying to learn how to make my own NBA projections using Excel and you cover almost every base. Thank you.

[@marylim1494]

Thank you so much for this lesson on XLOOKUP. I am new to using EXCEL for complex information. It is so crystal clear and step-by-step for a beginner. Thanks again.

[@PJMcInerney]

agree - this is one of the best x look up videos

[@heliatabbakhshabani6745]

I watched some video to learn Xlookup But I could not understand. But with your explanation, Finally I learned about it. Thank you🌹

[@fredghusby8058]

XLOOOKUP? WOW! For me, who have been in the micro computer business since before CalcStar it is great to see how spreadsheets have evolved. You made it so fast and easy. I understood what you tried to learn us at once! Great job, thanks! Just like the old days when each printer and computer had to be manually combined. Ther were no standards, so we had to use signalsniffers to find out what the pc and printer were talking about. When we've solved that, we could solder the connections. Fast? A day or two, sometimes longer. One was never allowed to finish one job before starting another. People called us specialists. HoHoHoo

[@Not_sculptures]

... wait 'til you see power query ... ;)

[@YTGamerboyPG3D]

Bro thanks i am subbing we have the same thing for schol and not only tht i am sitting in the back so i cant see or hear what my teacher is telling u saved my life

[@nestortoto8587]

Love it it took me 30 min to understand the formula but I got it thank you 🙏🏽

[@skip031890]

I think a big difference in Xlookup that's worth mentioning is the fact that you don't have to include a column or row index number like you do with Vlookup and Hlookup. It's a small change, but very useful.

[@hagostareke-wc8yv]

Absolutely you are good teacher, I have learned more from you. Thank you alot. I have seen most of your vidios.

[@techteachersandstudents]

Glad to hear that. I'm happy you've found my videos to be helpful.

[@amalianita2286]

Explained so well

[@bikramjit1755]

What an amazing teacher you are!

[@amolpathak199]

Superb, and step by step explanation as always.! Perfect videos for beginners like me.! Keep up the great work sir.! Cheers.

[@skip031890]

I love xlookup

[@lanah7157]

Thanks so much..this is absolutely awesome explanation

[@danishkkhan]

Its really good, great explanation.

[@MrJlaryea]

You are awesome teacher. Well explained

[@subramanyaba9297]

Dear sir, good teaching

[@leiporras4910]

Hi Im new to your channel thank you so much for these video help me a lot.

[@MichaelPaskalis]

Thank you. That was helpfull

[@livinginlalaville]

WOW! Game changer!!! Thank you!!!

[@ubaidillahmuhammad20]

loved it. please put its file in the description video...

[@angelicazhuzhang6140]

Finally found someone that explains well. I want to cry haha.

[@nadinewalker9375]

Hi I’m new to your channel. Thanks so much for these videos. I love that they are not long and drawn out, but you get straight to the point. I’m a medical coder and just recently started a new position. This facility works with excel of all the patients they see and my duty is to keep track of the old cases that have not been coded. So I was wondering do you have a video already on your channel where I can pull the unloaded cases for excel and put them in a Word document like a list. I’m not sure if I’m explaining this correctly, but if have a video already can you point me to it or if not can you please make one. Thank you so much for your time!

[@knemacomeling2375]

Your videos are really life saver :)

[@kevinsloan5805]

Great video! Looks like it's the same thing as v/h lookup but you can do it without the exact match requirement, but you can add something instead of adding ifna() at the beginning. Very cool! Other question- do you ever do sponsorships for your videos? I work in the marketing department of an online learning company and I'd love to chat about advertising with you. Thanks!

[@IQMIK11]

Thank you man

[@BasicsCorner]

Wow, thats actually so much easier

[@MashMash-xw5dg]

Great video, i had to first go through some horrible teachers on youtube till i found this one

[@sivakumaranvasantharajan]

Helpful and thanks

[@hagostareke-wc8yv]

Thank you

[@MD-pb5ll]

Can the sheet be at the left of the another sheet in a file with multiple sheets? Please advise and thank you,

[@tonytaf107]

Awesome 👌🏼

[@garylillich]

XLOOKUP should save me a lot of time, since I transfer several columns of data. One challenge, how do we get the fill handle to work on the first formula? In my Office 365, cannot double click to fill the column. Ideas?

[@kayoo99]

thanks goodness i never need to learn match and index -)

[@PJMcInerney]

yep - X look up a lot more straightforward - very occasionally Index match works better

[@enriquereyes8130]

So cool

[@murarithakur3377]

Does xlookup also replace index match ?

[@PJMcInerney]

yes it does....but there might be odd occasion when index match works better

[@shengeliatamuna]

Does XLOOCUP function not work in excel 2019?

[@PJMcInerney]

think it should - it was released in 2019

[@ireneyoomikim]

I don't have the xlookup function on my Excel. I was trying to insert functions and the only thing I have can do is the Vlookup.

[@PJMcInerney]

you probably have older version of Excel - pre 2019

[@baigazymamasher3056]

I can't see here any differences between xlookup and vlookup

[@PJMcInerney]

you cannot look to the left with V Look up - X look up a lot more flexible

[@skip031890]

​@@PJMcInerney Exactly right. Xlookup allows you to go in any direction. Vlookup requires your information to be in the furthest column to the left.

[@norbertharisch]

It's a computer voice, right?

[@Vrushali2020]

Not able to apply formula 😔

[@GrahamBrook]

Sort by higher Arthurty

[@AlDamaghAlDamagh]

The text is not clear at all !

[@GrahamBrook]

No bank account need one

[@funnyclips2696]

Xcelent