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
@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.
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!!!
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.
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.😊
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.
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!
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.
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
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.
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
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?
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.
I don't know if CZcams now, besides hearing what I talk, also learned to reading my mind... Anyway, this video is exactly what I was looking for, thanks!
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
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!
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 😇😇😇😇😇😇
hello Leila, thank you so much for your videos I learn more with each one of them! I have a question for anyone who comes across this and can help :), so the first part of the quetsion is: what if we have dependant drop down lists (Thank you Leila for those two videos btw) and want to extract information from the table linked to those two drop down lists? the second part of the question is: how can we extract ifnormation from a table on the same sheet but from different arrays, considering the informations, that we want to retrieve, as the divisions used in the video above? thank you
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.
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.
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.
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.
Many thanks for great tutorial. 8) maybe some next level Q: searching for specific value (or text data) in same workbook, but not knowing exact (sheet) location ? .. all sheets have same column structure but different row numbers .. unique value is located in (just) one sheet in (known) column, but unknow sheet.
Grab the file I used in the video from here 👉 pages.xelplus.com/lookup-different-sheets
I feel like a kid watching Wayne Gretzky play ice hockey. This level of Excel knowledge borders on witchcraft. Really impressive, Leila!
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
@Arturo Steven instablaster :)
@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.
@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!
@Arturo Steven you are welcome :D
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!!!
Awesome, thank you Stéphane!
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.
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.
Glad to hear it was helpful!
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.😊
have re-winded the video couple of times to fully understand the concept..but every second worth it. thanks
You helped me solve an excel problem that I've been stuck on for 3 days. Thank youuu!! Subscribed.
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.
Wow, thank you very much!
Everytime I hear this girl say "Today, I am gonna show you..." I get the shivers!
😂😂
Thank you very much Leila...You will be remembered😌😌
Leila - the session is incredibly supportive. Thank you for that one! :) I appreciate it.
Dear Leila your class were excellent. And I like your videos they are clear and effective. 👌👌
Thank you! 😃
I am blown away Excel has a lot to offer!
Leila you are really a natural talent kid. love from Bangladesh.
Mam, I become your fan. Best Excel Teacher. Always Thumbs up & always my support to you.
Wow, thank you!
great... its very easy to understand the way you are explaining complex things in simple way..
I got another work to do ,extend this same process for sheets from another file. Reply and solution awaited. Thank u
One of the best tutorial I have ever seen. Your videos are loaded with learning
Wow, thanks!
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.
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
You are queen of excel dear, being punjabi understanding with such accent seems difficult🤣😅but by just following your syntax it made it simple
Very very thanks
currently pulling my hair out trying to figure out a solution. But your videos make my life much easier. Thank you.
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!
You're very welcome Cassandra!
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!
I hope you will Andrew. Glad the video was helpful.
Thanks a lot Leila
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.
excellent and crystal clear explanation, many thanks for sharing.
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
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😍
Thank you! 😃
thank you very much Leila for sharing your skills.
So much clarity the way you teach.....truly appreciate it.
Thank you Ankita! Glad you like the videos :)
Thank you Ankita! Glad you like the videos :)
Thank you Leila !
You provide us a very useful way to extract data from multiple worksheets.
You're welcome Chaminda.
You have helped me countless times! Thank you so much for all your videos.
Outstanding explanation. Thankyou very much it really solved my problems
informative video!! for those who wants to upgrade level from medium to advanced!! thanks for sharing!! :)
Thanks! Glad you like it!
Great video Leila , honestly you explained greattt!!! my very big problem is solvedddddddddd............... thanks a lotttttt to you.
That's great to hear, Saffi!
Thank you so much! Here is the formula =VLOOKUP($A$1,INDIRECT("'"&A2&"'!$A$1:$H$361"),7,FALSE)
Thank you, have helped me consolidated data from multiple sheet. Gratitude.
Great video : ) Such a useful set of tricks!
Thank you Mike : )
I totally agree mike... this was a good one with vlookup and indirect.... very useful. Thanks @leila
You're welcome Mammen. Thank you for the support.
ExcelIsFun .Hi mam I jeet from india, mam your teaching method is very easy and helpful for us I watch your all videos
Saw this video a couple days ago and used it a today!
Such a powerful Indirect feature and even greater your explanation
It was a difficult one to explain. I'm glad you find it easy to follow :)
your video is so helpful for me, thanks
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.
So much clarity in your presentation. Thank you Leila.I have been looking for something like this for a long time.
This saved me a ton of time in which I have to summarize a dozen sheets!
Thank you so much Prof!
You're very welcome!
Your approach to build up functions is excellent, good job👍🏻👍🏻
Thanks! 😃
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
That's great! I'm glad to hear that. Thank you for your comment.
Thanks. Indirect reference for sheet names was very helpful.
Love this!
Thanks Leila. Well done.
This is sooo helpful, thanks for these tips! The INDEX(INDIRECT really helped me!
My god what a great command on Excel function, first time I ever seen on CZcams videos like your video. So good thanks a lot.
Thank you Anubhav! I'm very happy to hear you like the video and find the content useful.
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?
Thanks Fahad. Glad you like the videos. Anything specific in Excel you're looking for regarding correlations with scatter plot?
Great Video. Thank you so much.
THANK YOU LEILA!!!
Speechless... Incredible skills.
Thank you so much 😀
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.
You're very welcome Gopala and thank you very much for the kind words. I am very glad you find the videos beneficial.
I don't know if CZcams now, besides hearing what I talk, also learned to reading my mind... Anyway, this video is exactly what I was looking for, thanks!
Thank you, Leila!
That's the most useful explanation that I've ever found! You're doing a great job!
Thanks Anna! Glad you like it :)
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
Thank you Michael :)
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!
THANK YOU!
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
😇😇😇😇😇😇
yes indeed! , one of the best; I faced the same problem; now I have a solution ...and it works!!! :)
I'm very glad to hear that :)
Thank You very much Leila 😊
You did a wondefuljob and it helped me alot and i have subscribed today from india🏆👏
Thanks for subbing!
Excellent trick. Thank you very much Leila.
My pleasure. Glad you like it.
Thanks...a lot ...
It helps me much
thanks. very useful. again thanks a lot
this helped me a lot... thx so much! 😘
Perfect function explanation, cadence, audio/video quality. New subber here!! Thank you very muh.
Thanks for the sub!
U Explained this kind of topic in very lucid way....!!! Amazing 😊
thankuu very very much... 😘
You're very welcome. Glad you like the video.
hello Leila, thank you so much for your videos I learn more with each one of them!
I have a question for anyone who comes across this and can help :), so the first part of the quetsion is: what if we have dependant drop down lists (Thank you Leila for those two videos btw) and want to extract information from the table linked to those two drop down lists?
the second part of the question is: how can we extract ifnormation from a table on the same sheet but from different arrays, considering the informations, that we want to retrieve, as the divisions used in the video above?
thank you
Thank you Leila! I really like the way you use functions most out of it...😃
You're welcome Santosh.
Great Video, I was searching for a formula like this for many days. Thanks!
Glad it was helpful!
Hi Leila, excellent Video, you made my day 🙂
Thanks a lot!!
Awesome explanations .....of each formula....I love the way you describe the formulas...👌
Thank you Manisha. I'm glad you find the explanation easy to follow.
I really appreciate mam its helps me every time with your videos and I really improved my skills in excel
Thank you Syed for your support. Very happy to hear that :)
Realy enjoying your classes.
I'm glad you like the videos.
Thank you! This video helped me solve a problem that had been driving me nuts!
I just would like to say thank you. I’ve learnt a lot from your channel.
Happy to hear that!
Awesome superb trick... thanks for share
Most welcome 😊
Brilliant.. THANKS.
Had to watch this a few times :-)
Thanks for the video for clear information on vlookup
You're very welcome.
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.
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.
great video mam. thanks.
further , how to retrieve data from a table , if there are repeated values in a table, from different sheets.
this was a lifesaver. Thank you!
Glad it helped!
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?
Thank you very much,Leila.
You're very welcome.
Hello. Thank you so much.:)
holy sh*t !!!!!!! I almost got it !!!!! Lets see it again !!!!! 👋👋👋
Nice Mam
Exactly what i need now, and I remember watching this here~
Thanks a lot, Leila!
Glad this came in handy :)
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.
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.
Power Query , or are you looking an an ODBC link ??
Hello Leila, nice video! g reat sharing... learned a lot from this
You are excellent and genius , Nice tricks
Many thanks for great tutorial. 8)
maybe some next level Q: searching for specific value (or text data) in same workbook, but not knowing exact (sheet) location ?
.. all sheets have same column structure but different row numbers .. unique value is located in (just) one sheet in (known) column, but unknow sheet.
Here probably a VBA routine would be much more efficient....