Grab the file I used in the video from here 👉 pages.xelplus.com/index-match-advanced-file
@bobgreenfield9158
3 ай бұрын
I am watching on my phone. I have trouble seeing the equations.
@GordonWafimbi
5 жыл бұрын
That extra index within the match to avoid CSE is genius, thank you,... Really learning from you channel! Keep it up.
@whimpypatrol5503
2 жыл бұрын
That extra index within the match to avoid CSE is apparently no longer necessary with EXCEL 360 since C20:F20&C21:F21 = INDEX(C20:F20&C21:F21,0)
@excelisfun
7 жыл бұрын
Awesome INDEX video!!! It a great solution that so many business people encounter!
@LeilaGharani
7 жыл бұрын
Thanks Mike. Very true! I get this question all the time....
@odeseusX
6 жыл бұрын
Leila & Mike, discovering both your channels has been an absolute revelation for me!
@marvinreyes7459
5 жыл бұрын
You Do Some Awesome explanations too Man and I love how you speak :D
@livinindubai
5 жыл бұрын
2 of my favorite excel gurus 😃
@vishugupta250
5 жыл бұрын
Two genius at one place... 😘😘
@Waydisturbed
4 жыл бұрын
The Excel Goddess! No matter what crazy scenario in which I find myself, Leila Gharani has the answer!
@LeilaGharani
4 жыл бұрын
😘
@matthewrichmond1542
6 жыл бұрын
I finally get it!! After all these years getting frustrated with lookups this is going to be so helpful. Thank you for your amazing videos
@LeilaGharani
6 жыл бұрын
YES! YES! I'm very happy to hear that :)
@UlyssesHaq
6 жыл бұрын
My mind is blown away by the beauty and simplicity of these insanely complex formulas. Your method is very helpful. Thank you!
@rafakiyo
2 жыл бұрын
Impressive how Leila saved my life so many times!!! hehehe Everytime when I have a problem I will check if my Guardian angel can help me.... most of the times she can! 😇🥰 Thank you!!
@ArshadAli07.kapilvastu
4 жыл бұрын
Your clarity in excel is amazing. The way you have explained it here is unmatchable. Keep it up.
@Ofageover50
4 жыл бұрын
These are the best tutorials I've found anywhere!!!
@wasabi4u724
6 ай бұрын
I watched the prior INDEX/MATCH video, and moved on to this one. This really fits my needs as an engineer with tons of data to evaluate or look up from a 2D data array with thousands of rows/columns. (raw data in CSV format, imported into Excel for the ease of eyes) THANK YOU!
@LeilaGharani
6 ай бұрын
Glad it was helpful!
@madanmohanverma9799
4 жыл бұрын
The concept of index and match is now clear ...what a simple and effective way of presenting, not only for this function but for every function she narrates !!! Excellent !!
@LeilaGharani
4 жыл бұрын
I'm happy to hear that. Thanks for the feedback.
@mannymtzgomez
4 жыл бұрын
Thank you Leila! It really help me getting a quick data from a Table (7728 Cells - 112 Rows - 69 Columns) in a single table using the List and both options you taught in this video. Now i can get the data from any row/column combination i need with a few clicks.
@markchristmas4465
3 жыл бұрын
Thank you for this helpful video! The way you explain excel is so much easier to comprehend than other instructors.
@CEOako
4 ай бұрын
This is the reason why I loved index match function.
@walterjamesagorilla803
2 жыл бұрын
I recommend your channel to my friends who are heavily relying in excel functions to transform data and they find your video tutorials very useful.
@stephen3149
7 жыл бұрын
Great teaching style! Wonderful format with great examples You break formula's down and explain them step by step. Well done thanks. Great learning video, series thanks
@LeilaGharani
7 жыл бұрын
You're very welcome Stephen. Glad to hear that.
@architpanda7880
4 жыл бұрын
Wow!!! scratched my head out for an entire day, until I found this genius solution. You're the best
@LeilaGharani
4 жыл бұрын
Glad it helped!
@kbalaji9516
4 жыл бұрын
super.. am going to user index & match hereafter, so many years i was doing things in lookups. Thank you.. for such a learning videos..
@ScottM-y9i
Ай бұрын
Thank you @LeilaGharani for all that you do! Solution #3 was perfect for my challenge. I appreciate your methodical step by step explanation in all of your videos, you are great!
@thekingofkush4447
3 жыл бұрын
Thank you for making this quick and easy. This video was so good, I wish I found this years ago! YOU are good at explaining the logic and steps. You've got a new excel formula nerd fan!
@philipmcdonnell7168
6 жыл бұрын
Two minutes in and I had the answer to the question that had been bugging me for hours! I had transposed the Index and Match ranges so it was returning and N/A. So clear. Thanks. 👍🏻😎
@faYte0607
7 жыл бұрын
Hi Leila, I stumbled upon your videos by random and love that your videos are high quality and very elegantly created compared to other Excel videos. I hope you continue to make great videos on Excel with emphasis on functions that'll be helpful for a marketing or finance person :)
@LeilaGharani
7 жыл бұрын
Happy to hear that :) Sure - will do my best. Let me know if there is anything specific you're looking for and I'll gladly add to my list.
@carolcoulter342
5 жыл бұрын
You are the absolute best teacher of complex excel functions ever!
@LeilaGharani
5 жыл бұрын
Thanks for the kind words Carol!
@johnt9186
Ай бұрын
These are some of the best tutorials I've seen!!
@ratneshbansal5139
4 жыл бұрын
Immense respect! As a teacher, you foresee what kind of problems a pupil could encounter and give a solution for that! Simply amazing! I have a question though, how could we apply index & match to an array (taking data from an array and putting answers on an array) using CSE! I could work it around by using additional index within match but otherwise with CSE it ceases to be dynamic on the match argument!
@brianchoong7392
5 жыл бұрын
This is genius! Thank you, I’ve been looking for this answer for more than 6 hours trying to figure out how to combine data from 2 rows with the info from the same account into 1 line row. Eg: John | Revenue from Fish: | $200 John | Cost of Fish: | $50 John | Revenue from Fish: $200 | Cost of Fish: $50 | Profit: $150 Because of your video I finally understand index and match.
@LeilaGharani
5 жыл бұрын
I'm glad I could help with that Brian.
@rina2012ful
3 жыл бұрын
I want to cry my heart out! 💃💃By using a unique identifier instead of combining rows and columns. Aren't you brilliant! You have saved me from hours of brain deadlock. Your analogy is so easy to understand. I can now move on to finalise the financial report. I can't thank you enough but thank you, thank you! I will surely enroll in yr course soon.
@LeilaGharani
3 жыл бұрын
You are so welcome!
@sarahdeschene3152
2 жыл бұрын
Awesome, I have been somewhat confused or at least vague on how this works, I could do simple functions but you really walked me through the logic and how to build the formulas from the ground up.
@dhavalshah2686
6 жыл бұрын
Queen of Excel, Leila Thank you for this video
@goodgollywally
6 жыл бұрын
Thank you for these Excel instructional videos. You explain the formulas in a way that makes them easy to learn and understand. Best Excel training videos on the web.
@LeilaGharani
6 жыл бұрын
That's very kind Walter! I'm glad you find the explanations easy to follow. Appreciate your support.
@vasuchawla2430
2 жыл бұрын
easy to understand and follow, saved me so much time compared to other articles without videos
@Ebiru2387
4 жыл бұрын
Perhaps the best excel channel i have come across to explain these concepts!
@LeilaGharani
4 жыл бұрын
Wow, thanks!
@banwarifageriaexcelclasses1447
5 жыл бұрын
nice very effective ...thanks Leila ..actually your all tutorials are very useful and educative .
@LeilaGharani
5 жыл бұрын
My pleasure. I'm glad you like the tutorials.
@serigamel
3 жыл бұрын
thanks so much Leila, I've been using this formula repeatedly since discovering your channel
@nguyendaominh1078
3 жыл бұрын
I had got into trouble with INDEX & MATCH until I found your video. Thanks & please keep it up
@tejaswaroop920
6 жыл бұрын
Mam I'm really impressed with ur way of explaining n thanks a lot
@LeilaGharani
6 жыл бұрын
You're very welcome Teja.
@AweshBhornya-ExcelforNewbies
6 жыл бұрын
Another fab video. Looks interested but can be complicated for many people. I have been working on complex INDEX MATCH situations and have mastered it through a lot of real life cases. during my training sessions. Your videos are great to learn from, especially your techniques. Thanks.
@LeilaGharani
6 жыл бұрын
You're welcome Awesh. I agree - it does some practice to get the hang of these....
@VivianNewman
4 жыл бұрын
Thanks Mrs Gharani - You are a blessing.
@shashikantgaekwad7768
3 жыл бұрын
very simple explanation and thank you so much Leila for making it this simple... Thank you soo much..
@LeilaGharani
3 жыл бұрын
You're welcome 😊
@MySpreadsheetLab
7 жыл бұрын
Great explanation of the different ways to solve this Leila! Each one has pros and cons.
@LeilaGharani
7 жыл бұрын
Thank you Kevin. Nice to see you here :). Your videos are great too!
@sanjayTECH04
4 жыл бұрын
Thanks , I was searching this type video of multiple criteria in index match.. many thanks Mam
@vps99999
7 жыл бұрын
Nice way of explaining... you are highlighting common mistakes as if you are actually making them, helps a lot in remembering such errors and how not to make such mistakes. Keep it up!!
@LeilaGharani
7 жыл бұрын
Thanks Vinay - Very happy to hear that. I still make mistakes when writing formulas so it's easy to remember the common ones :)
@rajasekar79
7 жыл бұрын
Your teaching method is very very clear. Thanks for this video.
@euniceesinam2573
4 жыл бұрын
You're the best...certainly the best I've seen among many instructors. Keep making our lives better in Excelandia😊
@subhashsansarwal3914
3 жыл бұрын
What a wonderful & awesome explanation of such a complex program.
@1gopalakrishnarao
7 жыл бұрын
I am very much attracted by your explanation. Really you are very intelligent and Pragmatic. Hats Off to your intelligence in Excel. You are my guru.
@rahulbakshi285
6 жыл бұрын
You are great Leila... Awesome I'm a big fan of your teachings...
@jagajyotisahoo9105
3 жыл бұрын
Thanks for the detailed explanation.
@elisapujadas9790
6 жыл бұрын
......very clear and logical...so easy to follow. Thank You Leila.
@LeilaGharani
6 жыл бұрын
Glad to hear that. You're very welcome Elisa.
@nancmadi
6 жыл бұрын
THANK YOU.... I really like how well you explain things.. I will try to use this instead of VLookup to learn better.
@LeilaGharani
6 жыл бұрын
You're very welcome. I'm glad you like the explanation! It's difficult to get the hang of it. It took me a while....but once it clicks, it's just so much more flexible than Vlookup.....
@sudhirhiwale9784
5 жыл бұрын
Another brilliance from you Leila. Thanks once again.
@LeilaGharani
5 жыл бұрын
Thanks for the kind feedback. I'm glad you like the tutorial.
@chanthyum6825
7 жыл бұрын
your lecture explain very precise and step by step. I like it
@LeilaGharani
7 жыл бұрын
Glad to hear that Chanthy.
@starfire787
5 жыл бұрын
You're a very good teacher. I had struggle understanding this but you made it so easy. Thanks so much. Keep sharing!
@LeilaGharani
5 жыл бұрын
I'm glad it makes sense! Thank you.
@liamdillon9465
6 жыл бұрын
This is the best explanation of this function I have ever seen
@LeilaGharani
6 жыл бұрын
Thank you! I'm happy to hear that the explanation is clear.
@piyushaggarwala
3 жыл бұрын
Oh my god, this is EPIC. You're so clear with your explanations! Love it!
@LeilaGharani
3 жыл бұрын
Yay, thank you!
@ishaq79
3 жыл бұрын
O Man! i wish could hug you for this Index & Match. Thank you soooooooooooooo much!
@mehdizaidi3478
3 жыл бұрын
Wow! brilliant. Thanks Leila.
@santoshpv321
3 жыл бұрын
This is very helpful...As always your videos are way above the others...Thx.
@cathyb2878
5 жыл бұрын
I can't tell you how much you have helped me...again. Thank you.
@LeilaGharani
5 жыл бұрын
My pleasure Cathy. Glad the tutorials are helpful for you.
@দেবজিৎসরকার-ঢ৫ব
4 жыл бұрын
This video solve my very complecated problem.thank you
@Val-M.
4 жыл бұрын
Am late to this tutorial . . . but unlike other people's videos, your relaxed way of explaining, actually clicked for me (the light bulb came to life) and helped me understand how to play around with the data better and its presentation. So, now you have a late subscriber to your channel.
@LeilaGharani
4 жыл бұрын
Welcome to the channel! Glad you liked the video :)
@Val-M.
3 жыл бұрын
@@LeilaGharani - Yes there is lots to like and so-o-ohh much still to learn.
@ismaelkourouma5558
2 жыл бұрын
You saved my life again today, 4 years since you throw the lifeline !
@LeilaGharani
2 жыл бұрын
Happy to help, Ismael!
@balamira297
3 жыл бұрын
Crystal clear explanation!
@LeilaGharani
3 жыл бұрын
Thank you!
@aishwaryaravi8656
5 жыл бұрын
Very clear & understandable. Well done, Cheers
@Stepford
6 жыл бұрын
Brilliant! Thanks again Leila. Very easy to understand and follow as usual!
@LeilaGharani
6 жыл бұрын
Thanks Steve! Glad you like it :)
@meaculpanaturale
6 жыл бұрын
wow that seemed simple but it blew my mind to pieces. You made it look so simple. Thanks a bunch!
@ulligruber1344
5 жыл бұрын
Great video series about VLOOKUP, INDEX and MATCH for complex lookups. Love your teaching style and details Leila 💪 Questions: Is it possible to create a new Excel function including INDEX/MATCH to ease the data selection form the search table furthermore? For big data tables, is there a noticeable difference in search speed, memory usage? Which one would be the better pick there?
@hattemghanoom9557
6 жыл бұрын
Thank you Leila for another example of a very smart but yet easy to understand and implement video.
@LeilaGharani
6 жыл бұрын
Thank you for watching Hattem. Glad you enjoy the videos :)
@kendrewt
3 жыл бұрын
excellent examples and illustration! Thank you so much!
@simini2890
6 жыл бұрын
is there any word like ULTRA AWESOME ? no worries I just wanna tell you that it was so so outstanding ...priceless ...you are being blessed everyday by all who have'd benefited form this video daily.
@LeilaGharani
6 жыл бұрын
Thank you so much Simini. I'm very glad you like the video and find it helpful :) thank you also for your support.
@arnavgupta5386
5 жыл бұрын
Index match..... Crystal clear 😊 Thanks!!!!
@yuliandrirony4935
5 жыл бұрын
Its so clear i understood thank you Leila
@LeilaGharani
5 жыл бұрын
I'm glad to hear that.
@mahmoudabdelmgeed4075
3 жыл бұрын
Finally, I found the solution for N/A thanks a lot for that knowledge about control shift enter ❤️❤️
@LeilaGharani
3 жыл бұрын
You're welcome 😊
@setorwudata-adzah3618
4 жыл бұрын
Awesome video on index n match! Very clear and practical. Kudos
@jackychawla5422
7 жыл бұрын
it's always confusing to use index&match but dis time the way u dealt with really helpful
@LeilaGharani
7 жыл бұрын
Glad to hear my explanation was clear. Thanks Jacky.
@shankarsinghrathore9502
4 жыл бұрын
Thank you Leila, I have learnt a lot from all your videos.. Great work👍
@LeilaGharani
4 жыл бұрын
Happy to hear that!
@johnshambra8421
2 жыл бұрын
I finally figured this formula out after watching your video. You are the best
@LeilaGharani
2 жыл бұрын
Glad it helped!
@tomgreening9875
Жыл бұрын
Beyond your Index Match Advanced course, you could mention how to implement complex match criteria. This approach works when the conditions being checked are over commensurate ranges, like various conditions being checked for data in the same row of a table or rectangular worksheet region. You might want to check multiple conditions involving a single column or different columns. Individual logic checks can be combined into an overall array of 1/0 results using AND, OR and NOT logic. AND multiplies logic expressions, OR checks if the sum of logic expressions >0, and NOT is 1-logic expression. When necessary, multiply a Boolean TRUE/FALSE result by 1 to convert to 1/0. Essentially no limit to the complexity of logic conditions you can check. MATCH looks for 1 in the array of overall logic expression results. For older versions of Excel, put the array inside INDEX(expression, 0,1) to avoid C+S+E.
@jhonbernardovlogs3173
2 жыл бұрын
This is very helpful! Thank you
@dawudayunusfarouk3098
6 жыл бұрын
This is like magic to me as a beginner, precise and understandable. you are great.
@LeilaGharani
6 жыл бұрын
Thank you for the kind words. I'm really happy to hear that!
@khan200200
Жыл бұрын
@@LeilaGharani Hi Leila, I have a problem and hope you would help. My table looks like this A1 France A2 405 in seperate sheet A1 France B2 400 C1£3 A2 France B2 500 C2 £5 I want to look France between =< 400 less than 500 return matching value from column C, hope you can help
@BOOM-fu9du
4 жыл бұрын
Amazingly explained I must say ,now i dont need to google up every time i put in the formula. Thank you so much
@LeilaGharani
4 жыл бұрын
You are welcome!
@cphilip98
2 жыл бұрын
Hi Leila, can you do a video to show how to do index match match with a table where the row headers and column headers are numbers? So by inputting a number within the range of row headers, and another number within the range of column headers, it would return a number from the table. Where the numbers are not exactly matching the headers, the selection would look towards the next higher number.
@patryklagwa5549
2 жыл бұрын
Thank you, very helpful!
@TIE-TakeItEasy
3 жыл бұрын
Ma'am, you are the ocean of Excel, I am a beginner.
@omar.jannah
3 жыл бұрын
Hello, I am a follower of your lessons and your lessons are beautiful. I wish the translation into Arabic would be combined with the lessons. Thank you very much
@sanjitpaul2953
3 жыл бұрын
Great Ma'am. At last the nightmare of ctrl+shift+enter is gone. Lot of thanks.
@LeilaGharani
3 жыл бұрын
😁
@Rams_Arjun
3 жыл бұрын
Excellent explanation
@impex2324
5 жыл бұрын
Brilliant! I mastered VLOOKUP and helper cells to the extreme. This is a new dimension - thanks!
@LeilaGharani
5 жыл бұрын
Great! It will take you to the next level Joachim :)
@heemanshuchikhlia6085
4 жыл бұрын
Great explanation and easy to follow.. thank you
@mikedsjr
5 жыл бұрын
Thank you for your clear instructions on all methods.
@JasonPiepmeier
3 жыл бұрын
Very helpful! I have also found SUMIFS to be a great function for certain lookups that contain multiple criteria for the lookup.
@tomdoe1234
3 жыл бұрын
BTW thanks so much I'm saving this one for future use. I always have use the helper column
@tonedh2auto
3 жыл бұрын
Great video and even better presentation. Your explanation of these more complicated functions is amazing. Thank you very much.
@ingridwa3664
5 жыл бұрын
Thank you for sharing your tips 😇😇😇
@jeannoelnga6836
3 жыл бұрын
thanks it's simple and efficient
@muziccal
4 жыл бұрын
thank you so much for your labor.
@AnilKumar-sr7ub
4 жыл бұрын
i am so happy to see the index match formula
@JI9131
6 жыл бұрын
excellent on explaining alternative solutions
@LeilaGharani
6 жыл бұрын
Glad you like the explanations :)
@chamindabasnayake4844
7 жыл бұрын
Awesome, very clear presentation and it definitely help to improve our reports, many thanks.
@LeilaGharani
7 жыл бұрын
That's great to hear! You're very welcome.
@stefanijarandjelovic7732
7 жыл бұрын
Thank you Leila, you are an amazing teacher. You really have a knack for explaining and making it easy to understand, even if it is not that easy. Keep up the good work. IMO, you should have much more views. I am recommending you to my my frends. Cheers.
@stefanijarandjelovic7732
7 жыл бұрын
One advise...it would be much more easier to follow if you left us a link to download the workbook, so we can practise and do the functions as you speak. ;) Hope you will think about it.
@stefanijarandjelovic7732
7 жыл бұрын
Forget about it, haha. You already did that :) I sould have my eyes examined :D
@LeilaGharani
7 жыл бұрын
You're welcome Stefanija & thank you for the kind words & recommendations.
Пікірлер: 783