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.

[@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!

[@bigbasildogs7239]

What, educational AND entertaining format? Smart and adorable, you could not be cuter if you tried. 😊 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

[@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!

[@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.

[@bazamiri]

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

[@RIIIIIIKA]

Omggggg I Love this story telling. It’s real life situation. 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. :)

[@kamilahnash2856]

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

[@JBB685]

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

[@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

[@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!

[@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!

[@arthurascalon3867]

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

[@sedarathnadcd]

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

[@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🌹

[@MGA19a]

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

[@dmc8161]

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

[@MikoKohmaria]

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

[@sudhersungnanasekar4293]

This format of teaching is good 👍

[@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.

[@ATLHwy285]

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

[@girdavid178]

This is a great presentation !

[@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!

[@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.

[@arashy]

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

[@sufiyankhan618]

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

[@LeilaGharani]

Thank you so much 😀

[@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.

[@NancyPickering]

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

[@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 😂😂😂

[@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

[@dawn-of-newday]

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

[@xaquison]

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

[@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...

[@bmaellet]

❤️ You the best Lelia 🌹

[@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!

[@rmcdescabelado]

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

[@surenmagar8304]

A new way of teaching. Amazing!!

[@kouroshgerashi2143]

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

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

[@alex626ification]

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

[@jpaybstudio]

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

[@LeilaGharani]

Glad you like it, Joyce!

[@johnj2041]

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

[@franciscunninghamjr.3496]

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

[@sarahmclin2434]

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

[@meetusingh649]

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

[@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!

[@kinrajeshverma]

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

[@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 😆🤣🤣😆

[@Pronellyllon]

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

[@haroldskinner1783]

That was a great video, entertaining and informative

[@bendilla5292]

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

[@BobG-eh5fc]

A new approach, like it :)

[@dpchand]

Such a nice video as usual ❤

[@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

[@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...

[@davida6146]

The characters make these tutorials fun to watch 😂👍

[@rekirmar]

Love it I can see this happening at work 😄

[@chrism9037]

Excellent Leila!!!

[@PaulVass1]

Very entertaining and informative. Thankyou.

[@haydeecastillo4621]

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

[@LeilaGharani]

😂

[@jjhwang]

OMG! Leila, such a cute video!! loved it :)

[@DanielDuedu]

Really enjoyed this

[@chrisb7142]

Really enjoyed it!

[@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 ..

[@CPIVCR]

like your new format

[@PokerFather04]

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

[@luisanahernandez8853]

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

[@studogable]

Good video. Very clever and self-aware.

[@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 💪🏻😆👌🏻

[@MasoodAhmad-su2gp]

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

[@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

[@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 😉

[@OmkarPattanshetti]

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

[@gordon4228]

Thakyou, thankyou, thankyou, ... remember both columns havr to be the same text , number etc

[@Kicsa]

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

[@rISHIRAJsiNGHgAUR]

Wow, u r superb. Thanks for making our life easier

[@syuriakhafi]

Thanks, your video really help me a lot

[@williammckinstry1132]

Great Tutorial 😀 Fun and teaching

[@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 😊😊

[@Afzal_EightySix]

This is great! Even though I know this, it was great fun to watch!

[@shivajaiswal985]

Very good, this way explains much better

[@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

[@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. 😅

[@jthespacec]

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

[@Bhavik_Khatri]

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

[@karimallahwala7022]

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

[@gaggicarica]

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

[@kirandas1287]

Hi there, i liked this video could you please make more of this kind of videos

[@danteng12]

I'm in love with Noob Lelia.

[@kavinyudhitia]

Thanks a lot as always!!

[@PemberiSolusi]

amazing, thank so much for this knowladge inf excel,,,

[@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

[@HowToAnalyst]

The pro owes the noob a soda after that one!

[@amjan]

Damn, I need to start using the Xlookup!

[@discovermore1]

Its really amazing. Very very helpful.

[@darrell6642]

You are the best!!!🤓🤓🤓