ONLY Excel pros use this INDEX MATCH trick 💡

This INDEX MATCH trick that will surely blow your socks off. And then it blows your pants off too with an even better XLOOKUP variation. So yeah, bring some spare clothing and watch 😎

📂 Download the sample file:

💡 Learn more:

~

What is the data analyst still single?
Because he is waiting for the EXACT MATCH... 🤣

#excel

[Excelambda]

Cool, or FILTER, deals also with multiple matches, not only single ones. ✌

[GameAGuy]

Wow.
I am still novice to excel but this is very cool.
I have only been on my excel journey about 8 months. Have so much to learn😊 I am hype about learning it though.😃

[ufoufo]

I had been on this for hours!!!! Went through different videos on YouTube. Yours was the only one that gave me what I was looking for, the right result. THANK

[soujanyapilli]

I learned this couple of days back and such a cool hack

[rangerover]

Hi Chandoo, an awesome trick using index match. If I were given this problem, I would have probably used the Sumifs function

[IarukaSkYouk]

Chandoo you are a life-saver.
I was so bad at excel before I know ur channel, know I'm getting better :D

[AnilSumanam]

Thank you Very much for this video i tried the same for my daily company work and it worked for me..

[michaelt]

Every time I start thinking I'm getting pretty good at Excel, a new Chandoo video comes out and reminds me how much I have yet to learn.

[geoffwatson]

Is it not better to use: =SUMIFS($F$10:$F$369, $C$10:$C$369, D3, $D$10:$D$369, D4, $E$10:$E$369, D5), then this will take into account any multiple entries for the same month and also eliminate the need to use an array?

[vijayarjunwadkar]

Truly mind blowing! Thank you Chandoo for sharing this! 🙂

[mohsinahmed]

This is excellent and exactly what I was looking for for some time

[blitzkrieg]

I always confused how to use index match if the both reference is row and after watching countless Excel video i finally found this

Thank you sir, thank you very much

[pokerhearts]

I was looking for the same formula just a week ago. Thanks for making it simple.

[sanket]

We can also perform the same using vlookup, but concatenating 3 columns

[vipulraf]

Hi Chandoo that was awesome. But did it by Sumifs and got the results. Yes but only when output is in number not text.

[JAEXCEL]

sir, sumproduct(
is any disadvantages with this simple method

[ysantosh]

Super Chandoo anna, learnt a new formula today.

[thojeda]

A simple SUMIF solve problems like this!

[ananda]

Dear Chandoo can we use the same formula to get data from one table to another table . I was trying to so formula gives error when one column value repeats in one column while other is different in both

[SamehRSameh]

If multiple header we can use same trick