$1300 for a required college course. $250 for a required book on Excel (& Access). Hours of lecture. I've learned more in minutes with Leila's videos than the entire semester so far.
Plus, Leila is only interested in teaching office-suite skills and doing so with effective use of time. And unlike a university, she is not trying to indoctrinate students with woke identity politics, CRT, and teaching students to hate the USA and to vote Democrat.
I really like her presentation style. After she completes something, she always goes back to show why it works !!!! Not all excel lectureres have figured this out.
This is one of those videos that I just keep coming back to every once in a while just to refresh myself on the function. Love this! Your pace is great, you aren't condescending but don't assume we don't know ANYTHING about Excel, either. Perfect balance -- What a great teacher you are. Wish I had you as a Professor in Uni.
Me too. What I tend to do is to paste a link to the videos into each of the practice spreadsheets I work on so I can instantly refer to the video instead of looking for it or searching my YT saved videos folder which is getting quite full now. Just a tip.
Been watching Leila's Excel videos for the last 3+ years and there is simply nobody better to teach the technical concepts of Excel in such an easy way. I used to marvel at upper management's ability to do complex spreadsheets and I learned to beat them out in just a year of watching her vids.
To be honest, this is the only video that was able to explain to me these nested fonctions (Index and Match). Incredible Leila, I don't regret anything about the lessons I'm taking with you. Great thanks to simplifying easily complicate things.
I’ve taken excel courses and was always thinking I understood index and match but when I went to do it by myself I would always get issues. I’m not sure if it’s this video or another one by you but you explained it in just the right way that it clicked. I am now using it all the time. Thank you.
OMG thank you. I just got back to working in an office after 10 years away. I was great with Excel back in the day but if you don't use it, you lose it. I will be tuning in regularly. You may have saved my bacon. If you are from Canada, coffees are on me LOL.
@@BeastmanG I was in Network Security back in the day but entered the field of Global Supply Chain Management and Logistics. I spent quite a bit of time in Southeast Asia and China.
OMG- Seriously- I have been pulling my hair out trying to figure out how to do data cleaning and this formula worked!! I have been watching COUNTLESS videos for HOURS and YOURS was the first to actually explain this so well that I could actually use it. Thank you so so much. SUBSCRIBE!
I have been stuck on my homework for hours rereading my chapter and redoing the exercises. Your video was the first to pop up when i googled Index and Match and I am so happy I clicked on it. You explained it so well. It helped me immediately make progress! thank you so much for helping me :)
I was studying for the MOS 2019 Excel Expert exam and decided to skip the Index and Match functions because of their complexity (imbedding, etc.). But, I watched this video for the fun of it. Guess what? Index and Match were on the exam I took and I passed! There were some other challenging parts but Index/Match is a new friend. Thank you, Leila!
OMG finally someone who has explained this properly!!! till today, i did not understand how index worked and what was key to ensuring it does. Thank you
I was always afraid of index -match function.. instead i used vlookup.. now this video helps me a lot.. I would like to thank u for teaching us the most complicated issues with easier way...Lots of Thanks..
Thanks, Leila for simplifying it and giving logical explanation at each step. Actually applied the Index-Match formula and saved myself hours of useless work. Never gonna forget it.
Love the map and coordinates analogy. That helps very much. Now perhaps when I'm in a hurry to do a vlookup real quick, I'll be more comfortable with the better index/match solution. Totally agree, you just need to force yourself to practice using it until it's comfortable.
I just watched multiple videos, but not a single one could make me clear enough. Its YOU!!! I love your calm voice and so detailed teaching method. All the best for your channel
I am now a Index Match fan, going to forget Vlookups which has been a loyal and dependable function in excel for years. Thanks Leila, very simple way to explain Index Match
You Leila, you are just one hell of a teacher, oh my! in you I have always found solutions to my problems. Your language is pretty clear...I think even grade 2 kenyan student will understand you! amazing
Well done! I had come to youtube in the past to learn index/match, but quickly struggled to recall the syntax of these functions. But while watching your video, I experienced that ah ha moment and was able to with relative ease to immediately apply what I learned to one of my spreadsheets (I could hear your voice in my head asking the question). The way you set the stage, explained and demonstrated how it's done was perfect for my style of learning. Thank you!!
I've been trying to properly learn INDEX MATCH for weeks just reading about it, unsuccessfully. Now it only took me this video of yours to get it! Thank you so much Leila!
This is great, I've been a VLOOKUP obsessive to the point that I drag columns around to suit...I avoided INDEX & MATCH because I felt it was too confusing. After this, I'm determined to master it. Thank you.
I am a big fan of yours. All the videos are very informative. I started using excel in my work more efficiently than before just because of you. And you look gorgeous.
Leila, you are a brilliant teacher! Thank you so much for this video. In 11 minutes I understood and am able to apply this information in a real life situation that I have been working on for quite a while.
Thank you so much Leila for teaching me Index Match in such nice manner & way. It was taking a long time to complete any look up issue with the V Look UP and now I have started to believe that this formula will surely save a lot of time. Thanks again. You have been very popular for your teaching style. May you continue to teach us in this fantastic way...Amlan.
Always used to avoid index match by pasting duplicate column to the right to use vlookup, but this video explains index match in a way that has given me confidence to use it now
You are good Leila. Clear, easy to follow, focused on the right things with the right amount of elaboration in order to get both the big picture and the details. Thank you-
Thank you Leila for this lesson. For long I have been dodging Index and Match until today when someone had a complex issue that I picked interest in solving
Thank you for your simple, clear, step by step teaching. Your videos are perfectly balance: the information transmitted by the image and the voice, the tips insertion. It is a pleasure to learn with you and also a way to learn how to teach.
لیلا عزیز. خیلی ممنونم از فیلمهای آموزشی شما. این فیلمها برای یاد گرفتن آفیس به خصوص اکسل برای من خیلی کمک کننده بود. امیدوارم مانند همیشه در این مسیر موفق باشی
Amazing videos, i have learnt a lot of excel in the last few days than i ever have previously, u r an amazing teacher, never imagined excel can be easy to understand! Thanks a million!
Love you teacher and thank you very much for your generous contributions and I have learned a lot from your lessons even within 2 days of exploring your tutorials. I am sure that I will definitely benefit from your lessons therefore, I hope receiving your new lessons in the future as well. I will stay tuned to your new lessons:)
Wow, I was stuck on this for a couple of hours. I watched a few other videos before I found this one and kept getting errors. This is the first video that explained how this works in language I could follow easily. Thank you!!!
You're best Miss @Leila. I was doing a course on Udacity and part of that there is a project to analyze S&P 500 Data. I was stuck in the middle of the project and feeling frustrated. You saved my day. Thank you so much. :)
I love the RUclips Commercials for schooling- "Would you like to master Excel?" ... lol... Well yes - and once this annoying commercial ends I'll get on with my training :-) Thank you Ms Leila!
I love using this rather than VLOOKUP but I never thought about the analogy of GPS that you used to simplify the mechanics of INDEX-MATCH. Thanks, Leila! 🤓🥰
Great video. The explanation was awesome. I loved the part where you used the example of the map and GPS. Maybe you can try the indirect function to make the range of the Revenue and Profit change more dynamic.
I have tried it out and it shortens the formula and makes it faster. I named the ranges to Revenue and Profit and then modified the formula to this and it works great. =INDEX(INDIRECT(G9),MATCH(H5,B6:B15,0))
Thank you so much! Your explanation is very easy to follow and understand. I am a recent grad and will be working next week! It is my first real job and my manager advised me to learn how to use index and match. The other videos and explanations that I looked up were so complicated and hard to understand until I found you! I also watched your other videos and downloaded your workbooks for practice as well. Very helpful! thank you!
i dunno what impresses me the most.....Her beauty? Her Excel skills? Her ability to teach? Such a pity I'm too dumb to remember anything she teaches, it's like trying to learn Chinese.
THANK YOU SO MUCH.. I just finshed laborious work of probably 10 hours in twenty minutes.. Not to mention the time I will save in the future by learning this. I highly appreciate your tutorial .. Cheers :)
I see more harassment than usual on this particular vid. Anyway, for years I've kinda half paid attention every time I tried to learn about INDEX and MATCH. Great explanation... finally got it.
The harassment on this channel is gross. If you creeps have anything to say about her looks or are compelled to make sexual compliments, keep it to yourself, sickos!
YES!!! You couldn't have made it any easier to understand if you drew it out in crayon. I just tried it out for the first time using it instead of the vlookup, which would have worked anyway, and now I'm a new convert. I like that it does not require ascending order, making it even easier to use than vlookup. No more having to organize the "map" before doing a query. YAY! ... subscribed
Hi leila mam, the way you understand each syntax of each function and also results of such functions is versatile and very febulous. I have no words that how to i thanks you. Its really very superb. Thank you very much 👌👌👌👌👍👍💐
No new words to say. The comment section is already blown up with all wonderful wishes. Hi from Chennai, India. Can you please share the link for that second part of this video? Lots of love. ❤️
Hello mam, I would just like to say that I love the approach you take in explaining the topic, you just dive in with the simplest of the words and do it thoroughly, unlike many others who like to crack jokes, don't explain fully or make it even more complicated, please keep up the good work.
I love to watch her way of and content of teaching. I got an interest in learning Excel from her guidance in every possible way.Thank you ,God bless you.
I've been using combination VLOOKUP and HLOOKUP to pull from a table of values as needed, but this is SO much easier, and more versatile than either HLOOKUP or VLOOKUP. Thanks so much!!
Superb explanation. I got this perfectly only by watching this Video. It's very clear and easy to understand. It's really appreciated and thank you vey much Ms. Gharani.
This randomly showed up in my recommendations and now i've fallen in love. Been working over a decade as an accountant and generally considered as an expert in excel but this wonderful woman shows me things i've never seen before
Grab the file I used in the video from here 👉 pages.xelplus.com/index-match-basics
do you have a beginners course?
@MiguelAlvarezAdams We do, check it out here: www.xelplus.com/course/learn-excel-essentials/
$1300 for a required college course. $250 for a required book on Excel (& Access). Hours of lecture. I've learned more in minutes with Leila's videos than the entire semester so far.
Thank you Marcus. I'm very happy to hear that!
Am telling u
Nice joke
Plus, Leila is only interested in teaching office-suite skills and doing so with effective use of time. And unlike a university, she is not trying to indoctrinate students with woke identity politics, CRT, and teaching students to hate the USA and to vote Democrat.
And where you are going to apply what you learn 🤔
I really like her presentation style. After she completes something, she always goes back to show why it works !!!! Not all excel lectureres have figured this out.
This is one of those videos that I just keep coming back to every once in a while just to refresh myself on the function. Love this! Your pace is great, you aren't condescending but don't assume we don't know ANYTHING about Excel, either. Perfect balance -- What a great teacher you are. Wish I had you as a Professor in Uni.
Me too. What I tend to do is to paste a link to the videos into each of the practice spreadsheets I work on so I can instantly refer to the video instead of looking for it or searching my YT saved videos folder which is getting quite full now. Just a tip.
@@ianl1052 great idea! Thanks!
Been watching Leila's Excel videos for the last 3+ years and there is simply nobody better to teach the technical concepts of Excel in such an easy way. I used to marvel at upper management's ability to do complex spreadsheets and I learned to beat them out in just a year of watching her vids.
You must try Excel Chandoo 👍 thank me later
I wish more people would showcase and explain individual functions on their own when making tutorials on combined functions. Very informative.
I've searched and read so many help articles on Index and Match. I finally get it with this clear, concise explanation and demonstration. Thank you!
To be honest, this is the only video that was able to explain to me these nested fonctions (Index and Match). Incredible Leila, I don't regret anything about the lessons I'm taking with you. Great thanks to simplifying easily complicate things.
I'm not a regular Excel user yet I find these explanations so clear and easy to follow. Brilliant!
I like the speed of your videos. You don't go too fast or too slow. It's a good speed.
Not only the speed, it is also the way how she teaches. She is just great!
I’ve taken excel courses and was always thinking I understood index and match but when I went to do it by myself I would always get issues. I’m not sure if it’s this video or another one by you but you explained it in just the right way that it clicked. I am now using it all the time. Thank you.
OMG thank you. I just got back to working in an office after 10 years away. I was great with Excel back in the day but if you don't use it, you lose it. I will be tuning in regularly. You may have saved my bacon. If you are from Canada, coffees are on me LOL.
How’s it going?, been on the job a year after your time off
How is the selec app "misty wash created? Index?
Ek 0
What were you focused on in those 10 years if you don't mind me asking?
@@BeastmanG I was in Network Security back in the day but entered the field of Global Supply Chain Management and Logistics. I spent quite a bit of time in Southeast Asia and China.
I'm so thankful to you! Your voice is so calming and patient and I don't feel too bad when I cannot follow it! I just rewatch it.
Great explaination! No one has enough patience to teach me this clearly.
OMG- Seriously- I have been pulling my hair out trying to figure out how to do data cleaning and this formula worked!! I have been watching COUNTLESS videos for HOURS and YOURS was the first to actually explain this so well that I could actually use it. Thank you so so much. SUBSCRIBE!
That's great! I'm happy the tutorial is helpful.
I have been stuck on my homework for hours rereading my chapter and redoing the exercises. Your video was the first to pop up when i googled Index and Match and I am so happy I clicked on it. You explained it so well. It helped me immediately make progress! thank you so much for helping me :)
I was studying for the MOS 2019 Excel Expert exam and decided to skip the Index and Match functions because of their complexity (imbedding, etc.). But, I watched this video for the fun of it. Guess what? Index and Match were on the exam I took and I passed! There were some other challenging parts but Index/Match is a new friend. Thank you, Leila!
That's great Tom. Congratulations!
What a wonderfully easy to follow lesson! This really helped me finally learn this function combination. Thank you!
She is talented From somalia
OMG finally someone who has explained this properly!!! till today, i did not understand how index worked and what was key to ensuring it does. Thank you
This is amazing. I just started a new job this week and I never used Index and match before. This helped me out a ton. Thanks
I was always afraid of index -match function.. instead i used vlookup.. now this video helps me a lot.. I would like to thank u for teaching us the most complicated issues with easier way...Lots of Thanks..
Glad to help. You may want to also check out the brandnew XLOOKUP. Beats even Index & Match.
Thanks, Leila for simplifying it and giving logical explanation at each step. Actually applied the Index-Match formula and saved myself hours of useless work. Never gonna forget it.
I have looked at 5 different articles trying to explain this concept to no avail and you just laid it all out perfectly, thank you so much!!
That's great. I'm glad the video was helpful.
Love the map and coordinates analogy. That helps very much. Now perhaps when I'm in a hurry to do a vlookup real quick, I'll be more comfortable with the better index/match solution. Totally agree, you just need to force yourself to practice using it until it's comfortable.
I'm glad you find it easy to understand. That's what made it click for me :) Let me know how it goes.
I just watched multiple videos, but not a single one could make me clear enough. Its YOU!!! I love your calm voice and so detailed teaching method. All the best for your channel
Wow, thank you!
I am now a Index Match fan, going to forget Vlookups which has been a loyal and dependable function in excel for years. Thanks Leila, very simple way to explain Index Match
Sounds like a plan :)
You Leila, you are just one hell of a teacher, oh my! in you I have always found solutions to my problems. Your language is pretty clear...I think even grade 2 kenyan student will understand you! amazing
Excellent. Describing it as GPS coordinates and the range as the map really helped. Good way to think about it.
Well done! I had come to youtube in the past to learn index/match, but quickly struggled to recall the syntax of these functions. But while watching your video, I experienced that ah ha moment and was able to with relative ease to immediately apply what I learned to one of my spreadsheets (I could hear your voice in my head asking the question). The way you set the stage, explained and demonstrated how it's done was perfect for my style of learning. Thank you!!
Many thanks for the kind feedback. I really appreciate it.
You have saved me at my job multiple times, thank you for being a force for tech women in the making :)
Us women have to stick together :) Glad the tutorials are helpful for you.
@@LeilaGharani 9oowi2
@@LeilaGharani pposo
C2
@@LeilaGharani klooooooooiiw
I've been trying to properly learn INDEX MATCH for weeks just reading about it, unsuccessfully. Now it only took me this video of yours to get it! Thank you so much Leila!
Glad it helped!
This is great, I've been a VLOOKUP obsessive to the point that I drag columns around to suit...I avoided INDEX & MATCH because I felt it was too confusing. After this, I'm determined to master it. Thank you.
Me tooooo. I will start tomorrow!!
I am a big fan of yours. All the videos are very informative. I started using excel in my work more efficiently than before just because of you. And you look gorgeous.
Leila, you are a brilliant teacher! Thank you so much for this video. In 11 minutes I understood and am able to apply this information in a real life situation that I have been working on for quite a while.
Thank you so much Leila for teaching me Index Match in such nice manner & way. It was taking a long time to complete any look up issue with the V Look UP and now I have started to believe that this formula will surely save a lot of time. Thanks again. You have been very popular for your teaching style. May you continue to teach us in this fantastic way...Amlan.
I'm a big fan of Index Match. Glad you find the video helpful Amlan.
Beauty with BRAINS!! Thank you so much for explaining this!
Always used to avoid index match by pasting duplicate column to the right to use vlookup, but this video explains index match in a way that has given me confidence to use it now
Leila, You are awesome. I fell in love with your teaching style. So easy and meaningful. God Bless you!
Bet thats not all you fell in love with
Thanks Madam, No body else could have explained this much better, please continue to share knowledge like this.
Hello Leila, You teach me the functions in very smart way: simple and easy to understand. thanks a lot.
Ive used this video so many times i purchased your course because of the value you offered. Thanks again for the knowledge.
Great to hear, Josh!
Thanks in a million. This is badly needed. Second to none. Grade: A++
You are good Leila. Clear, easy to follow, focused on the right things with the right amount of elaboration in order to get both the big picture and the details. Thank you-
Thank you for the kind feedback Michael!
This is the best explanation of INDEX MATCH I've found. This made it easier to understand and implement. Thanks!
Wow, explaining array as GPS is pure genius!
i love the analogy GPS and map~ now you have one new subscriber. Thank you for the video
Thank you Leila for this lesson. For long I have been dodging Index and Match until today when someone had a complex issue that I picked interest in solving
Thank you for your simple, clear, step by step teaching. Your videos are perfectly balance: the information transmitted by the image and the voice, the tips insertion. It is a pleasure to learn with you and also a way to learn how to teach.
لیلا عزیز. خیلی ممنونم از فیلمهای آموزشی شما. این فیلمها برای یاد گرفتن آفیس به خصوص اکسل برای من خیلی کمک کننده بود. امیدوارم مانند همیشه در این مسیر موفق باشی
Finally i found My excel Teacher....Thank u leila.. :)
*Only 18* 👇👇👇
746428.loveisreal.ru
Amazing videos, i have learnt a lot of excel in the last few days than i ever have previously, u r an amazing teacher, never imagined excel can be easy to understand! Thanks a million!
I too was a vlookup fan until I learned this.
I have never cees following you. You inspire and motivate me. You are such wonderful teacher. Keep the ball rolling. Welcome to Tanzania.
Love you teacher and thank you very much for your generous contributions and I have learned a lot from your lessons even within 2 days of exploring your tutorials. I am sure that I will definitely benefit from your lessons therefore, I hope receiving your new lessons in the future as well. I will stay tuned to your new lessons:)
Wow, I was stuck on this for a couple of hours. I watched a few other videos before I found this one and kept getting errors. This is the first video that explained how this works in language I could follow easily. Thank you!!!
i wonder, why u just got 700K subscribers. ur content is priceless.
You're best Miss @Leila. I was doing a course on Udacity and part of that there is a project to analyze S&P 500 Data. I was stuck in the middle of the project and feeling frustrated. You saved my day. Thank you so much. :)
Glad it was helpful!
I love the RUclips Commercials for schooling- "Would you like to master Excel?" ... lol... Well yes - and once this annoying commercial ends I'll get on with my training :-)
Thank you Ms Leila!
OMG, where have you been my entire life? This was an absolute lifesaver!!!
outstanding way to explain!
Yeah! Agreed
I love using this rather than VLOOKUP but I never thought about the analogy of GPS that you used to simplify the mechanics of INDEX-MATCH. Thanks, Leila! 🤓🥰
You're very welcome, Reynaldo!
Thank you so much Leila for responding syntax for Date function , Really, Your teaching technique is very good & simple, so you are best lecturer.
Sure. You're very welcome & thank you for the compliment.
Very well explained. Always used lookups out of habit and never bothered to look at a vid like this. Glad I did thanks.
Great video. The explanation was awesome. I loved the part where you used the example of the map and GPS. Maybe you can try the indirect function to make the range of the Revenue and Profit change more dynamic.
I have tried it out and it shortens the formula and makes it faster. I named the ranges to Revenue and Profit and then modified the formula to this and it works great.
=INDEX(INDIRECT(G9),MATCH(H5,B6:B15,0))
Great! That's a nice twist! Thanks for sharing.
Thank you so much! Your explanation is very easy to follow and understand. I am a recent grad and will be working next week! It is my first real job and my manager advised me to learn how to use index and match. The other videos and explanations that I looked up were so complicated and hard to understand until I found you! I also watched your other videos and downloaded your workbooks for practice as well. Very helpful! thank you!
Glad it was helpful!
Thank you! It helped me a lot with my assignment
This is one of the best index match tutorials i have ever seen. Thanks!
i dunno what impresses me the most.....Her beauty? Her Excel skills? Her ability to teach?
Such a pity I'm too dumb to remember anything she teaches, it's like trying to learn Chinese.
THANK YOU SO MUCH..
I just finshed laborious work of probably 10 hours in twenty minutes.. Not to mention the time I will save in the future by learning this. I highly appreciate your tutorial .. Cheers :)
Great job! Glad the tutorial was helpful.
hey ma'am ur have a sharp brain. i love your trick
speed studied five minutes before my excel exam and this video is the reason why i passed, youre a blessing
I see more harassment than usual on this particular vid. Anyway, for years I've kinda half paid attention every time I tried to learn about INDEX and MATCH. Great explanation... finally got it.
I agree. Leila is a very talented and professional presenter. She deserves more respect than she gets from some of the viewers.
This help you more ruclips.net/video/wOKH-wtsP6E/видео.html
The harassment on this channel is gross. If you creeps have anything to say about her looks or are compelled to make sexual compliments, keep it to yourself, sickos!
YES!!! You couldn't have made it any easier to understand if you drew it out in crayon. I just tried it out for the first time using it instead of the vlookup, which would have worked anyway, and now I'm a new convert. I like that it does not require ascending order, making it even easier to use than vlookup. No more having to organize the "map" before doing a query. YAY! ... subscribed
Extremely good explanation....No one can do it better than u madam...
Leila, you are great lecturer good in communication techniques and clear in step by step illustration.
Wow, this is awesome! I do work with very large datasets sometimes and had faced the LOOKUP issues you've mentioned.
Thank you so much!!!
Excellent transformation of applied knowledge
excellent explanation. i have been trying to understand how to use match and index since 12 years and i got it now with your video. thanks a ton
Best turorial for the Index&Match - I have seen quite a few before I saw yours @Leila Gharani. You explain it perfectly. Many thanks!!
I'm glad the video is helpful.
به اینکه اکسل رو از یه ایرانی یاد میگیرم و بهترین استاد در کل دنیاس افتخار میکنم🤩
موفق و سلامت باشید 🙏
You are awesome - thank you, everyone else throws complex formulae without explaining what each item does. Makes troubleshooting tough. Thanks much!!
You are so welcome, Mike!
You are one of the best teachers of excel Leila.
Thanks for your views always helpful.
Hi leila mam, the way you understand each syntax of each function and also results of such functions is versatile and very febulous. I have no words that how to i thanks you. Its really very superb.
Thank you very much 👌👌👌👌👍👍💐
No new words to say. The comment section is already blown up with all wonderful wishes.
Hi from Chennai, India.
Can you please share the link for that second part of this video?
Lots of love. ❤️
EXCELent video!😊 That is the first time I fully understood INDEX and MATCH. You have a gift!!
I am using excel since 2000 but i didn't get a lot from previous experience. But your videos make me expert in excel.
Hi Leila, you are really the best PRO in simplifying and explaining rather complicated formulas. I really adore your approach!
Thank you so much, Philippe!
Hello mam, I would just like to say that I love the approach you take in explaining the topic, you just dive in with the simplest of the words and do it thoroughly, unlike many others who like to crack jokes, don't explain fully or make it even more complicated, please keep up the good work.
Many thanks for the kind feedback. I really appreciate it.
OMG! I've got it! Thank you, Thank you, Thank you! Plus with the added bonus of a beautiful teacher.
YAY! Wonderful!
This is definitely one of the best lecture on Index & Match.
SkiskiiSoiiiidkwkwiwiwiiwioo
I love to watch her way of and content of teaching. I got an interest in learning Excel from her guidance in every possible way.Thank you ,God bless you.
Leila its amazing what you do for this community! Thank you
I've been using combination VLOOKUP and HLOOKUP to pull from a table of values as needed, but this is SO much easier, and more versatile than either HLOOKUP or VLOOKUP. Thanks so much!!
Your explanation is really good, easily understandable
Your excel videos have helped me advance in my career! Thank you!
Great to hear!
OMG this explanation indepth is amazing! Im a data science student and index match was my first confusion taking excel course. U helped me out!
You're very welcome!
Superb explanation. I got this perfectly only by watching this Video. It's very clear and easy to understand. It's really appreciated and thank you vey much Ms. Gharani.
Glad it helped!
This randomly showed up in my recommendations and now i've fallen in love.
Been working over a decade as an accountant and generally considered as an expert in excel but this wonderful woman shows me things i've never seen before
Well Michael, I'm glad you're here now. Hope you will like the other tutorials too.
@@LeilaGharani liked and subscribed. already watched a few other videos and really learning a lot. you're amazing
thank you so much for well put explanation. I watched many videos on index function but yours really takes the cake.
This is very helpful, and I really like the way you explain things making it easier for audience to absorb what you're teaching. Thank you!