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
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
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.
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?
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
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.
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!
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.
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 ??
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 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
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?
👉 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
Always work in tables, never in ranges.
Deep Heartly Gratitude and Love for all your precious time and efforts....
God bless you ❤️🎉
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?
Lewis Hamilton should earn the highest
Kenji is the real GOAT 😊😊❤❤. Thank you for all your videos man,..
I have a dropdown list, and I want each list to return to a specific link. What would the formula be for hyperlink xlookup??
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
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.
I have tried many times and do not know why it's not working in the MULTIPLE ANSWERS scenario.
u made this shit fun, i didnt jnow u could xlookup xlookup
hhaah thank you!
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 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)
How to ignore blank cell reference in xlookup function? (Its returning blank cell value if cell reference and search criteria blank)
Kenji, what if the columns were not named in months? On Vlookup we used column number of the table array.
Thanks for your clear, direct and informative instruction. I have subscribed.
Xlookup gang
Lets go!
I used sumproduct for the last limitations part
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 we use XLOOKUP in Excel tables?
which one is best xlookup or index match?
Yes, I agree. One of the functions I use daily
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
SumIf for me in the last one too.
really helpful to explain this by you kenji
glad it was helpful!
I love how you clearly explain how to apply formulas .....sending love from Kenya
I'm from Tanzania
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.
Nice presentation, Maybe you needed to add that this function is available for Office 365, Excel 2019 and above.
💯/ 💯 brilliant..Bro Kenji💪Dubai
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!
Excellent tutorial. Really appreciate you breaking it down and making it simple. Love the shortcuts
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?
It is something good, but for the Value I do the Data Validation which saves typing time 😉
Wonderful 😍
One request please make video on Three statement model from scratch using assumptions...
coming next week! Stay tuned :)
@@KenjiExplains Thankyou Man 🥺❤️
also works XLOOKUP combined to SUM formula
Love the F1 references
I am wondering what would happen in the Example 2 if there are more people with the same surname?
Wow Kanji you are he goat i will replicate this and tagged you .. take your 🌺🌺🌺🌺🌹🌹
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.
Great thanks so much
I am a beginner, still receiving class. I enjoy watch your videos, very self explanatory
Hello! For each formula I added I received an error #VALUE! Any ideas?
Thanks for mentioning the shortcuts everytime you use them!
Plzzzzz.... Plzzzz..pllzz sir make a video of basic to advance level excel.🙏
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 ?
Great video!!
Glad you enjoyed it
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
You are a good Excel teacher. I understand you easily. Thanks
where are your country ?
Last problem can be solved using sumif 10:15
brilliant. thank you so much Kenji for the tutorial video! love from Malaysia
Hi Kenji, what laptop do you use? thanks
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!
I like this video
Thank you
Thanks for your helpful video!
You are such an amazing tutor.Thankyou so much.I subscribed
We appreciate you, keep on good work
From Nigeria
Very informative. Thanks.
great videos, thank you.
If you can make one video that will be so nice
Pieeeeerre Gaaaslyyyyyyy 😁
Your videos are simply lovely :)
hahahhaa Thank you!
Daniel Ricciardo
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.
You did great Job.. you got one more subc.
Thanks for making such wonderful video.
Sir can U plz make a video of basic excel to advance level. 🙏
formula 1 fan?
ahah glad you noticed
Amazing! I was only familiar with the first formula😂❤
how it works for the last part for text
Nice
Sumif or sum & filter .. both will work
I am in a bootcamp for data analytics and I found this video so helpful
👍
amazing always, very highly appreciated Kenji
Thanks for watching :)
Number 5 was meh
Love the F1 names lol
Hahaha glad you noticed!!
You are amazing man!
Thank you very much.
i didn't get output
Interesting.
Excellent video,,
Super video yet again!!!
Amazing :)
thanks
👍👍☝☝
Sir please speak in hindi
haha i would if i could!
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
Have you employed ex Formula...no pun intended...One drivers?
hahaha love it! glad you noticed & thanks for watching :)
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?