I love India and all the Indians, you are always in my heart

I needed to parse data at work fast, but I forgot how to index match. This video has been the best so far. Very well explained and not too over the place! Simplicity is key! Thank you Teknisha!

Came from a 20min long video that had like a 5min intro, meanwhile my guy nailed the explanation in less than 5 minutes lol straight to the point, thanks a lot mate! 🙌

Finally!! I can undestand from this channel about Index-Match formula. Thanksss

VERY GOOD EXPLANATION. Was unable to crack it after 100s of attempts and dozens of videos. But with this video i was able to For better results best is to make use of the exact table available in the video (Tutorial)

Thank you Sir!!!! Took me some time to understand but, unlike other videos your explanation is so simple and i can now use it anywhere without having to watch the video!

Thank you. I have been trying to do this for over an hour and this helped me in less than five minutes.

Very clear explanation. The best video tutorial on index and match so far. Thank you!

Thanks very much, TEKNISHA. I find your tutorial very easy to follow and readily understandable. The pace is gentle to follow, the explanations succinct, and clarity superb. My challenge had always been with not locking the Subject item (here, Math, I6) in $ as done to the rest of the cells/ranges in the functions.

you could use 1 dimensitonal index match...=INDEX(D4:D13,MATCH(K4,C4:C13,0)) ....for math...no need to write match formula 2 times

Nicely explained. ❤

I always come back to reference this video. Thank you!

Finally I am able to understand this function. Thank you!

That's great thankyou! Had struggled following other videos, but was easily able to apply this to my own data!

Omg, I love the way to explain the process. I have watched so many videos, your was clearly the best. Thank you

Thanks for giving learning ❤❤❤

This helped me understand index matching much better than other guides I have tried using. Great tutorial!

you made this formula very easy sir. vey useful information you shared

Thanks a lot indeed. Match + Match combination:)

Very well structured and presented tutorial. These kind of functions being somewhat intimidated by the sheer power of Excel intimidates the living daylights out of me, but this tutorial has stirred my creative juices!! WELL DONE !!

Simple but dimple ways thanks

Just scr 4:02 scene, and save for yourself, that is it. Unbelievably good video !

Phew! tight well done 5 min INDEXMATCH...✔✔👍👍ty

I reviewed multiple video of this function and your video is the best one so far!

So clearly studying. Thanks

I love the expertise the Indians have.

Thank you so much Sir!!

Fantastic! Easy to understand

Thankyou sir finally understood, since morning I was stressed about it, but your explanation was so simple to comprehend, that it became easy to understand, thankyou for uploading video.

Very well understood. Thanks

Thanks bro 👍

I liked the way you teaches

Very helpful. Thanks!

Thank you!!! Very helpful!!!

Your video is very useful…thanks.

Hello sir, and thank you so much. However, I'm new here and I've been watching your tutorials for a very long time… but on this tutorial how can I make all the arrays fixed (by putting the $ sign) I mean the shortcut method.?

You explained it well. Thanks!

Thanks for the video, regards from Argentina!

Thank a lot my Dera sir ❤️💕💖

This is brilliant. short and to the point

Thanks a lot❤❤❤

great use... thanks

manny thanks to you sir love you......

Excellent 👍

A non related to your topic question but slightly related in some other things, was that formula, the formula of the horizontals or within the group of equals because the subject topic is about index match, about chemistry or science similars interaction? V lookup is 3 :1, X lookup is 3:3 meaning parallel or similar with some pairing match compatibility as example only. I won't dig more about that but I'm thinking of the complex lateral continuous transformation at both sides and the dimensional thing when it comes to creating formula for such because your formula is fixed to be changed by push button what if there's more than that the adaptability to be considered in the uniqueness and variety of things not yet discovered in the what if factor not included in excel but in real time occurrences. Now you know that the advancements and modernizations we have today or tonight if night there aren't yet that superbly sophisticated, and there are space for improvements and how to improve is to study space and it's changes. Can that be made into fruition in the coming 1,000 years?

Thanks a lot for sharing.. Much helpful video

Excellent tutorial, well explained!!! Thank you

Thankyou

THANKS, SUCCEDED TO USE BOTH INDEX AND MATCH FUNCTIONS

This helps a lot! Thank you!

Thanks, Mate. Well explained and straight to the problem!

Very good explanation....thanku sir

Thank you Sir, helped me !!!

U made my day Thank i❤🎉

Thank you for this video.

Thank you sir, you made my day👍

THANKS DUDE

very Excellent

Hello Teknisha, Thank you for the video, how do you update the data and it will automatically pick the information

For example only when those microthings becomes Macrothings and took human form what if they have camouflage and covering mechanisms or body altering mechanisms in its advance form and to the very difficult to assess the human body form to transformation to non physical and able to separate their atoms fly and merge into another place to form their bodies again as more than the intelligent beings but with power capability in them.

Thank you

Thank you ....too clear

Thanks for uploading beautiful video, very informative

Thank you Teknisha. Very helpful and oriented instruction.

Thanks alot Man!

thank you

Explained well, Thank You

Thank you soo much sir

Thanks for making it a short video. Well explained as well.

Nice one.

Thanks Sir very helpful and useful

Thank you!

Nice, thank you Sir,

Hi - I have a data set in which the year 2023, 2024 in every alternative columns and products in rows. I wanted to sum basis of the number of days (when days get change) in both of the year. Can you advise which formulae to be used for this. I tried sum+offset + index + match formula but the total is not matching when I checked manually.

Fumingly perplexing

Very Nice Concept and you did really well as everyone confused in Index Column thanks Sir.

Very helpful

You're the best!

Explained well

Love your effort to to teach us 👍👍👍👍

instead of using index and match, it is better to use pivot table. within a fraction of minute work can be finished

Wonderful.thanks a lot dear

Excellent video, Thank you

Great Tutorial! Simple and easy to follow. Thanks!

Hi Leila. Some time I saw a using @index inside formula. Could you advise or do VDO explain for this pls?

F4 is that magical shortcut which brings in $ to the formula, manually takes like forever.

thanks Brother ❤

Sir..Can you make tutorial video how to find top 5 student(5 highest score ) in every subject.,

thnk u:)

Great & thank you very much !

Thank you! Problem solved.

Is it possible to connect different sheet data to make marksheet

Clear and concise tutorial. Great job sir 👍

Thank you.

Keeping our array from D6:G15 would be better I guess. Though the values would be same but technically this approach is better.

Great... very objective and well explained

Super sir

Which one is more powerful: xlookup or indexmatch?

Thank you, kind sir! That was very easy to absorb :-)

if i need to get a,b,c,d,e 5 entities P/L data and consolidate yearly in 6th workbook. how to pull data from 5 diff. workbook into 6th workbook sheet columns? i have 22 stores Financial statement n i want to consolidate in one workbook(automate)