Video není dostupné.
Omlouváme se.
Using Excel's XLOOKUP Function
Vložit
- čas přidán 14. 08. 2024
- 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/excelxlo...
#exceltutorial #excel #xlookup
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!!
Glad it was helpful! Thanks for your kind comments. You've made my day.
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.
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!
Hahaha, exactly the same story, I am an INDIAN though 😂
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
Love how you explain and demonstrate the process of xlookup. Now I can say, I definitely will use this going forward. Thanks for sharing.
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.
agree - this is one of the best x look up videos
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!!
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.
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.
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
... wait 'til you see power query ... ;)
I watched some video to learn Xlookup But I could not understand. But with your explanation, Finally I learned about it. Thank you🌹
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.
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
Absolutely you are good teacher, I have learned more from you. Thank you alot. I have seen most of your vidios.
Glad to hear that. I'm happy you've found my videos to be helpful.
What an amazing teacher you are!
Love it it took me 30 min to understand the formula but I got it thank you 🙏🏽
Explained so well
I love xlookup
Superb, and step by step explanation as always.! Perfect videos for beginners like me.! Keep up the great work sir.! Cheers.
Dear sir, good teaching
You are awesome teacher. Well explained
Thanks so much..this is absolutely awesome explanation
Hi Im new to your channel thank you so much for these video help me a lot.
Its really good, great explanation.
WOW! Game changer!!! Thank you!!!
Thank you
Finally found someone that explains well. I want to cry haha.
Good teacher👍🏻👍🏻👍🏻👍🏻
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!
Great video, i had to first go through some horrible teachers on youtube till i found this one
Your videos are really life saver :)
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!
loved it. please put its file in the description video...
Helpful and thanks
Thank you man
Can the sheet be at the left of the another sheet in a file with multiple sheets? Please advise and thank you,
Wow, thats actually so much easier
Awesome 👌🏼
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?
thanks goodness i never need to learn match and index -)
yep - X look up a lot more straightforward - very occasionally Index match works better
So cool
Does xlookup also replace index match ?
yes it does....but there might be odd occasion when index match works better
Does XLOOCUP function not work in excel 2019?
think it should - it was released in 2019
Xcelent
The text is not clear at all !
Not able to apply formula 😔
I can't see here any differences between xlookup and vlookup
you cannot look to the left with V Look up - X look up a lot more flexible
@@PJMcInerney Exactly right. Xlookup allows you to go in any direction. Vlookup requires your information to be in the furthest column to the left.
It's a computer voice, right?
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.
you probably have older version of Excel - pre 2019