🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ruclips.net/p/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
Bruh. I was just SHOOK by this video. Like where is my data WHERE. I’m dying to login to work tomorrow. Forwards and back... auto results for my #N/As you gotta be SHITTING ME. You are my people. Microsoft is lucky to have you because you’re now my new superhero. God speed.
Great tutorial, simple and clear. Initially watched in full, went away and created my own data set, then worked along side whilst watching the video again and it worked. Many thanks.
Thank you, Kevin! You are so generous with your information and knowledge of Excel and you explain instructions very well. Please keep it coming. Thanks again!
@@KevinStratvert Hey Kevin, great video. Just wondering if you've ever heard of the BetterLookup add-in? It's like VLOOKUP, HLOOKUP, and XLOOKUP but allows for multiple search criteria and it returns multiple values. You should review it. I bet they would even give you a free version if you contacted them and did a video.
Thank you Kevin. We use spreadsheets all the time at work. Our accounting system is an old database style, so the information is usually raw data dump and then we use Excel to define the data. My supervisor is the one that has to create the XLOOKUP tables because, until today, I didn't quite understand how they were done. You have just turned on the "Light Bulb" in my head. Simple but very effective! Thank You!!!!
Kevin you are amazing - I wish I’d found you earlier in my career, I’ve learnt so much from you during lockdown. Keep the videos coming. Love to see one which helps you to build a performance dashboard please 👍
This is a great video. I love all the illustration and creativity that you performed with this Excel function. Please keep it up. Thank you so much for this brilliant presentation.
Thank you for sharing. Easy to understand a fairly complex function. Now it replaces VLOOKUP and HLOOKUP. I have found VLOOKUP to be a very essential function for years. But I am curious, should a beginner learn VLOOKUP before XLOOKUP, or bypass it?
Kevin. Just watched your video. Great stuff, nice cadence with clear speaking. One request, can you please make your data/screen bigger. A bit small to read you data. Thx again
Kevin, you should teach courses on Udemy about Excel, ppt, windows power user bcoz you have the ability to teach diff things in a simple manner... And now after leaving Microsoft, you also have enough time to make a Udemy course.... Love your tutorials always!!!
I would much rather Kevin teach here on RUclips than a pay site like Udemy. Why would I want to pay Udemy when I can watch the tutorials here on RUclips for free?
that was just amazing. So informative about the intricacies of xlookup. Could you comment on becoming and Insider using Beta Channel or Current Channel (Preview)? What does each mean? Are there any risks? I am impatiently awaiting the new check box feature for cells on the insert tab. Thank you so much
what happens if you have more than one depending cells to one input cell, eg. The same student might have more than one majors and on the excel data entry, it might have exact same name corresponds to two different majors. In this case, how do you use Xlookup when you search the student name, It brings up both of the rows and says both of the majors. I hope this all makes sense
Hi Kevin, thank you for the video and I have a question. After applying Xlookup formula successfully to one row I want to replicate the same logic to other corresponding rows, how do I do that?
Thanks for this. Enjoy your videos but they could be better if you remove all the whitespace on the page in post production. It makes it easier to read on tablet or iPad.👍
Hello Kevin, for some simple solutions you are the best . mostly it is helpful in my job also. One interested thing came in my work. I wants to highlylight only few font in a cell based on other cell. for example. if I have 2356 in one cell and at another cell, wants to look ig "2356" is in the cell , if yes, need only "2356" # in TED, not all text or number in the cell, can you make one video, please
Hello Kevin, I think your videos are exceptional, have perused your Playlist link, what would be usefull is if they could be annotated with when the age of the posting (ie: 6 months) etc.
Hi Kevin. Thanks for putting these tutorials together...I have really learned a lot from them. I have heard that the Office products have the ability to save custom colors to the color picker palette but nothing I’ve found online makes sense. I’ve seen people talking about creating new themes but I thought there was a way to do it without a theme. It would be great if you could do a tutorial on that. The downside is that I am still using The 2010 version of Excel, Word, etc...
I was asking myself whether it's possible to use Xlookup in order to find the location of certain values in within a field rage, but I think, I should think of a different method.
Hi! Noobie excel user here. Other than copying and pasting a column/row from one spreadsheet onto another (within the same workbook), how can I import/transfer over that data into a spread sheet with blank fields? Basically, I want to be able to use a sheet as where I enter my raw data (copy and paste from an outside source) and then other sheets automatically organize and calculate the data. Thanks in advance!
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?
Hi, Kevin Thanks for sharing. I tried this personally and it's awesome however can you throw some light in case we have two exactly the same lookup values in data. thanks in advance
Kevin, thanks for your videos, they are helping me a lot in my job. I have 3 different Excel books with similar info (HHRR) but some names could be in one list but not in the other; kindly which function works best to find those differences ?
Hi Kevin Stratver Thanks for all the tutorials and my question is can we use xlookup function to get the only minimum range and maximum range from an array or table?
Is it possible to use xlookup to look for the student's major and then return all of their information on a different tab in the same sheet? For example, I noticed in your example there were several people who had a computer science major. If I wanted to send a list of all the CS majors to a teacher with all of their other information included (not just one value), how would that be done?
I have a user table with first and last names, no badge numbers, and I have another list with first and last names with badge numbers. is there a way for me to look up First+Last names to find badge number?
so the question is as such i have a coloum with names of sports so for instance “cricket” “soccer” “chess” “ice hockey” “car race” they want me to use a function so that it’ll show first four words of the single word sports and for the “ice hockey” and “car race” Itll show “ first three letters of first word and first letter of second word” but they want me to use “if” function for it. The coloum that has the names of the sports (both single word and two words” is labelled “sport” and i have to use “if” function, also they said if they add a new name be it “one word” or “two word” sport, the formula i use should produce the desired result? So for if function how to let the system know that the sports with single words should show first four letters while the ones with two words should show “first words first three letters and second words first letter”
xlookup is not available in excel 2019 pro plus and is only available in excel office 365. in non O365 versions you will have to do with Vlookup and Hlookup.
Not quite true. Without being specific (Kevin works for Microsoft after all), there is (as is often the case) a simple workaround. Got it working on Excel 2019 Pro Plus in about 5 minutes. Use whatever internet search engine that floats your boat to find out how.
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ruclips.net/p/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
Bruh. I was just SHOOK by this video. Like where is my data WHERE. I’m dying to login to work tomorrow. Forwards and back... auto results for my #N/As you gotta be SHITTING ME.
You are my people. Microsoft is lucky to have you because you’re now my new superhero. God speed.
Great tutorial, simple and clear. Initially watched in full, went away and created my own data set, then worked along side whilst watching the video again and it worked. Many thanks.
Thanks for this video. Many people do not even realize what a huge analytical tool Excel is.
Not going to lie, I love the XLOOKUP function! Its amazing how your return results can be to the left of what you are looking up!
I work with data all day thank you.
Best Excel tutorial on this function. I've heard about it before - but never thought much about it. Great video Kevin 👍
the formula I need was in min 5:35, thank you for the update!!!!
Great simple and focused explanations (so now after 17 minutes - I fully understand the nexted Xlookup ecample - thank you !
Thank you, Kevin! You are so generous with your information and knowledge of Excel and you explain instructions very well. Please keep it coming. Thanks again!
Thanks for the note :)
@@KevinStratvert Hey Kevin, great video. Just wondering if you've ever heard of the BetterLookup add-in? It's like VLOOKUP, HLOOKUP, and XLOOKUP but allows for multiple search criteria and it returns multiple values. You should review it. I bet they would even give you a free version if you contacted them and did a video.
Thank you Kevin. We use spreadsheets all the time at work. Our accounting system is an old database style, so the information is usually raw data dump and then we use Excel to define the data. My supervisor is the one that has to create the XLOOKUP tables because, until today, I didn't quite understand how they were done. You have just turned on the "Light Bulb" in my head. Simple but very effective! Thank You!!!!
Kevin you are amazing - I wish I’d found you earlier in my career, I’ve learnt so much from you during lockdown. Keep the videos coming. Love to see one which helps you to build a performance dashboard please 👍
This is a great video. I love all the illustration and creativity that you performed with this Excel function. Please keep it up. Thank you so much for this brilliant presentation.
Amazing work Kevin, you have made my data analytical life so ease. Thank you!
I find this video is so much helpful and thank you for your very clear explanation on XLOOKUP.
Thank you, Kevin. Very helpful and easy to follow along.
Kevin u give invaluable pieces of information in A very comprehensible way .Amazing ! Thanks
Incredibly useful and easy to understand video! Thanks, mate!
The nested x-look up is just so fancy!
Very well presented, concise and thorough. It would help if you could zoom in on your worksheets so we can see the entries being made.
Thank you for this amazing lecturer. I Like your warm voice.
Thanks for the note Majdi :)
thanks Kevin this is another way I use on my PC.
Thank you so much. This was really comprehensive & Helpful.
a5ooya kevin stratvert shokran 3al mosa3dah
Thank you for sharing. Easy to understand a fairly complex function.
Now it replaces VLOOKUP and HLOOKUP.
I have found VLOOKUP to be a very essential function for years.
But I am curious, should a beginner learn VLOOKUP before XLOOKUP, or bypass it?
LOVE THIS! A massive time-saving function!
Thanks, Kevin. Very clearly presented.
Kevin. Just watched your video. Great stuff, nice cadence with clear speaking. One request, can you please make your data/screen bigger. A bit small to read you data. Thx again
wonderful videos, easy to follow and to learn from in such short time...kudoo to you
What I'm gonna do is, I'm gonna like this video and subscribe to your channel because I found it very interesting and useful..!
Kevin, you should teach courses on Udemy about Excel, ppt, windows power user bcoz you have the ability to teach diff things in a simple manner...
And now after leaving Microsoft, you also have enough time to make a Udemy course....
Love your tutorials always!!!
I would much rather Kevin teach here on RUclips than a pay site like Udemy. Why would I want to pay Udemy when I can watch the tutorials here on RUclips for free?
very helpful on the data base that i want to develop for our school. thank you
You're simply thee best Kevin! 🙏💯🙌🏼
Hey kevin ! I just shared your video to some users. Thank you for making this here! Biggest fan, This is Jayant
that was just amazing. So informative about the intricacies of xlookup. Could you comment on becoming and Insider using Beta Channel or Current Channel (Preview)? What does each mean? Are there any risks? I am impatiently awaiting the new check box feature for cells on the insert tab.
Thank you so much
Hi Kevin. Your videos are really great. This was a great example but it’s really hard to see because the view is small.
You're great. Have you done a section about macro or excel script. I would love to know.
Very good info.
@Kevin Stratvert Thanks this was very informative, when i think of it xlookup sounds and works better than vlookup.
Highly highly hiiiiiiiiiiighly appreciated for this tutorial !!
loved it... so useful.. i am going show off at work now 😁
Super video! I applauded for ₹40.00 👏
Thanks so much, Jayant! Much appreciated 🙏
Excellent tutorial - thank you.
Dude, you rock! Thanks
Really helpful. Thx!!
what happens if you have more than one depending cells to one input cell, eg. The same student might have more than one majors and on the excel data entry, it might have exact same name corresponds to two different majors. In this case, how do you use Xlookup when you search the student name, It brings up both of the rows and says both of the majors. I hope this all makes sense
It's just an amazing feature thanks Kevin.
Thanks so much Kevin.
Very easy to grasp, great
Thanks a million
Replacement of Index and Match for left lookup values .
Hi Kevin, thank you for the video and I have a question. After applying Xlookup formula successfully to one row I want to replicate the same logic to other corresponding rows, how do I do that?
Thanks for this. Enjoy your videos but they could be better if you remove all the whitespace on the page in post production. It makes it easier to read on tablet or iPad.👍
Amazing! I use Index, match and match for the last function you did, it's pretty similar :)
Hello Kevin, for some simple solutions you are the best . mostly it is helpful in my job also. One interested thing came in my work. I wants to highlylight only few font in a cell based on other cell. for example. if I have 2356 in one cell and at another cell, wants to look ig "2356" is in the cell , if yes, need only "2356" # in TED, not all text or number in the cell, can you make one video, please
I think in the "xlookup nesting" index match combination is also good
Hello Kevin, I think your videos are exceptional, have perused your Playlist link, what would be usefull is if they could be annotated with when the age of the posting (ie: 6 months) etc.
Hi Kevin. Thanks for putting these tutorials together...I have really learned a lot from them. I have heard that the Office products have the ability to save custom colors to the color picker palette but nothing I’ve found online makes sense. I’ve seen people talking about creating new themes but I thought there was a way to do it without a theme. It would be great if you could do a tutorial on that. The downside is that I am still using The 2010 version of Excel, Word, etc...
Hey Kevin the video is awesome. Can you make another one on how to add or enable xlookup on excel please ?? Thank you.
What is the best way to make suggestions to MS for future enhancements or improvements?
Thank you mr ٠
Thank you, I am learning a lot from you. Can you do VLOOKup and Xlookup using larger data?
Thank you so much
I would like to know how to use Xlook up from different sheet
I was asking myself whether it's possible to use Xlookup in order to find the location of certain values in within a field rage, but I think, I should think of a different method.
Thank you so much. Very helpful ! :)
Hi! Noobie excel user here. Other than copying and pasting a column/row from one spreadsheet onto another (within the same workbook), how can I import/transfer over that data into a spread sheet with blank fields? Basically, I want to be able to use a sheet as where I enter my raw data (copy and paste from an outside source) and then other sheets automatically organize and calculate the data. Thanks in advance!
Thank you, Kevin !!
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?
Hi, Kevin Thanks for sharing. I tried this personally and it's awesome however can you throw some light in case we have two exactly the same lookup values in data.
thanks in advance
Kevin, thanks for your videos, they are helping me a lot in my job. I have 3 different Excel books with similar info (HHRR) but some names could be in one list but not in the other; kindly which function works best to find those differences ?
Hi Kevin Stratver
Thanks for all the tutorials
and my question is can we use xlookup function to get the only minimum range and maximum range from an array or table?
Hey Kevin, as much as I liked your video. Can you share which USB mic you use for recording...? result is pretty good.
Is it possible to use xlookup to look for the student's major and then return all of their information on a different tab in the same sheet? For example, I noticed in your example there were several people who had a computer science major. If I wanted to send a list of all the CS majors to a teacher with all of their other information included (not just one value), how would that be done?
Can xlookup return a collated value from multiple sheets? Months across the top, products down the left col, and values in the correct cells?
just amazing
game changer!
Thank you! Do you have a check list where items can be tracked? I would like to be able to track my educational journey for each subject matter?
Subscribed, thank you!
I have a user table with first and last names, no badge numbers, and I have another list with first and last names with badge numbers. is there a way for me to look up First+Last names to find badge number?
Hi, i just want to ask, I don't have Xlook up function and =Sequence formula , how activate or show them up??
so the question is as such i have a coloum with names of sports so for instance “cricket” “soccer” “chess” “ice hockey” “car race” they want me to use a function so that it’ll show first four words of the single word sports and for the “ice hockey” and “car race” Itll show “ first three letters of first word and first letter of second word” but they want me to use “if” function for it. The coloum that has the names of the sports (both single word and two words” is labelled “sport” and i have to use “if” function, also they said if they add a new name be it “one word” or “two word” sport, the formula i use should produce the desired result? So for if function how to let the system
know that the sports with single words should show first four letters while the ones with two words should show “first words first three letters and second words first letter”
Show how to use this on tables where one of the criteria changes column in table
Thank you Kevin. Can XLOOKUP be combined with an IF statement and then perform a calculation? What is the proper syntax? Thank you.
Can you make a video about all Exel errors, because now with combined columns I have an Error reading #Value! and I'm stuck
Hi Kevin ,
can u pls explain how to apply 10% loyalty discount in a very long list , to specific clients of only X company or X only X area
I have used Vlookup for the last 15 years, I will never need to use it again. RIP Vlookup.
Hi Kevin, can Xlookup can be also combine to other function to perform some computation? Thank you and Kudos
xlookup is not available in excel 2019 pro plus and is only available in excel office 365. in non O365 versions you will have to do with Vlookup and Hlookup.
Not quite true. Without being specific (Kevin works for Microsoft after all), there is (as is often the case) a simple workaround. Got it working on Excel 2019 Pro Plus in about 5 minutes. Use whatever internet search engine that floats your boat to find out how.
How can i use XLOOKUP to look up the name column from a product and date drop down boxes, I just can't get it to work
Is there a manual with examples with multiple criteria, and spill
Great stuff thanks
If we not have a space between first name and last name, how we can make this work
Cool vid!
WHATS 3 things Y’all LEARNED IN THIS VIDEO? :)
Nothing
Braeden Harthoorn same lmao😂
Estrella Neie Why we doing this😂
1. i need to slow down and listen. 2. this isn't has hard as I thought. 3. i will save so much time just by doing this formula.
I thought you worked full time at Kevin Cookie Company 😁
How about if you have identical names? How to deal with it in xlookup?
Which version of Office includes this function?
Why cant we use Python Pandas it is much easier to automate as well, do we even need excel for this now?
amazing
Is x looking up same as v lookup ?