Lookup values across multiple worksheets: VLOOKUP / INDEX MATCH in Excel

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/lookup-different-sheets

[@BoardgameBaker]

I feel like a kid watching Wayne Gretzky play ice hockey. This level of Excel knowledge borders on witchcraft. Really impressive, Leila!

[@arturosteven1006]

You probably dont give a damn but does anybody know a method to log back into an instagram account?? I was dumb forgot my login password. I appreciate any tricks you can give me

[@londonsonny6112]

@Arturo Steven instablaster :)

[@arturosteven1006]

@London Sonny Thanks so much for your reply. I found the site thru google and I'm in the hacking process atm. Looks like it's gonna take quite some time so I will get back to you later with my results.

[@arturosteven1006]

@London Sonny it did the trick and I actually got access to my account again. Im so happy:D Thank you so much you saved my ass!

[@londonsonny6112]

@Arturo Steven you are welcome :D

[@prakashreddy5466]

Leila You are always inspiring me, thank you so much for your detailed explanation. You've always sounded good, but this was your best! big fan of your sweet voice.😊

[@ajaysharma-gw1vy]

have re-winded the video couple of times to fully understand the concept..but every second worth it. thanks

[@aaronwait4223]

I've been trying to work out how to do this for my assessment for the past couple of hours. Watched 4 minutes of your video and I've nailed it.

[@LeilaGharani]

Glad to hear it was helpful!

[@stephanetrottier6570]

FINALLY!!! Someone who can explain things in a clear way and make it look easy!! I've subscribed because of your entire series on INDEX MATCH & VLOOKUP...!!!! Thanks for these videos, even if it's 3 years old!!!

[@LeilaGharani]

Awesome, thank you Stéphane!

[@WintaLe]

You helped me solve an excel problem that I've been stuck on for 3 days. Thank youuu!! Subscribed.

[@apwnew]

Leila - the session is incredibly supportive. Thank you for that one! :) I appreciate it.

[@kbalaji9516]

great... its very easy to understand the way you are explaining complex things in simple way..

[@unforgetable4747]

Saved me a lot of time that otherwise would have wasted on making nested if formulas for 10 worksheets. Thanks a lot. Your channel is really the best one out there.

[@LeilaGharani]

Wow, thank you very much!

[@maherhadi5828]

excellent and crystal clear explanation, many thanks for sharing.

[@kojosephine6255]

Your approach to build up functions is excellent, good job👍🏻👍🏻

[@LeilaGharani]

Thanks! 😃

[@1kevinerickson]

You have helped me countless times! Thank you so much for all your videos.

[@propixelperfect1006]

Thank you very much Leila...You will be remembered😌😌

[@MrLinkolin]

This is sooo helpful, thanks for these tips! The INDEX(INDIRECT really helped me!

[@yaredhailu9130]

Dear Leila your class were excellent. And I like your videos they are clear and effective. 👌👌

[@LeilaGharani]

Thank you! 😃

[@HappyHouseIdeas]

Hello. Thank you so much.:)

[@alimr1988]

Outstanding explanation. Thankyou very much it really solved my problems

[@johnnyfiver4274]

I've watched it several times and still confused. Guess I've got to back up and learn the basics of VLOOKUP and INDIRECT before trying to tackle this one. Thought I knew Excel until I found this series. She is the MASTER of Excel, thats for sure. I'm impressed with her knowledge.

[@kuldeep.3012]

Mam, I become your fan. Best Excel Teacher. Always Thumbs up & always my support to you.

[@LeilaGharani]

Wow, thank you!

[@ernahubbard2062]

Thank you so much for the explanation, finally got it working with your video and example file, the brackets and other tiny details are killing me.

[@jesham7627]

Perfect function explanation, cadence, audio/video quality. New subber here!! Thank you very muh.

[@LeilaGharani]

Thanks for the sub!

[@rina2012ful]

I am blown away Excel has a lot to offer!

[@yashsomaiya8141]

Hi Leila, this excel trick is spectacular. I have never seen this trick on any channel it's worth watching. Please upload videos based on Excel, PPT, Docx & Access. If you are not planning to do it anytime soon than please tell me such that I can start looking for other alternatives.

[@praveenk1672]

One of the best tutorial I have ever seen. Your videos are loaded with learning

[@LeilaGharani]

Wow, thanks!

[@jassahib]

Great Video, I was searching for a formula like this for many days. Thanks!

[@LeilaGharani]

Glad it was helpful!

[@ulrichboussouka540]

Leila you are one of the best ever.im from Gabon very passionated with your excel classes.thanks a lot for what your help to humanity

[@chamindabasnayake4844]

Thank you Leila ! You provide us a very useful way to extract data from multiple worksheets.

[@LeilaGharani]

You're welcome Chaminda.

[@sudhirhiwale9784]

Excellent trick. Thank you very much Leila.

[@LeilaGharani]

My pleasure. Glad you like it.

[@toml7183]

Realy enjoying your classes.

[@LeilaGharani]

I'm glad you like the videos.

[@michaeldiamond2726]

Hi Leila, This was a really slick video. When you first started it I thought you were going the 3D route but this you solutions are really cool! Thank you for the video. Michael

[@LeilaGharani]

Thank you Michael :)

[@rajujoglekar5135]

Thank you, have helped me consolidated data from multiple sheet. Gratitude.

[@ankitajaggi8454]

thank you very much Leila for sharing your skills. So much clarity the way you teach.....truly appreciate it.

[@LeilaGharani]

Thank you Ankita! Glad you like the videos :)

[@LeilaGharani]

Thank you Ankita! Glad you like the videos :)

[@manishaahlawat1640]

Awesome explanations .....of each formula....I love the way you describe the formulas...👌

[@LeilaGharani]

Thank you Manisha. I'm glad you find the explanation easy to follow.

[@saffihussam2995]

Great video Leila , honestly you explained greattt!!! my very big problem is solvedddddddddd............... thanks a lotttttt to you.

[@LeilaGharani]

That's great to hear, Saffi!

[@vida1719]

Such a powerful Indirect feature and even greater your explanation

[@LeilaGharani]

It was a difficult one to explain. I'm glad you find it easy to follow :)

[@BobVanMol]

Hi Leila, Awesome and your teaching and explaining is excellent and easy to understand. I use Office 2019 and for some reason the VLOOKUP didn't work for me but the INDEX-MATCH did work by converting to Table. Thank you very and it was enjoyable to follow and learn from your tutorials

[@amitumi5654]

Leila you are really a natural talent kid. love from Bangladesh.

[@juanortegam73]

I don’t know which thing got me in love the most, you or you’re lessons...I would say both haha! Such a beautiful woman😍

[@LeilaGharani]

Thank you! 😃

[@satishkumardommeti8282]

Thanks. Indirect reference for sheet names was very helpful.

[@andrewglenbenson6007]

This just ended a massive headache for me. Thank you! I'm sure I'll return to your channel in the future. Keep up the good work!

[@LeilaGharani]

I hope you will Andrew. Glad the video was helpful.

[@mrCetus]

So much clarity in your presentation. Thank you Leila.I have been looking for something like this for a long time.

[@danhilvert170]

Absolutely outstanding Lelia, great succinct explanation to sometime i've been trying to resolve for a looooooooooong time. God bless you and your future Excel adventures.

[@ariefyazid2399]

very good and helpful. the details and the explaination are very precise

[@mfema1]

Speechless... Incredible skills.

[@LeilaGharani]

Thank you so much 😀

[@anujpradhananga9177]

Great Video. Thank you so much.

[@cassandra2037]

This video was exactly the solution I needed the first time I came across it a couple years ago! Now, I'm coming back to it for another project and it's just as useful now as it was then. :D Thank you so much!

[@LeilaGharani]

You're very welcome Cassandra!

[@lucasb409]

currently pulling my hair out trying to figure out a solution. But your videos make my life much easier. Thank you.

[@orcniffp]

Everytime I hear this girl say "Today, I am gonna show you..." I get the shivers!

[@khulekani_ndlovu]

😂😂

[@gustirolli441]

Hi Leila, excellent Video, you made my day 🙂

[@loidaasar487]

Hello Leila, nice video! g reat sharing... learned a lot from this

[@excelisfun]

Great video : ) Such a useful set of tricks!

[@LeilaGharani]

Thank you Mike : )

[@mammenmathews7087]

I totally agree mike... this was a good one with vlookup and indirect.... very useful. Thanks @leila

[@LeilaGharani]

You're welcome Mammen. Thank you for the support.

[@jeetkumar-no8xy]

ExcelIsFun .Hi mam I jeet from india, mam your teaching method is very easy and helpful for us I watch your all videos

[@renegadek9]

Saw this video a couple days ago and used it a today!

[@RockStar-vh1bm]

your video is so helpful for me, thanks

[@fahadhassan3291]

Your teaching method, tone, information, everything is perfect. Please will you like to teach about correlation and regression and some other things of data analysis?

[@LeilaGharani]

Thanks Fahad. Glad you like the videos. Anything specific in Excel you're looking for regarding correlations with scatter plot?

[@harishbondugula7948]

Thanks for the video for clear information on vlookup

[@LeilaGharani]

You're very welcome.

[@anshuiway]

My god what a great command on Excel function, first time I ever seen on KZbin videos like your video. So good thanks a lot.

[@LeilaGharani]

Thank you Anubhav! I'm very happy to hear you like the video and find the content useful.

[@hanna8916]

Thank you, Leila! That's the most useful explanation that I've ever found! You're doing a great job!

[@LeilaGharani]

Thanks Anna! Glad you like it :)

[@ravimistry777]

This saved me a ton of time in which I have to summarize a dozen sheets! Thank you so much Prof!

[@LeilaGharani]

You're very welcome!

[@abrareanjum5643]

I got another work to do ,extend this same process for sheets from another file. Reply and solution awaited. Thank u

[@peternganga9371]

Thanks Leila. Well done.

[@krutikandhariya]

informative video!! for those who wants to upgrade level from medium to advanced!! thanks for sharing!! :)

[@LeilaGharani]

Thanks! Glad you like it!

[@PradeepKumar-eq6wl]

Thank You very much Leila 😊 You did a wondefuljob and it helped me alot and i have subscribed today from india🏆👏

[@LeilaGharani]

Thanks for subbing!

[@S1lkySaajan]

This is amazing. I couldn't get the formulae right at first but the fact you then supply the example worksheet means that I could easily correct it. Thank you for covering such an essential topic!

[@rajkaranrana3598]

You are queen of excel dear, being punjabi understanding with such accent seems difficult🤣😅but by just following your syntax it made it simple

[@vishugupta250]

U Explained this kind of topic in very lucid way....!!! Amazing 😊 thankuu very very much... 😘

[@LeilaGharani]

You're very welcome. Glad you like the video.

[@1gopalakrishnarao]

Thanks Mam, again one more useful, beneficial and helpful formula for the Excel users/lovers/addicts. One more time great, great big salute to your brain and feet, for providing and publishing this type of great videos, and making us jealous about you in your Excel skills. We are very very lucky to get the videos at timely intervals. Waiting eagerly to watch one more video. Praying the god to get an opportunity to see you in person and to learn more and more skills for the benefit and welfare of the community. A Royal Salute.

[@LeilaGharani]

You're very welcome Gopala and thank you very much for the kind words. I am very glad you find the videos beneficial.

[@promiseuzondu8735]

You are a life saver. I would like to know what I need to do to join your MS Power BI, Power Query and Tableau full course?

[@naboulsikhalid7763]

as usual, Great videos embellished with nice and understandable explanation. Just WOW. Thank you Leila. PS: always beautiful outfit

[@LeilaGharani]

Thank you 😘

[@RedSioux1972]

I just would like to say thank you. I’ve learnt a lot from your channel.

[@LeilaGharani]

Happy to hear that!

[@santtyyyy]

Thank you Leila! I really like the way you use functions most out of it...😃

[@LeilaGharani]

You're welcome Santosh.

[@brettbebusy]

this was a lifesaver. Thank you!

[@LeilaGharani]

Glad it helped!

[@Mahesh-nu4hi]

Wow, Thanks for the video and EXCEL is very easy to learn from your videos, I would love to 😊 meet you in person, God bless you & be safe in this COVID_19 crisis.

[@md.rosado]

Love this!

[@julioccorderoc]

I don't know if KZbin now, besides hearing what I talk, also learned to reading my mind... Anyway, this video is exactly what I was looking for, thanks!

[@ThisAIisStillLearning]

THANK YOU LEILA!!!

[@mohammadasifiqbal6051]

Hi Leila hope you are doing well, your tutorials are always good and very easy to understand. Appreciate if you make Excel tutorial for linking Excel with databases like Oracle.

[@johnlangford7032]

Power Query , or are you looking an an ODBC link ??

[@harishpaldhir5915]

Geat video madam u just opened my eyes by showing how intelligently these formula can be applies and result brought out of them really a very great effort by u 😇😇😇😇😇😇

[@macolroy]

This is great!! Thank you! What if you have say 20 different tabs and may be adding other tabs to the worksheet?

[@dashrathpanchal8393]

You are excellent and genius , Nice tricks

[@sifs7258]

I love your uploads thank you

[@LeilaGharani]

Thank you for your support Amy :)

[@F002boy]

Exactly what i need now, and I remember watching this here~ Thanks a lot, Leila!

[@LeilaGharani]

Glad this came in handy :)

[@suneelrathore3324]

Very informative & knowledge able vid.

[@LeilaGharani]

Glad you like it.

[@DalekWidow]

Thank you! This video helped me solve a problem that had been driving me nuts!

[@inderjeetsaini7526]

Wow what a brilliant concept. I loved it.

[@GovindUK]

Very very thanks

[@deepakmirchandani1348]

great video mam. thanks. further , how to retrieve data from a table , if there are repeated values in a table, from different sheets.

[@myhelpdesk6414]

Awesome superb trick... thanks for share

[@LeilaGharani]

Most welcome 😊

[@abdelmalekhammouche7887]

Many Thanks Leila. I'm one of you follower. Your Tutos are easy to implement and catch. For a couple of days I' struggling to fix an Excel issue. I have a list of names (2500+) I want to sort the list by country " European, Asian, African .. Any Tips Leila. Good luck many thanks for your time.

[@mynamehero6145]

thanks. very useful. again thanks a lot

[@ashisbasak1175]

It's a great excel tricks!! Thanks Laila!!

[@LeilaGharani]

You're welcome Ashis.

[@amiradibi4000]

hello leila that was perfect . BIG LIKE .عالی بود لیلا

[@LeilaGharani]

Thanks for the like Amir :)

[@JulieRock19]

this helped me a lot... thx so much! 😘

[@mazharulalam7541]

Thanks...a lot ... It helps me much

[@antonioj.bungcagjr.6392]

Thank you very much,Leila.

[@LeilaGharani]

You're very welcome.

[@viveharc]

Thanks a lot Leila

[@akshaydalvi2317]

Thank you so much! Here is the formula =VLOOKUP($A$1,INDIRECT("'"&A2&"'!$A$1:$H$361"),7,FALSE)

[@MultiMy007]

I really appreciate mam its helps me every time with your videos and I really improved my skills in excel

[@LeilaGharani]

Thank you Syed for your support. Very happy to hear that :)

[@garyfrass]

Thank you soooooooo much for this i used this as the basis to create a more complex formula for a work order form, where as we have hundreds of part numbers then it will populate the description field and unit of measure e.g. 100 per bag or meters

[@LeilaGharani]

That's great! I'm glad to hear that. Thank you for your comment.

[@MIRZA1515]

I was working on a workbook and your tutorial came as a godsend, thank you so much. However, your alternative "Lookup" formula in your file didn't work in my workbook. Anyway, i used "Vlookup" one. Thank you again.

[@fantastipotomus]

THANK YOU!