I have always wanted to take an advanced excel/google sheets course. I have used spreadsheets since the old lotus 123 days. I use the count features a lot at work but don't know how yet to group and automate. however. I am learning pivot tables to help me with reports
I would really watch your excel classes for the whole day! You really make the formula so easy to understand and the places where it could be probably used. Thank you so much!
4:55 Very informative! So the inner xlookup returns a column from a group of columns, while the outer xlookup returns a cell from a column (group of cells). 9:14 or return a row from a group of rows.
Seriously you explain things so easily that's faster for me to grasp! Straight to the point, easy and clear examples. You're my go to excel teacher on youtube!
You are the man Kenji. I've worked in accounting for 7 years and consider myself very proficient in excel, however you've taught me so much in the few short videos I've found. New subscriber!
Hi Kenji, This was an excellent refresher of the XLOOKUP function for me. Thanks for all your efforts. 👍 For the Limitation example can we also make use of the FILTER function as mentioned below: =SUM(FILTER($D$3:$D$18,$B$3:$B$18=F3)) Please confirm. Regards, Deepak.
Kenji thank you for your help, I am also wondering how to use the formula for a different output. For example, in your third example, if I wanted to know which employee had 7,392 in sales in February how would I use the formula to populate the name Sergio Perez?
Will xlookup provide non-contiguous rows as output. It was good to know it displays multiple. Thank you for the video. It helps to understand xkoolup basics
Very insightful video and thank you for that. But you mentioned that Xlookup only allows one lookup value. I believe I can add up multiple lookup values by adding the & in the lookup_value section right? But I can also see that it wouldn't work efficiently in this specific example because we have more than one months, so a nested xlookup is better option of course.
@@zmm3492 Xlookup in general replaces Vlookup in many ways, like Vup can't look to the left or look horizontally or it can't give you back multiple answers as shown in the video.
dude, how is it better than the index match? how will you use an xlookup when the source data table and the results table have column headers in different orders?? in that case please tell me how xlookup can solve it.
Hello sir I need some help that by interning only ID Number of an employee so I can get all the information about that employee like Name,last Name,department that he/she work in if can you help me that will be very nice?
Can copilot 365 and other ai tools do all type of works in ms Excel Or is it still important to learn ms Excel deeply all functions and advance formulas ??
Very helpful video! If I had more than one employees with the same name, could I use the wildcard method to find whichever employee I'd want? If not, which method is the most efficient?
Thanks for this impactful teaching. However, I keep getting this error on the last one 5 (#VALUE!). I am using 2019 Excel. don't know if that's the reason for the error. Kindly assist
Why can't I understand this fucking concept in Excel? The more I watch tutorials, the more confusing it gets Could you explain it in a simpler way? For instance, explain why we choose a certain data range for the array, and so on. Provide reason.
Hi, thank you for all your informative videos... i know you're busy, but I do hope you'll get time to reply to my question.. How do i use Xlookup on specific dates and revenue ( weekly summary ) Daily , weekly , week no, and months, can i also use it for expenses
👉 Take our Excel Course: www.careerprinciples.com/courses/excel-for-business-finance
I have always wanted to take an advanced excel/google sheets course. I have used spreadsheets since the old lotus 123 days. I use the count features a lot at work but don't know how yet to group and automate. however. I am learning pivot tables to help me with reports
I would really watch your excel classes for the whole day!
You really make the formula so easy to understand and the places where it could be probably used.
Thank you so much!
4:55 Very informative! So the inner xlookup returns a column from a group of columns, while the outer xlookup returns a cell from a column (group of cells). 9:14 or return a row from a group of rows.
Seriously you explain things so easily that's faster for me to grasp! Straight to the point, easy and clear examples. You're my go to excel teacher on youtube!
I am in a bootcamp for data analytics and I found this video so helpful
I am from India, Kolkata (West Bengal) Learn a lot watching your video. Wow...................
I love how you clearly explain how to apply formulas .....sending love from Kenya
I'm from Tanzania
Kenji is the real GOAT 😊😊❤❤. Thank you for all your videos man,..
Deep Heartly Gratitude and Love for all your precious time and efforts....
God bless you ❤️🎉
You are the man Kenji. I've worked in accounting for 7 years and consider myself very proficient in excel, however you've taught me so much in the few short videos I've found. New subscriber!
Thanks for your clear, direct and informative instruction. I have subscribed.
You are such an amazing tutor.Thankyou so much.I subscribed
Excellent tutorial. Really appreciate you breaking it down and making it simple. Love the shortcuts
Thanks for mentioning the shortcuts everytime you use them!
You are a good Excel teacher. I understand you easily. Thanks
I am a beginner, still receiving class. I enjoy watch your videos, very self explanatory
Yes, I agree. One of the functions I use daily
really helpful to explain this by you kenji
glad it was helpful!
Great video Kenji🎉
You are amazing man!
amazing always, very highly appreciated Kenji
Thanks for watching :)
brilliant. thank you so much Kenji for the tutorial video! love from Malaysia
Hi Kenji,
This was an excellent refresher of the XLOOKUP function for me. Thanks for all your efforts. 👍
For the Limitation example can we also make use of the FILTER function as mentioned below:
=SUM(FILTER($D$3:$D$18,$B$3:$B$18=F3))
Please confirm.
Regards,
Deepak.
We appreciate you, keep on good work
From Nigeria
💯/ 💯 brilliant..Bro Kenji💪Dubai
Thanks for making such wonderful video.
Thanks for your helpful video!
Great video!!
Glad you enjoyed it
I used sumproduct for the last limitations part
Kenji thank you for your help, I am also wondering how to use the formula for a different output. For example, in your third example, if I wanted to know which employee had 7,392 in sales in February how would I use the formula to populate the name Sergio Perez?
You did great Job.. you got one more subc.
Pieeeeerre Gaaaslyyyyyyy 😁
Your videos are simply lovely :)
hahahhaa Thank you!
Daniel Ricciardo
great videos, thank you.
Thanks!
Super video yet again!!!
Cute that you think Verstappen is a difficult last name! Greetings from The Netherlands :)
Love the F1 references
Thank you
Excellent video,,
Great thanks so much
Will xlookup provide non-contiguous rows as output. It was good to know it displays multiple. Thank you for the video. It helps to understand xkoolup basics
Wow Kanji you are he goat i will replicate this and tagged you .. take your 🌺🌺🌺🌺🌹🌹
u made this shit fun, i didnt jnow u could xlookup xlookup
hhaah thank you!
Thank you very much.
Sumif or sum & filter .. both will work
I like this video
Wonderful 😍
One request please make video on Three statement model from scratch using assumptions...
coming next week! Stay tuned :)
@@KenjiExplains Thankyou Man 🥺❤️
Amazing! I was only familiar with the first formula😂❤
Nice presentation, Maybe you needed to add that this function is available for Office 365, Excel 2019 and above.
Last problem can be solved using sumif 10:15
Kenji, what if the columns were not named in months? On Vlookup we used column number of the table array.
It is something good, but for the Value I do the Data Validation which saves typing time 😉
Very insightful video and thank you for that. But you mentioned that Xlookup only allows one lookup value. I believe I can add up multiple lookup values by adding the & in the lookup_value section right? But I can also see that it wouldn't work efficiently in this specific example because we have more than one months, so a nested xlookup is better option of course.
How does this replace vlookup then?
@@zmm3492 Xlookup in general replaces Vlookup in many ways, like Vup can't look to the left or look horizontally or it can't give you back multiple answers as shown in the video.
In Level 3... You looked up one row and one column but is it possible to look up 2 columns and return an array? Please advise.
dude, how is it better than the index match? how will you use an xlookup when the source data table and the results table have column headers in different orders?? in that case please tell me how xlookup can solve it.
I have a dropdown list, and I want each list to return to a specific link. What would the formula be for hyperlink xlookup??
also works XLOOKUP combined to SUM formula
Really helpful and informative, but I have a query : What if we have same first name but different last name, How to apply the formula then?
which one is best xlookup or index match?
Amazing :)
I agree with you with SUMIF.
youtube.com/@markrowley9801
Plzzzzz.... Plzzzz..pllzz sir make a video of basic to advance level excel.🙏
thanks
Hello sir I need some help that by interning only ID Number of an employee so I can get all the information about that employee like Name,last Name,department that he/she work in if can you help me that will be very nice?
Nice
How to ignore blank cell reference in xlookup function? (Its returning blank cell value if cell reference and search criteria blank)
SumIf for me in the last one too.
Hi Kenji, what laptop do you use? thanks
Can copilot 365 and other ai tools do all type of works in ms Excel
Or is it still important to learn ms Excel deeply all functions and advance formulas ??
Sir please ans me
Interesting.
Xlookup gang
Lets go!
Sir can U plz make a video of basic excel to advance level. 🙏
How can I use the Xlookup formula to find information across multiple worksheets (not workbooks)?
That's easy, just select the area on the desired tab. Info doesn't all need to be on the same sheet.
I am wondering what would happen in the Example 2 if there are more people with the same surname?
hi i am having a issue i am selling some item for someone but i will like to see what from the sale is mine and what is his how do i work that out ?
Hello! For each formula I added I received an error #VALUE! Any ideas?
If you can make one video that will be so nice
how it works for the last part for text
Very helpful video! If I had more than one employees with the same name, could I use the wildcard method to find whichever employee I'd want? If not, which method is the most efficient?
Can we use XLOOKUP in Excel tables?
i am been frustrated with with #NAME? error. i followed your steps but still ends up pop up the error. Xlookup( xlookup value,array, return value)
Love the F1 names lol
Hahaha glad you noticed!!
I have tried many times and do not know why it's not working in the MULTIPLE ANSWERS scenario.
Thanks for this impactful teaching. However, I keep getting this error on the last one 5 (#VALUE!).
I am using 2019 Excel. don't know if that's the reason for the error. Kindly assist
Always work in tables, never in ranges.
where are your country ?
Lewis Hamilton should earn the highest
i didn't get output
You're using vertical arrays, but can't undersatnd how to use the function in horizontal arrays...
👍
formula 1 fan?
ahah glad you noticed
Number 5 was meh
👍👍☝☝
Sir please speak in hindi
haha i would if i could!
Why can't I understand this fucking concept in Excel? The more I watch tutorials, the more confusing it gets
Could you explain it in a simpler way? For instance, explain why we choose a certain data range for the array, and so on. Provide reason.
Have you employed ex Formula...no pun intended...One drivers?
hahaha love it! glad you noticed & thanks for watching :)
Hi, thank you for all your informative videos... i know you're busy, but I do hope you'll get time to reply to my question..
How do i use Xlookup on specific dates and revenue
( weekly summary )
Daily , weekly , week no, and months, can i also use it for expenses
Very informative. Thanks.