Excel LOOKUP Values with Two Spreadsheets (Noob vs Pro)

[@LeilaGharani]

Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter

[@archielang7427]

I'm never unsubbing. Or using vlookup ever again.

[@marklugo8734]

“Oh my God! You’re so grumpy, but you saved my day.” I’ve been on both sides of this. When I’m on the Noob-side (because I’m completely lost!) I am THAT appreciative of the help from peers. When I’m on the Pro-side (because I’ve made the mistakes, someone showed me how to fix it, or I kept at it till I figured it out) I’m usually juggling a lot of things. I recognized the “attitude” as frustration in wanting to help a peer while dealing with time constraints. We asked, were helped, we learned, and we passed it on to the next person. Great information and presentation and THEATER in your work. Thank you.

[@ricardoluizmarcello]

😂😂😂 I loved the theater presentation!!! You have talent to be actress!!! Could you make a video about macros??

[@LeilaGharani]

😀 hmmmm… the noob learning macros.

[@derekporter66]

It would be a months worth of videos

[@bigbasildogs7239]

What, educational AND entertaining format? Smart and adorable, you could not be cuter if you tried. 😊 Thank you!

[@sharon3470]

Leila, thank you for a great presentation on how to do things. I LOVED how you acted out the noob as you showed what was happening in excel and talking through what was happening, why doing what you were doing or why you were/wanted to do that step. This was perfect to help understand the process and reasoning. This is the best Excel I have ever seen. You are amazing. Thank you so much.

[@LeilaGharani]

Thank you! I’m glad you enjoyed the format.

[@anhsingh5789]

Love it! Thanks for making the training session interesting, Leila!

[@zero2herobeatspaul882]

I watched the whole video with a big smile on my face. What a great way to present this information.

[@LeilaGharani]

Glad you enjoyed it, Paul!

[@bitesale]

Hi Leila and team. I gotta say, I didn't expect to be the excel go to person in the company I work for. But, one video after another, I got better and better working with Excel, doing my thing, getting all my documents sharper and more efficient to the point where high level management noticed. The result ...not only did I got promoted from team lead to a management position, I was also tasked with training team leaders, managers and high level executives on Excel for the entire company. Here I am, almost no education, and people rely on me for excel training ... and I blame you for that 😂!! Thanks.

[@rajeshbuya]

The video has completed, but not my smile :) What a transition, Leila, from your PRO videos to PRO-vs-NOOB video. Have been a great follower of ALL your videos, and my passion for Excel just took a further leap

[@LeilaGharani]

Thank you for your support and your kind comment.

[@RIIIIIIKA]

Omggggg I Love this story telling. It’s real life situation. Thank you.

[@jonminer9891]

Hi, Leila. It is so helpful to have a good friend help you with your work, especially when your friend knows just what you need. Thanks for sharing! Stay healthy!

[@bazamiri]

I love this lady. You are amazing Leila. Thank you ❤

[@evorook463]

These videos are so helpful even for intermediate-advanced Excel users. I am quite good with Vlookup and laughed at the noob, but still learn a few things from the pro. :)

[@plausibleGG]

These are the best excel videos I have ever seen, and I have learnt all my excel from KZbin. Wish I found your channel sooner! Would have made so many things easier

[@Gorman-84]

If you are wondering, yes, very fun and entertaining! Oh, and I learned stuff also. Can't get enough of your videos.

[@LeilaGharani]

Awesome, thank you!

[@amoorinet..]

I will never forget how hard I understood vlocookup function at first, and today I am very proud that with your videos I have reached the level of how to make everything dynamic in excel Really thank you

[@LeilaGharani]

😀 Very happy to hear that!

[@vijayarjunwadkar]

😂😂 Quite entertaining this "Noob & Pro" pair! Leila, you are a good actor too, to easily switch between them! BTW, most of us are Noob, and Leila the Pro is our savior! 👍

[@johnvrabec9747]

This was so funny! Don't forget to tip your server before you leave!

[@mohammedlabeeb]

OMG. If this is a TV show I would watch it on Netflix. Very entertaining and also learning my favorite excel tricks.

[@venex7835]

great job .... i am learning a lot from you thanks🌹

[@arthurascalon3867]

I can't stop sharing your Noob versus Pro video. It's sooooo cool... perfect scripts...

[@danielrichards8596]

I work for a large organization, during a regional meeting, an accountant was explaining a process she uses. One of the steps was to get data from the previous months spreadsheet. I was suprised when she started the vlookup formula. After the meeting I emailed her a suggestion that she use xlookup instead. I was suprised to see she had not heard if xlookup. Thank you for your videos and keeping us informed!

[@LeilaGharani]

🙌 we need to spread the word.

[@j.ballsdeep420]

I mean if she makes it work it's doing the same thing so long as data you need isn't on the left, laugh, but she probably uses a regular lookup with combo of index/match if she knows vlookup, in which case you wouldn't be wrong that it would be _easier_ to learn xlookup. Just saying if you're array lookup and return is in one column then it's literally no difference. Also, using PowerQuery for the connection to the folder containing each month's reporting so she could open her file and it would automatically load said data without ever needing to add a formula in the steps (assuming you have your preference for the query to refresh upon opening). 😉

[@j.ballsdeep420]

This is why I hate explaining my process to an open room like a regional meeting or national (and don't). I never share my recipe unless in safe, closed door meetings with allies who are open to discussion rather than just assuming I should do something different cause I know a different way to do it. Only rubs me wrong cause you say she should use it instead when there are still reasons for using lookup, index/match, hlookup, or vlookup, or frankly maybe comfort with doing what's normal and maybe it doesn't matter if she's getting what she needs. Just saying that criticism, whether constructive or not, isn't always conveyed or received positively and comes across more like a critique to her process when there was no mention of her requesting your critique: tl;dr, you could come across like a dick providing feedback where it wasn't requested. Hopefully she learns to not share her recipe unless she's fine with your unsolicited suggestion of what to do instead of what she already is

[@JBB685]

Seeing my small hometown listed on a dummy data set is cool 😎

[@sufiyankhan618]

You are a simply champion of excel, the ways you create contents are amazing.

[@LeilaGharani]

Thank you so much 😀

[@FR-pk5mc]

I recently subscribed to your channel. I use Excel a lot for my day to day work. You're quickly moving me to next levels. Love your videos.

[@bobsponge9863]

Hi Leila, I always love your videos than explain things so clearly but this one is also so funny and reminds me of my every day life at work when i'm trying to explain in a very simple way various excel's things to noobs. Thanks you very much for all what you are doing. A french in the surbub of Paris

[@ATLHwy285]

Kya baat hai !! I watch your video every morning, while I’m giving a sheet over my commode.

[@alexisgt]

I've enjoyed the great display of the issue and how anyone can work around the issue. Thank you for guiding us through it.

[@MGA19a]

Omg you are so grumpy but you saved my day bye bye 😂😂😂

[@kamilahnash2856]

It was awesome that you used a scenario to bring the learning to us. Thank you.

[@ivanmamchych5802]

Actually this 'Noob' character is pretty advanced Excel user anyway. She knows 'Paste Values', 'CTRL+SHIFT+DOWN ARROW', double clicking to right bottom corner of the cell for copying down and so on. On reality a 'Noob' knows only SUM function and has a very basic skills with AutoFilter and simple Sort. VLOOKUP is the next and often unreachable level for them. Thanks for the video!

[@LeilaGharani]

True! This is the noob in season 5 😉

[@Grumpy_Granddad]

This one made my day -0- watched it this morning and started the day with a laugh. Miss Noob telling off Grumpy Pro :D 😆🤣🤣😆

[@MikoKohmaria]

And just like that... Leila took her channel altogether to another level!

[@arashy]

Love, love, love your presentation! So funny! Truly entertaining way of telling us to use Xlookup instead of Vlookup.

[@chrisbullPiano]

Noob Leila is hilarious! 😂 I love how unfazed she is by grumpy pro leila, and how friendly she stays right to the very end 💪🏻😆👌🏻

[@enderaslan7998]

Leila's pro vs noob videos makes me remember parallel versions of Fringe i love how she mentions noob mistakes right to the point... Delete formula, false of vlookup, remove dups on formulas, oh my god...

[@mayimoona4868]

I really love this Noob vs Pro video. It is funny and helpful at the same time. Thank you for sharing this with us.

[@LeilaGharani]

Glad you enjoyed it!

[@NancyPickering]

I'm glad N00b Leila is starting to stand up for herself, she's getting better all the time.

[@alex626ification]

I remember when I learned vlookup, but quickly realized the limitations of it, and then learned index/match.

[@williamarthur4801]

You could almost give up the day job, and it was a great reminder of how to use vlookup. which with x , index match , power query etc gets forgotten 😊😊

[@dawn-of-newday]

I was really struggling with excel. I found this video very enjoying and helpful.

[@dmc8161]

Great video. Love the skit to explain the solution to common questions!!

[@andreasmueller-alwart2517]

What a nice infotainment! Your sister still has a lot to learn before she can master Excel as well as you, Leila. But she is learning fast...

[@Xrusader]

I tried xlookup a few times and it works great. However, my company has some branches on older versions of Excel (xlookup doesn't exist in their version). If I send them a spreadsheet with xlookups, they just see errors. Because of this, I went back to index/match formulas to ensure compatibility.

[@mattfrench2120]

Exactly. It's not a standardised function across versions, so it may as well not exist for us.

[@akula743]

This is v practical issue faced

[@j.ballsdeep420]

Well unless you used the full file name in your array lookup it would break the same way for them as they wouldn't have your array workbook open, laugh. Either way, why would you be sending a file with calculations being done outside the workbook you're sending? Just save your file as CSV or create a new workbook pasting as values matching type.

[@yeahjustlikethat]

Use power query

[@jthespacec]

hahahah. Love the side note! I was just thinking that Boss Leila is so mean! Haha.

[@sedarathnadcd]

wooow. It is a good presentation, We love it. You are good actor too

[@Pronellyllon]

I can’t help but notice the noob is logged into pro Leila’s account. Love the way you made this video!

[@rogerspence4144]

This has been my wife and I for the past two years working at home together! My life got a lot quieter after I introduced her to your videos 😂😂😂

[@robertovoce5545]

Incredibily nice! Leila will soon leave Xcel to become a super paid actress! 😁 And that squeaky voice of the noob... So cute! 😍 BTW after knowing XLOOKUP I don't use VLOOKUP anymore. 😅

[@sudhersungnanasekar4293]

This format of teaching is good 👍

[@Bendersnatchling]

Whenever I read "Good Excel skills required" I thought "Sure, I know how to add up a column." After watching some of your videos....not so sure anymore 😂 Amazing what you can do with excel

[@LeilaGharani]

😁

[@jpaybstudio]

I love this noob and pro content. entertaining and educational!

[@LeilaGharani]

Glad you like it, Joyce!

[@xaquison]

Xlookup all the way. So much easier and better to use.

[@johnj2041]

Love your acting Leila, you should be in Hollywood !!

At this pace there is a serious risk of that, great looking, noob turning up into a pro soon 😁

[@kinrajeshverma]

Thanks for the video, I tried xlookup post this video and it really works!

[@franciscunninghamjr.3496]

The alter ego is back! Adds another element to a teaching video. Thanks

[@rmcdescabelado]

The video quality is really good. You made excel content interesting, thanks.

[@carlosgranah]

The problem most people have is that you get acostumbed to using only VLookup for everything. Excel versions have updates making your life easier. Thank you doing these videos.

[@j.ballsdeep420]

Dude I still use regular lookups for certain formulas just better suited. Relying on one method is just holding yourself back

[@meetusingh649]

You are the Best .... My Excel Mentor and big inspiration ❤️

[@haydeecastillo4621]

Just me and noob bringing out the best out of the experts at work

[@LeilaGharani]

😂

[@girdavid178]

This is a great presentation !

[@gaborfodor7559]

I have performance issues with XLOOKUP on large datasets. Comparing with INDEX&MATCH it is significantly slower. So watch out!

[@j.ballsdeep420]

Have you tried using table, row reference rather than absolutes, and referring to #ALL and header to only check the table and not the 107k rows or whatever it is standard for a worksheet? I have many calculations that go upward of 50k rows and calculation is -maybe- 5sec tops? I did have a bit more calculation time referencing the column absolute in my array lookup step, though

[@gaborfodor7559]

@@j.ballsdeep420 I use a "traditional" table, but I will give it a try by making it dynamic and changing the references. Thanks for the hint!

[@davida6146]

The characters make these tutorials fun to watch 😂👍

[@MasoodAhmad-su2gp]

A very very effective way of teaching, loved it… 🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣

[@kouroshgerashi2143]

You're The best excel pro I have ever seen. ممنون

[@AptyTheKiwi]

I'm pleased that you explained the Pro wasn't a bully @Leila. I was starting to feel a bit uncomfortable about her behaviour. :D

[@surenmagar8304]

A new way of teaching. Amazing!!

[@msflemin]

Back in the day when I was managing thousands of products in multiple tabs, I wish I had known about X-LOOKUP. I used to write macros to rearrange the raw data (A daily download from SAP), then run macros using VLOOKUP, to compare actuals orders and shipments in the quarter to quarterly plan and quarterly forecast totals to complete my variance reports. XLOOKUP would have saved me days of work every quarter to update macros and testing to assure accuracy.

[@bendilla5292]

Great video, and I like the noob vs pro format. Thank you.

[@bmaellet]

❤️ You the best Lelia 🌹

[@PokerFather04]

great job...and you made me chuckle too. Thank you!

[@michaelbutzen8122]

Might be good to do a video on the annoying XREF error when working with VLOOKUP to another worksheet, and when both workbooks are opened at the same time

[@jorgelara3116]

Haha love it!! You are so talent and creative girl .. thanks again for you video is nice having fun and learning at the same time . God bless you ..

[@gaggicarica]

You are so talented Leila! Love this show performance! Could you make a video about creating macros, some basic stuff for beginners?

[@mishellekochel4510]

I'm afraid I've given up on Excel other than easy general data. I'd live to do so much more but I think an actual class is what this ol girl needs. When it first came out I was the go to person, now, I'm way behind the times!!

[@j.ballsdeep420]

Lots of free online courses including some free ones from Microsoft themselves.

[@OmkarPattanshetti]

Loving your videos! Very easy to understand! Can you tell about professional opportunities with Excel skills?

[@roksanamarszaek-sr5qq]

Hi Leila, great video, as always :) thanks! I've got a question about lookup functions working with two workbooks - as it's is clearly visible in 4:01, once you are going from first workbook to the second, Excel 'keeps' vlookup formula in formula bar expecting table array. However, it happened to me many times, especially when I was working on large files, that when I was trying to select table array in the another file (not this one where I put formula) Excel was 'losing' the formula. I still could select some table array within this workbook where I put the formula , but not from the another workbook. It was like two workboooks that Excel couldn't connect through vlookup function. The solution that helped here was to close all excel workbooks ad open them again, but I'm wondering have You experienced such problem and have better solution? :)

[@sarahmclin2434]

Another great video. I hope the pro is having a better day!

[@707jeevan]

Firstly your videos are amazing. Learnt a lot from you. Thank you very much. Can you please make a video on how to make a microsoft list column accept unique value submission from form but if values submitted second time from form.. . It gets updated (it replaces old data) rather than making new entry..for example if I have an order number..new submission should not create another entry with same order number but update all the the other details/changes of that order number

[@rekirmar]

Love it I can see this happening at work 😄

[@justapasserby69420]

The more pro solution is to relate the two tables in Power Query and perform a one to many inner join on Customer ID, then relating it in PowerPivot diagram mode

[@naoki410]

Exactly and it takes less than a minute

[@popk814]

@@naoki410 literally takes 3-5mins just to connect to powerquery in my office lol. I try to avoid it at all costs and just stick with excel functions and vba

[@Kicsa]

I wish I used Excel more in my work, that seemed like fun.

[@richardgilbert9042]

Despite my comment favoring INDEX() + MATCH() vs XLOOKUP(), you make very useful (and entertaining) video posts.

[@richardgilbert9042]

INDEX() + MATCH() has been my go-to since it became available. I can't recall when I last used VLOOKUP(). XLOOKUP() is pretty cool, but INDEX() + MATCH() (plus a little error handling with IFNA()) has the benefit of being backward compatible for about 20 years of Excel versions.

[@AlfaAddict]

Index match & sumproduct ftw

[@haroldskinner1783]

That was a great video, entertaining and informative

[@amjan]

Damn, I need to start using the Xlookup!

[@BobG-eh5fc]

A new approach, like it :)

[@luisanahernandez8853]

Hello I love this kind of videos Noob vs pro can make more videos please I learn a lot from you thank you

[@ambarilhamchannel]

This video title is so interesting.. Leila, could you please to answer my question. Is there any reading panes on the newest excel version? I haven't found any videos that explain Excel reading panes, we need to install additional software to add that feature into Excel unless we use conditonal formatting function that needs extra effort

[@PaulVass1]

Very entertaining and informative. Thankyou.

[@RogerStocker]

Hi Leila, I'm happy to have XLOOKUP(). It might be a good idea to create a video for an HLOOKUP() replacement. I guess most of the users are not aware about this usage for XLOOKUP().

[@j.ballsdeep420]

Good suggestion. I found it rare people knew of hlookup in the first place but you're not wrong

[@emilland07]

Hi Leila, i like your videos, could you please make more videos about advanced text functions ( how to use together Left, Right, Mid, Substitute,Search) thanks in advance

[@dpchand]

Such a nice video as usual ❤

[@arickson1603]

Thanks, I don't speak English but I could understood. I LOVE YOU 😍😘😍😘😍😘

[@karimallahwala7022]

Very nice, funny and of course very helpful.Thank you very much

[@syuriakhafi]

Thanks, your video really help me a lot

[@richardhay645]

Quick Books is widely used. many users wanntvto export dsta to excel either to analyze or to stop using QB in favor of Excel. Could you do a video showing how to export a QB check register and other QB files to Excel. First to extact QB files as CSV files, then bring them into Power Query and trasnsform them to bring them into an Excel spreadsheet.

[@studogable]

Good video. Very clever and self-aware.

[@ichiroutakashima4503]

That grumpy senior..m yeah, I felt that. HARD. On the other hand, I do hope for your reply. I was trying out one of your videos pertaining "Macros" and following to automate a chart. However, my chart feature seems to be different. Mine always seem to insert a new sheet and put the newly created chart there BUT it also comes with tables. Which I find weird.

[@LeilaGharani]

Not sure which video that was but have you checked the description of that video? Usually I add a link where you can download the file. You’ll find it in the blog post at the bottom.

[@Bhavik_Khatri]

The noob makes me feel like pro, but the pro makes be feel like a beginner.

[@kavinyudhitia]

Thanks a lot as always!!