Using Excel's XLOOKUP Function

Подписаться 1,5 млн

Просмотров 92 тыс.

50% 1

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

Хобби

Опубликовано:

26 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 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 😂

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

@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

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

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

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

@bikramjit1755 3 года назад

What an amazing teacher you are!

@skip031890 Год назад

I love xlookup

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

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

@amolpathak199 2 года назад

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

@amalianita2286 2 года назад

Explained so well

@MrJlaryea 2 года назад

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

@livinginlalaville 2 года назад

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

@nestortoto8587 Год назад

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

@lanah7157 Год назад

Thanks so much..this is absolutely awesome explanation

@danishkkhan Год назад

Its really good, great explanation.

@knemacomeling2375 2 года назад

Your videos are really life saver :)

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

@sivakumaranvasantharajan 2 года назад

Helpful and thanks

@hagostareke-wc8yv 2 месяца назад

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

@techteachersandstudents 2 месяца назад

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

@leiporras4910 Год назад

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

@subramanyaba9297 4 месяца назад

Dear sir, good teaching

@IQMIK11 2 года назад

Thank you man

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

@jerkin6959 Год назад

Good teacher👍🏻👍🏻👍🏻👍🏻

@hagostareke-wc8yv 2 месяца назад

Thank you

@ubaidillahmuhammad20 3 года назад

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

@tonytaf107 2 года назад

Awesome 👌🏼

@angelicazhuzhang6140 Год назад

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

@enriquereyes8130 2 года назад

So cool

@MashMash-xw5dg Год назад

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

@BasicsCorner 3 года назад

Wow, thats actually so much easier

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

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