Using Excel's XLOOKUP Function
video description
Date: 2022-04-08
Related videos
Comments and reviews: 9
Fred
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
reply
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
reply
Kevin
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!
reply
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!
reply
Sophia
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!
reply
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!
reply
gary
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?
reply
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?
reply
Peek
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!!
reply
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!!
reply
Mary
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.
reply
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.
reply
Lor'
Love how you explain and demonstrate the process of xlookup. Now I can say, I definitely will use this going forward. Thanks for sharing.
reply
Love how you explain and demonstrate the process of xlookup. Now I can say, I definitely will use this going forward. Thanks for sharing.
reply
Irene
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.
reply
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.
reply
Amol
Superb, and step by step explanation as always.! Perfect videos for beginners like me.! Keep up the great work sir.! Cheers.
reply
Superb, and step by step explanation as always.! Perfect videos for beginners like me.! Keep up the great work sir.! Cheers.
reply
Add a review, comment
Other channel videos
