Want to master functions needed for data analysis? Learn them step-by-step in this course 👉 www.xelplus.com/course/excel-dynamic-array-365-formulas/ Download the file I used in the video here: pages.xelplus.com/xlookup-file
Hi Leila, I am using Excel in Office 365 but XLOOKUP function is not available on my pc. Do you have any idea why it isn't available. I will also write to Microsoft Support
Thomas St. Martin I checked if there are any updates but it says it’s up to date. Maybe they are distributing region by region. I am located in Turkey.
I've been following and watching your videos for about two years. I'm a hardcore data analyst, I mean python, SQL, R guy. Had a job interview today and it was mostly excel based. Took a refresher with some of your videos and it saved me a lot. Thanks Leila.
Excellent video Leila! I just watched a couple of other videos on this topic done by other RUclipsrs and I was left in a cloud of confusion! I am not an excel guru but I need to get better at it. What makes your videos stand out is that you use real-world examples. I like the fact that most of your videos are under 20 minutes. If I forget how to do something I just watch the video again. I already have a few ideas on how to use XLOOKUP. Keep doing what you are doing, Leila! Thanks so much!
Leila I've bought your courses, because you explain things more clearly than anyone and the editing must take more time, but makes things so clear. You are my favourite Excel teacher by far. Thanks for all the value you provide. Really helps with my job.
Always used to use index match match for these sorts of problems. Nice to see that Microsoft have included the concept as a single straight forward function rather than the clever trick that it was before.
Simply amazing and so well explained. I’m a self taught excel user, been using it for over 25 years. Always used Vlookup, for so many things, but turned to xlookup maybe a year ago and have been loving it since, but using only its most basic form. These tips will come in handy, thanks!!
I'm taking your vba courses on udemy. I've taken so many data analytics related courses taught by industry experts and you are the best teacher. Your style is always so clear and concise. Thank you!
For a chemical engineer who imports massive tabulated data into Excel and calculates properties based on MULTIPLE PARAMETERS, XLOOKUP is gold and time-saving! Thank you for sharing your knowledge with us. You've earned a subscriber :)
Awesome. I have been using vlookup for a long time... This will greatly help the NA problem. Typeing if(NOT(ISERROR(VLOOKUP(...))),vlookup(...), default_value) has been my solution in the past... XLOOKUPs answer is so much better.
Thank you, your videos are are always well structured, professional, high value and very useful. It takes knowledge, effort and passion to achieve this level of "perfection".
I know this video is a few years old now, but the explanation for the 2-way lookup saved me today. I'm putting together a table, that calculates freight prices, based on the amount of pallets/ load carriers and the consignee's postal code. Thank you!
Looks like they’ve fixed vlookup’s fatal flaws, especially the fixed column number reference which made the function unusable and had everyone replace it with index(match). Well done.
Thank you so much! This is is the video that I didn't know I needed to see today! I had spent the better part of my day trying to create a nested formula that exceeded the 64 entries allowed. I was trying to figure out how to do what I needed using VLOOKUP when I stumbled across your video and followed your instructions and got my formula to work and return the data that I needed. Your instructions and explanation were so easy to follow. Again, thank you! You saved me a lot of time!
@@LeilaGharani It's VERY RARE that I hear anyone on RUclips as good as you are. You never make a verbal mistake; never pause to figure out what to say; never say ah, um, or utter any filler words. Every phrase you speak moves the narrative forward. I think you're the best that I've ever seen (heard). I stand in awe. :-)
Thanks Leila. I have always used index-match combinations for dynamics lookups. When I purchase an office 365 subscription, I was excited about xlookup, but wasn't quite sure how to make it dynamic as we could do with index-match. The 4th example where you used nested xlookup addresses the issue.
You shouldn’t use Xlookup if you’re planning on sharing the spreadsheet with colleagues or clients. It’s functionality only works on updated versions of excel and won’t work on old versions of excel.
Similar as to what Yman states - but first save a copy of your file under different file name so you can keep your formula version for yourself, then Copy -> Paste Values... a good habit to do in general because the chances of the person you are sending the file on to, knowing how to manage formulae let alone filtering and who knows what type of manipulations, better rule of thumb to keep a working file for yourself for later and provide a simple output to anyone downstream, unless the aim is to have them adjust values incorporated in the formula.
At Last - Been waiting for the 'IF not Found' parameter for years. All I've got to wait for now is for all of my client PC to get this version of excel....
Thank you so much for your videos! I was very lucky to found your channel! My native language is spanish, and I can understand almost every word you say. Thank you!
@Leila your videos are consistently the most helpful and easiest to follow. Every now and again, I click on someone else's video for help but I almost always come back and end up finding what I need from yours. Thank you for all of your posts, they are truly helpful! --Joe
THANK YOU! I love your presentation style - just right for my knowledge of excel! I just learned about XLookup and my goal this morning was to learn how to use it. You started my day with a win!
fun tip with xlookup a dummy like me just found: you can actually set multiple lookup arrays for a single lookup value without using iferror because you already have the "if not found" scenario in xlookup. here's how it goes: =xlookup(lookup value, [1st] lookup array, [1st] return array, [1st if not found case] xlookup(lookup value, [2nd] lookup array, [2nd] return array, [2nd if not found case] xlookup( lookup value, [3rd] lookup array... and so on and on... it works fine you can try it. i thought it would be useful to share this.
Loved it. Ok. the video is three years old and I am watching it now. In repeatng your steps, I included an offset to get the names of the employees sorted.
Life changing! How did I not know this?? Have already shared with other colleagues and they had not heard of Xlookup either. Super excited about using this new formula and the video was excellent, thank you so much Leila!!
Earlier I use to stick to some set of formulas and do all my analysis based on those results.. lucky me randomly saw your video once (I don’t remember what was the first video I saw), impressed with the way you explain details about each argument made me to view more of your videos.. then made me to subscribe your channel.. I honestly thank you for sharing all these on RUclips for free and educating many.. I strongly believe your videos helps lot of professionals to solve many of their issues with an ease.. you are unique of your kind.. wish you all the best.. my heart full thanks to you..🤝💐
Thank you, I have been using LOOKUP with IF statements and have issues when I sort. My work has finally updated from EXCELL 2007 and I thought I should see what's new.. These are the best tutorials I have found. Thanks for teaching this old dog new tricks.
Leila, I subscribe and follow very few people however the amount of information and practical knowledge you provide is incredible. You are my immediate go to whenever I am looking to simplify my excel programs. Thank you.
Also, I solved this XLookup&Xlookup formula with using Xlookup&Choose&Match formula. It returns same result as follows: =XLOOKUP($G$3;A3:A20;CHOOSE(MATCH(G4;B2:D2;0);B3:B20;C3:C20;D3:D20)) Fantastic!!
Maybe old tip but new one for me, so I'm sharing gladly: with the amazing xlookup I just discovered with this video, you can JOIN TOGETHER two search arrays (let's say name column and surname column: XLOOKUP(A1;B1:B10&C1:C10;D1:D10)) to match with the searched value (that can also be formed by adjoining two values/cells as showed in the video with wildcards). Amazing time saver!
I do some professional development every Friday and have subscribed to your channel as an integral part of that. Your format is great. Concise, easy to follow, and very informative.
I was going to change a excel i use at fork, to be more automated and just found this vid, it will make it a lot easier for me. Funny thing is that actually I can use all of the examples in different areas of the excel! Can't wait to update the sheet now;). Thanks
I started a job that required me to give reports, data collection and stuff of that nature. I had zero experience with excel and thanks to your in-depth tutorials I have excelled (no pun intended) in this position thank you so much for what you do.
Totally new to me! Having never seen a video of someone showing Excel tips I have to let the geek in me out and say, wow. It was a pleasure. From all my years facing people who use Excel as digital paper, not as the tool it has potential to be, I simply loved watching someone know what they are doing. Weirdly attractive :D Guess I learned something new about myself as well as Excel :D
I never used XLOOKUP before but thank you for this. It's easier than VLOOKUP since you don't have to arrange everything to the right of your array. Thank you!
So I have an excel exam of three hours in an upcoming interview, and have no idea what curve ball they will throw at me, not to mention what can you test for three hours, so I am going through all formulas, learning power query, and piovot table. Your video by far the most coherent and so well made. I always though that excel is to much formulas and very hard to learn, but I am enjoying it very much. I subscribed. Maybe you can do some video on interview exams, and what and how the exams go. Thank you so much, I will continue learning regardles of if I get the job or not
Hi Anna. Wow! 3 hours! I've never heard of that. Could you share some of the questions they asked you at the interview? Also for what position you are interviewing for? I'm really curious. You can find my email in the "about" page or on xelplus.com. We could made a video about common questions to help others out. Wish you all the best for your interview.
@@LeilaGharani hi! Thank you so much for responding, I also am curious to what they might give for such a long exam. So the position is technical succsses manager in "datarails" and the company basically helps users with their excel, to make it more assemble the data. So it does make sense they want to test excel....but to what extend? If I may, I would love to ask u if u have some example sheets I can practice on, I would really appreciate it. And ofcourse after the exam, I will make sure to send u the excel sheet they sent me. Anna.bartenev@gmail.com (if it's relevant for excel sheets)
Thank you for the video. Well presented and using good examples. For those who are wondering about performance, the news is not good. XLOOKUP is really slow, likely slower than the old V/H-LOOKUP versions as it does more checks. I tested it on a little dataset (~150 rows of data) where I have a macro that runs the "TRIM" command on a given column that's used by the XLOOKUP function in another column. It takes about 35 seconds to run. When I replace the XLOOKUP with a index-match version, it runs in about 7 seconds...
@@kajet666 Nope, but to be fair, it's not really slower than the old VLOOKUP, just still much slower than a index-match version of the code, even with additional code to emulate the new options that come with XLOOKUP
@@sbom so I guess your macro has xlookup run through the 150 rows many, many times - wonder what the performance will be with a larger (5000 rows, say) dataset but no VBA.
@@kajet666 Actually in this case the macro only goes through the cells and runs the TRIM command to remove spaces at the beginning/end of each, but Excel recalculates the results of those other cells which have the XLOOKUP command, which is the time-consuming step, not the macro code itself. I'm sure there's a way to tell Excel to stop recalculating until the macro has finished removing all the spaces, and only update once, but my point for the test was to show that the performance of the XLOOKUP is not good, as that'll be an issue as you mention for large datasets with thousands of entries.
Want to master functions needed for data analysis? Learn them step-by-step in this course 👉 www.xelplus.com/course/excel-dynamic-array-365-formulas/
Download the file I used in the video here: pages.xelplus.com/xlookup-file
Hi Leila, I am using Excel in Office 365 but XLOOKUP function is not available on my pc. Do you have any idea why it isn't available. I will also write to Microsoft Support
@@dicelloHi Koray, you have to be an
office insider user to use it.
Nader Azzam Thank you, I will have to wait for the public release than
Koray Aydın I thought this was a public release as of last month. Just make sure your software is fully updated.
Thomas St. Martin I checked if there are any updates but it says it’s up to date. Maybe they are distributing region by region. I am located in Turkey.
I've been following and watching your videos for about two years. I'm a hardcore data analyst, I mean python, SQL, R guy. Had a job interview today and it was mostly excel based. Took a refresher with some of your videos and it saved me a lot. Thanks Leila.
and you learnt SQL & R from? how do we practice that? em actually starter in R
Dude i dont think leila is a real person. Ur crying ur heart out to a bot right now.
Hehe
@@kmlumd44lol
God bless
Leila, there is no comparison to how simple you make things for your audience to understand when it comes to anything in excel. Hats off!
Leila is a bot, man. We'll have her program u in a response on her next iteration
probably because a man wrote it for her. Looks like she's just reading a script.
Why am I watching this at 9:30 at night and getting super excited at how much easier this will make my life!
I’m watching it at 3:45am and having the same reaction. ☺️😞
Same here 01:06 and I have small kid's too
I should really try to sleep!
11:15pm here
Me at 10:11 pm now 10:12
Me at 10:45 pm lol
Excellent video Leila! I just watched a couple of other videos on this topic done by other RUclipsrs and I was left in a cloud of confusion! I am not an excel guru but I need to get better at it. What makes your videos stand out is that you use real-world examples. I like the fact that most of your videos are under 20 minutes. If I forget how to do something I just watch the video again. I already have a few ideas on how to use XLOOKUP. Keep doing what you are doing, Leila! Thanks so much!
Leila I've bought your courses, because you explain things more clearly than anyone and the editing must take more time, but makes things so clear. You are my favourite Excel teacher by far. Thanks for all the value you provide. Really helps with my job.
I agree. Her clear explainations/teaching save me heaps of work!
thank you so much for the well explanations you provided
Always used to use index match match for these sorts of problems. Nice to see that Microsoft have included the concept as a single straight forward function rather than the clever trick that it was before.
Simply amazing and so well explained. I’m a self taught excel user, been using it for over 25 years. Always used Vlookup, for so many things, but turned to xlookup maybe a year ago and have been loving it since, but using only its most basic form. These tips will come in handy, thanks!!
Thanks for helping me with work 👍
Thank you! Glad the tips are helpful.
I'm taking your vba courses on udemy. I've taken so many data analytics related courses taught by industry experts and you are the best teacher. Your style is always so clear and concise. Thank you!
For a chemical engineer who imports massive tabulated data into Excel and calculates properties based on MULTIPLE PARAMETERS, XLOOKUP is gold and time-saving! Thank you for sharing your knowledge with us. You've earned a subscriber :)
Who else is learning Xlookup at 3:00 AM 😂😂😂😂
Literally me 😂
Fr.
Me 😂😂😭
At 1.30am maybe
4.43 AM 😂🎉
Awesome. I have been using vlookup for a long time... This will greatly help the NA problem.
Typeing if(NOT(ISERROR(VLOOKUP(...))),vlookup(...), default_value) has been my solution in the past... XLOOKUPs answer is so much better.
Thank you, your videos are are always well structured, professional, high value and very useful. It takes knowledge, effort and passion to achieve this level of "perfection".
Thanks for the XLOOKUP magic, Teammate Leila : )
Love both of your channels
She's married bro
I know this video is a few years old now, but the explanation for the 2-way lookup saved me today. I'm putting together a table, that calculates freight prices, based on the amount of pallets/ load carriers and the consignee's postal code. Thank you!
Looks like they’ve fixed vlookup’s fatal flaws, especially the fixed column number reference which made the function unusable and had everyone replace it with index(match). Well done.
👍
You can use a match for the column number so it is just as dynamic.
Thank you so much! This is is the video that I didn't know I needed to see today! I had spent the better part of my day trying to create a nested formula that exceeded the 64 entries allowed. I was trying to figure out how to do what I needed using VLOOKUP when I stumbled across your video and followed your instructions and got my formula to work and return the data that I needed. Your instructions and explanation were so easy to follow. Again, thank you! You saved me a lot of time!
Your teaching is amazing...I have started your excel dashboard course on udemy....And I am so excited to learn it...😃👏👏👌👌
Wonderful!
never knew i could enjoy watching an Excel tutorial on a weekend.
Really nice! ZERO ums, ahs, pauses, or slips. Perfect! Thank you! I bought a pile of your Udemy courses too.
That's great. I hope you will enjoy the courses.
@@LeilaGharani It's VERY RARE that I hear anyone on RUclips as good as you are. You never make a verbal mistake; never pause to figure out what to say; never say ah, um, or utter any filler words. Every phrase you speak moves the narrative forward. I think you're the best that I've ever seen (heard). I stand in awe. :-)
Thank you :)
Thank you!
Really comprehensive overview of a function that I’d not even heard of. Thanks for sharing 👍🏻
Glad it was helpful!
Thank you
Thank you!
Thanks Leila. I have always used index-match combinations for dynamics lookups. When I purchase an office 365 subscription, I was excited about xlookup, but wasn't quite sure how to make it dynamic as we could do with index-match. The 4th example where you used nested xlookup addresses the issue.
Amazing, Indeed I benefited a lot from your lessons and raised my level of competence a lot, and therefore I got an increase in my salary
Hello Leila, Thank you for all your amazing courses on Udemy. I'm upgrading my skill through your courses.
Thank you.
Thanks
Glad the video was helpful!
Hello Leila, Thank you for all your amazing courses. I have definitely become better using them.
Thank you.
Glad to hear that Nigel!
I love how simplistic excel examples always are when in reality you are using these functions to look through 10 different workbooks lol
If you need to lookup accross 10 different workbooks, you're already way past the point of needing a database and using SQL for that.
When can we have this.....really want it. How long we need to wait...
Can't wait, so I just participated the insider program and updated my Excel...
Now, as of 10 Feb 2020.
I think it’s already out
You shouldn’t use Xlookup if you’re planning on sharing the spreadsheet with colleagues or clients. It’s functionality only works on updated versions of excel and won’t work on old versions of excel.
Paste as values.
Similar as to what Yman states - but first save a copy of your file under different file name so you can keep your formula version for yourself, then Copy -> Paste Values... a good habit to do in general because the chances of the person you are sending the file on to, knowing how to manage formulae let alone filtering and who knows what type of manipulations, better rule of thumb to keep a working file for yourself for later and provide a simple output to anyone downstream, unless the aim is to have them adjust values incorporated in the formula.
doesnt every business have o365 nowadays
@@nicok8203 no :(
We are still on MS Office 2016
Nah, upgrade or GTFO.
Thanks
Thanks so much.
I can't wait until this is included on all versions of Excel
It’s now available for all 365 versions 😊
@@LeilaGharani not working in 2007 version.
@@sandugvr because microsoft ended office 2007 and you have to pay for microsoft 365
It is not available in 2016
It is not on Office Professional Plus 2019. Bummer!
You know you're depressed af when you get excited over a new Excel formula.
Haha, then I guess I'm mega-depressed 😁
@@LeilaGharaniI am (still) excited too about this😂
"James Willard got a maximum bonus of 0 - that looks good!" - but James is sad :P Just kidding! Thank you so much for this amazing tutorial!
Poor James :)
Came here for this comment
At Last - Been waiting for the 'IF not Found' parameter for years. All I've got to wait for now is for all of my client PC to get this version of excel....
Thank you :)
Thank you!
Thank you so much for your videos!
I was very lucky to found your channel! My native language is spanish, and I can understand almost every word you say.
Thank you!
That's great to hear, Carmen!
@Leila your videos are consistently the most helpful and easiest to follow. Every now and again, I click on someone else's video for help but I almost always come back and end up finding what I need from yours. Thank you for all of your posts, they are truly helpful! --Joe
THANK YOU! I love your presentation style - just right for my knowledge of excel! I just learned about XLookup and my goal this morning was to learn how to use it. You started my day with a win!
fun tip with xlookup a dummy like me just found: you can actually set multiple lookup arrays for a single lookup value without using iferror because you already have the "if not found" scenario in xlookup. here's how it goes:
=xlookup(lookup value, [1st] lookup array, [1st] return array, [1st if not found case] xlookup(lookup value, [2nd] lookup array, [2nd] return array, [2nd if not found case] xlookup( lookup value, [3rd] lookup array... and so on and on...
it works fine you can try it. i thought it would be useful to share this.
Terima kasih.
Thank you so much!
Loved it. Ok. the video is three years old and I am watching it now. In repeatng your steps, I included an offset to get the names of the employees sorted.
Thanks
Thank you!
Life changing! How did I not know this?? Have already shared with other colleagues and they had not heard of Xlookup either. Super excited about using this new formula and the video was excellent, thank you so much Leila!!
Happy to help!
Thanks!
Excellent videos!! Thank you!
Thank you very much!
Earlier I use to stick to some set of formulas and do all my analysis based on those results.. lucky me randomly saw your video once (I don’t remember what was the first video I saw), impressed with the way you explain details about each argument made me to view more of your videos.. then made me to subscribe your channel.. I honestly thank you for sharing all these on RUclips for free and educating many.. I strongly believe your videos helps lot of professionals to solve many of their issues with an ease.. you are unique of your kind.. wish you all the best.. my heart full thanks to you..🤝💐
Thank you very much for the kind feedback. I'm really happy you find the content useful.
Great explanation and very smooth transition between examples. Thank you for this - really helpful.
Terima kasih.
How is the formula xlookup xlookup @10:25 different from index match match?
¡Gracias!
Thank you!
Leila is the hero we never knew we needed. Amazing courses!
Thank you, I have been using LOOKUP with IF statements and have issues when I sort. My work has finally updated from EXCELL 2007 and I thought I should see what's new.. These are the best tutorials I have found. Thanks for teaching this old dog new tricks.
love the way you speak and teach. Wish you keep teaching always and i keep listening.....thanks for being so nice while teaching. have a great day.
Terima kasih.
Thank you!
Leila, I subscribe and follow very few people however the amount of information and practical knowledge you provide is incredible. You are my immediate go to whenever I am looking to simplify my excel programs. Thank you.
Wow, thank you!
I like to listen to your tutor always because the way you explain is extraordinary, Thank you so much.
Yay, no longer need to write lengthy formula using Index Match. Thanks very much, Leila!
Also, I solved this XLookup&Xlookup formula with using Xlookup&Choose&Match formula. It returns same result as follows:
=XLOOKUP($G$3;A3:A20;CHOOSE(MATCH(G4;B2:D2;0);B3:B20;C3:C20;D3:D20))
Fantastic!!
Maybe old tip but new one for me, so I'm sharing gladly: with the amazing xlookup I just discovered with this video, you can JOIN TOGETHER two search arrays (let's say name column and surname column: XLOOKUP(A1;B1:B10&C1:C10;D1:D10)) to match with the searched value (that can also be formed by adjoining two values/cells as showed in the video with wildcards). Amazing time saver!
Your Explanation is awesome as usual. I was not understanding two ways lookup but after watching your video I can use this at ease. Thanks a lot.
I will be rewatching this a few times. Game-changing lessons in lookup function, thank you!
I do some professional development every Friday and have subscribed to your channel as an integral part of that. Your format is great. Concise, easy to follow, and very informative.
Awesome, thank you!
I've been using index match for way too long as a step up from vlookup. Now I don't have to because of xlookup. Thank you.
I have a limited knowledge in using excel so this one for sure will help increase my interest in using excel.
That nested xlookup is lit🔥...thanks!!
I was going to change a excel i use at fork, to be more automated and just found this vid, it will make it a lot easier for me. Funny thing is that actually I can use all of the examples in different areas of the excel! Can't wait to update the sheet now;).
Thanks
Thanks Leila, for this video. I did not understand two-way xlookup tough I found it useful, please make another video on it.
As always Laila.... awesome!!! You're my first option as soon as I have an excel doubt 😍😍
Hello Leila Gharani, thank you for sharing this information, its very simple & sweet explanation. Smile.
I started a job that required me to give reports, data collection and stuff of that nature. I had zero experience with excel and thanks to your in-depth tutorials I have excelled (no pun intended) in this position thank you so much for what you do.
That's great to hear Marcus! I'm glad the tutorials are helpful.
I have been using sumproduct for the 2 way lookup but xlookup seems easier and simpler. Thank you!
I never thought I would use this, but now I can't wait! Thank you!!!!!!!
Thanks for the simple approach Leila to the multiple variable XLOOKUP function!
Hi leila, your technique of xlookup is too good
Leila thankyou so much for all your videos. You are my goto.. Thank you for making me smarter.
Hello Leila, Thank you for all your amazing courses
The best lesson ever, thanks from Brazil.
Great explanation ❤
Totally new to me! Having never seen a video of someone showing Excel tips I have to let the geek in me out and say, wow. It was a pleasure. From all my years facing people who use Excel as digital paper, not as the tool it has potential to be, I simply loved watching someone know what they are doing. Weirdly attractive :D Guess I learned something new about myself as well as Excel :D
@lelia on the xlookup two way search is there a way to show all the results of all the employees in one go? Have them all appear?
Indeed powerful I will be using te tutorials to enhance my skills
i ove the way you're talking
also you have a very nice voice which fits for a teacher
thanks for your lessons
I had no idea this even existed. These videos are invaluable!
Just wat I needed a quick look at the new syntax , thanks Ms Gharani
I never used XLOOKUP before but thank you for this. It's easier than VLOOKUP since you don't have to arrange everything to the right of your array. Thank you!
Well explained tutorials there, i have finally been able to retrieve the data i needed without any error. Thank you so much.
♥️ i love you and your sound and your excel lessons. I liked xlookup too. Greetings from Arabia. ♥️
Woke up this morning to find my Xlookup available. Mannnn am I rejoicing!!! Let the fun begin.
whatttttt and an XMATCH! Boomshakalaka!!!
Yay! Congrats. So many things to explore now :)
Never comment before but Leila ,you are the greatest
Many thanks. As always, Crystal clear. Will be shifting to xlookup.
So I have an excel exam of three hours in an upcoming interview, and have no idea what curve ball they will throw at me, not to mention what can you test for three hours, so I am going through all formulas, learning power query, and piovot table. Your video by far the most coherent and so well made. I always though that excel is to much formulas and very hard to learn, but I am enjoying it very much. I subscribed. Maybe you can do some video on interview exams, and what and how the exams go. Thank you so much, I will continue learning regardles of if I get the job or not
Hi Anna. Wow! 3 hours! I've never heard of that. Could you share some of the questions they asked you at the interview? Also for what position you are interviewing for? I'm really curious. You can find my email in the "about" page or on xelplus.com. We could made a video about common questions to help others out. Wish you all the best for your interview.
@@LeilaGharani hi! Thank you so much for responding, I also am curious to what they might give for such a long exam. So the position is technical succsses manager in "datarails" and the company basically helps users with their excel, to make it more assemble the data. So it does make sense they want to test excel....but to what extend?
If I may, I would love to ask u if u have some example sheets I can practice on, I would really appreciate it.
And ofcourse after the exam, I will make sure to send u the excel sheet they sent me.
Anna.bartenev@gmail.com (if it's relevant for excel sheets)
How did it go? What questions did they ask?
Thank you for the video. Well presented and using good examples.
For those who are wondering about performance, the news is not good. XLOOKUP is really slow, likely slower than the old V/H-LOOKUP versions as it does more checks. I tested it on a little dataset (~150 rows of data) where I have a macro that runs the "TRIM" command on a given column that's used by the XLOOKUP function in another column. It takes about 35 seconds to run. When I replace the XLOOKUP with a index-match version, it runs in about 7 seconds...
Ah, not a great look for xlookup then (no pun intended)…
@@kajet666 Nope, but to be fair, it's not really slower than the old VLOOKUP, just still much slower than a index-match version of the code, even with additional code to emulate the new options that come with XLOOKUP
@@sbom so I guess your macro has xlookup run through the 150 rows many, many times - wonder what the performance will be with a larger (5000 rows, say) dataset but no VBA.
@@kajet666 Actually in this case the macro only goes through the cells and runs the TRIM command to remove spaces at the beginning/end of each, but Excel recalculates the results of those other cells which have the XLOOKUP command, which is the time-consuming step, not the macro code itself. I'm sure there's a way to tell Excel to stop recalculating until the macro has finished removing all the spaces, and only update once, but my point for the test was to show that the performance of the XLOOKUP is not good, as that'll be an issue as you mention for large datasets with thousands of entries.
I must say, "It's awesome and helping a lot" Excellent Job!!! Bingo!
Much appreciated!
This is game changer! No longer have to arrange data for lookup! Thank you.
Excellent. You explain this in an easy to understand way. I liked vlookup but I love xlookup. Can’t wait to put it to good use. Thumbs up from me!
You are doing great job, thanks a million from Egypt.
I love this woman. You are amazing.
Very awesome. I'm retired but used v and h lookups all the time... 😀😃😄