Using Excel's XLOOKUP Function

Рет қаралды 94,471

Technology for Teachers and Students

Күн бұрын

Learn how to use the fairly new and fantastic XLOOKUP function in Microsoft Excel. XLOOKUP replaces the VLOOKUP and HLOOKUP functions and can help you quickly search a huge spreadsheet based upon information you have and it will find and return information that you're looking for. This is a powerful function that will become more and more important as it effectively replaces the older lookup functions. Watch my entire playlist of Excel tutorials: bit.ly/tech4excel
***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's the practice file for this video (copy/paste it into browser): bit.ly/excelxlookup
#exceltutorial #excel #xlookup

Пікірлер: 60

@Ro-bx6ss 2 жыл бұрын

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 2 жыл бұрын

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

@Jalyauba 2 жыл бұрын

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.

@sophia.lemos98 3 жыл бұрын

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 3 жыл бұрын

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

@godwinuche4669 2 жыл бұрын

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

@lorata966 3 жыл бұрын

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

@peekaboo5709 2 жыл бұрын

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.

@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.

@bikramjit1755 3 жыл бұрын

What an amazing teacher you are!

@heliatabbakhshabani6745 Жыл бұрын

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

@marylim1494 2 жыл бұрын

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

@amolpathak199 2 жыл бұрын

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

@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.

@MrJlaryea 3 жыл бұрын

You are awesome teacher. Well explained

@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

@amalianita2286 2 жыл бұрын

Explained so well

@nestortoto8587 Жыл бұрын

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

@fredghusby8058 3 жыл бұрын

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 2 жыл бұрын

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

@lanah7157 Жыл бұрын

Thanks so much..this is absolutely awesome explanation

@livinginlalaville 2 жыл бұрын

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

@danishkkhan Жыл бұрын

Its really good, great explanation.

@knemacomeling2375 3 жыл бұрын

Your videos are really life saver :)

@leiporras4910 2 жыл бұрын

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

@subramanyaba9297 5 ай бұрын

Dear sir, good teaching

@sivakumaranvasantharajan 2 жыл бұрын

Helpful and thanks

@nadinewalker9375 3 жыл бұрын

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!

@hagostareke-wc8yv 4 ай бұрын

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

@techteachersandstudents 4 ай бұрын

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

@kevinsloan5805 3 жыл бұрын

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 2 жыл бұрын

Thank you man

@jerkin6959 Жыл бұрын

Good teacher👍🏻👍🏻👍🏻👍🏻

@hagostareke-wc8yv 4 ай бұрын

Thank you

@tonytaf107 2 жыл бұрын

Awesome 👌🏼

@angelicazhuzhang6140 Жыл бұрын

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

@skip031890 Жыл бұрын

I love xlookup

@ubaidillahmuhammad20 3 жыл бұрын

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

@enriquereyes8130 2 жыл бұрын

So cool

@MashMash-xw5dg Жыл бұрын

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

@MD-pb5ll 2 жыл бұрын

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

@BasicsCorner 3 жыл бұрын

Wow, thats actually so much easier

@garylillich 2 жыл бұрын

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?

@murarithakur3377 3 жыл бұрын

Does xlookup also replace index match ?

@PJMcInerney Жыл бұрын

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

@kayoo99 2 жыл бұрын

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

@shengeliatamuna 2 жыл бұрын

Does XLOOCUP function not work in excel 2019?

@PJMcInerney Жыл бұрын

think it should - it was released in 2019

@funnyclips2696 2 жыл бұрын

Xcelent

@Vrushali2020 2 жыл бұрын

Not able to apply formula 😔

@norbertharisch 3 жыл бұрын

It's a computer voice, right?

@user-os1qj4mr3l Жыл бұрын

The text is not clear at all !

@baigazymamasher3056 2 жыл бұрын

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.

@irenekimvlogs 2 жыл бұрын

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