Excel Index Match Tutorial

Excel Tutorial to find information from a table of data using Index and Match Function
🔶 Get Practice Excel File at : bit.ly/3g9AdT9 🔶
Digital Products:
🔷 gumroad.com/te... 🔷
Check the below Playlists..
Excel Tutorials:
• TEKcel Series : Excel ...
Excel Chart Tutorials:
• TEKcel Chart Tutorials...
Excel Pivot Table Tutorials:
• Excel Complete Pivot T...
Excel Gsuite Tutorials:
• Gsuite Tutorials
Excel Tips & Tricks:
• TEKcel Tips : Excel Ti...
Powerpoint Tutorials:
• Tekpoint Series : Powe...
App Reviews: • Apps
Gadget Reviews:
• Gadget Reviews
Thanks for watching!!! 😊🙏
Please do Subscribe and Hit the Bell 🔔icon to support my efforts and to receive all my videos Notifications.
CLICK HERE TO SUBSCRIBE 👉 tinyurl.com/Te...
Follow me on below to stay connected👇
👉FaceBook: / teknisha
👉Instagram: / teknisha18

[@ivanguti9259]

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

[@ALC0A021]

I want to visit Europe desperately

[@meghanarocks4703]

Ur from

[@prabhurajswami285]

India ,a very good nation Clean roads, zero corruption,high tech infrastructure, most gold medals in Olympics, Clean rivers, and all propaganda

[@marketeagle4508]

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!

[@andrewgx48]

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! 🙌

[@TEKNISHA]

You are very Welcome!!

[@alfiartya23]

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

[@TEKNISHA]

Glad to hear that!

[@stefania14750]

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

[@khanmoinul5438]

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)

[@TEKNISHA]

Thankyou Khan Moinul

[@adammarktucek3177]

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

[@spooe3814]

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!

[@lukehults3365]

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

[@TEKNISHA]

You are so welcome!

[@user-io7ks7nj8m]

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

[@TEKNISHA]

Glad it helped!

[@kamalguliyev6022]

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

[@endahlarasaty4257]

Simple but dimple ways thanks

[@gunelabdullayeva4184]

So clearly studying. Thanks

[@TEKNISHA]

Most welcome!

[@maheshkaushik6537]

Thanks for giving learning ❤❤❤

[@TEKNISHA]

Glad it Helped!!

[@harrisonmensahadiko2392]

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.

[@sandeepdimri8930]

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

[@TEKNISHA]

Glad that this helped you

[@aroraenu]

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

[@TEKNISHA]

Glad that this helped you…

[@gregrichards1660]

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

[@lavelclaytorsProjectswPurpose]

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

[@Blueberrythepompom]

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

[@THEcrazyPANCAKE41]

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

[@MuhammadKamran12345]

Nicely explained. ❤

[@peterjarabek5541]

Thanks a lot indeed. Match + Match combination:)

[@TEKNISHA]

You are very Welcome!!

[@philiplbrown]

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 !!

[@naughtyprincipal4174]

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.

[@775shahrukh]

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

[@hassanalianees5530]

This is brilliant. short and to the point

[@legacygk2811]

Thank you so much Sir!!

[@timmyxamm6049]

Very well understood. Thanks

[@TEKNISHA]

Glad it was helpful!

[@Princia_dance123]

Your video is very useful…thanks.

[@danter399]

Thanks for the video, regards from Argentina!

[@TEKNISHA]

You are Welcome Dante

[@gautamsharma1979]

I liked the way you teaches

[@TEKNISHA]

Happy to help!!

[@alexnava3075]

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

[@dre.7107]

You explained it well. Thanks!

[@TEKNISHA]

Glad that this helped

[@rasheednayakkan6750]

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.

[@syedahmad143]

If i put b5 it gives error, if i add b6 it shows exact match.(In array)

[@reubenangachi5043]

Fantastic! Easy to understand

[@0202Jhum]

Very helpful. Thanks!

[@TEKNISHA]

Glad it was helpful!

[@juanmolina3192]

Thank you Teknisha. Very helpful and oriented instruction.

[@TEKNISHA]

I am glad it is of use to you...

[@manzoorpashteen2291]

Thank a lot my Dera sir ❤️💕💖

[@TEKNISHA]

You are welcome…

[@RupeshRegar]

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

[@jaspreetsingh-ib3zy]

Very good explanation....thanku sir

[@TEKNISHA]

Thank You Jaspreet!!

[@vincentmbati7266]

I love the expertise the Indians have.

[@Mysterus88]

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

[@sydb1264]

Thank you!!! Very helpful!!!

[@TEKNISHA]

You are very welcome

[@user-fy6nm3sn6y]

Thanks a lot for sharing.. Much helpful video

[@maqsoodkakar9189]

Thanks bro 👍

[@TEKNISHA]

You are very Welcome!!

[@ManinderSingh-re1ec]

Thank you sir, you made my day👍

[@1MinuteEDM]

Excellent tutorial, well explained!!! Thank you

[@TEKNISHA]

Glad that this tutorial helped you

[@lishpa]

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)

[@nickbell6311]

Thanks for uploading beautiful video, very informative

[@shajibethel1353]

Explained well, Thank You

[@JayJay-ye8jy]

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.?

[@okaformaxwell1388]

Press F4 key on your keyboard for windows os

[@elibarikimakundi1602]

THANKS, SUCCEDED TO USE BOTH INDEX AND MATCH FUNCTIONS

[@rajasekhar-lq2if]

Thankyou

[@TEKNISHA]

You’re welcome 😊

[@jezdel6298]

Thank you for this video.

[@TEKNISHA]

Glad that it helped

[@masyusuf4952]

THANKS DUDE

[@TEKNISHA]

You're welcome!

[@muhammadirfan672]

Excellent 👍

[@TEKNISHA]

Thank you

[@alfiedj]

Clear and concise tutorial. Great job sir 👍

[@karunakarvemishetty1134]

Thank you Sir, helped me !!!

[@GeorgeAJululian]

Thanks Sir very helpful and useful

[@AliHaider-lt6bz]

Your download link for excel practice sheet is not working.

[@dhanunjay99]

U made my day Thank i❤🎉

[@andresplaysPH]

This helps a lot! Thank you!

[@TEKNISHA]

You are welcome

[@GK_My-Art_Box07]

Thank you soo much sir

[@TEKNISHA]

Happy to help

[@karanc360]

Great Tutorial! Simple and easy to follow. Thanks!

[@TEKNISHA]

Glad you enjoyed it!

[@deadlyslayer3251]

Thank you

[@TEKNISHA]

Glad that this helped you

[@vinaysharma7585]

Love your effort to to teach us 👍👍👍👍

[@francishubertovasquez2139]

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?

[@shivlisona8049]

Thanks a lot❤❤❤

[@abdalbastsalm5801]

very Excellent

[@sergiosolischeca6934]

Great... very objective and well explained

[@ailtonbiji5024]

great use... thanks

[@nitishtandon4835]

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

[@souadbohsali4997]

Thank you ....too clear

[@johnq3543]

Excellent video, Thank you

[@dara1753]

Thank you! Problem solved.

[@abhashtripathi9234]

Is it possible to connect different sheet data to make marksheet

[@ManinderSingh-re1ec]

I have a question, taking your example, if there are large number of students and I want to bifurcate this class wise. Means in the first drop-down I need to select the class first and then from the result in the second drop-down I want to select the student name.. how to do that. please guide

[@MiguelGonzalez-tr9qx]

Thank you!

[@niklauscillianred2735]

You're the best!

[@TEKNISHA]

😬. Glad that this tutorial was useful for you

[@niklauscillianred2735]

I got some error on the other cell it says #N/A. How am I going to correct them? Can you suggest any video tutorial for me? I will really Appreciate it!

[@TEKNISHA]

Just ensure that you fix the references in the formula.

[@lukmanaliyuyahaya]

Thanks alot Man!

[@TEKNISHA]

Happy to help

[@mystudentsxoxo]

Nice, thank you Sir,

[@TEKNISHA]

Most welcome

[@krishnananda9466]

Explained well

[@francishubertovasquez2139]

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.

[@emrandafadar4445]

Fumingly perplexing

[@TEKNISHA]

Index match looks daunting, but if you understand the concept, it is very easy to implement and is very powerful. Hope this video helped to understand a little bit of the concept

[@bandidphasengkeo5220]

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

[@digitaltools3011]

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

[@andreausa123]

Great & thank you very much !

[@ChristopherMwangi-vq9jm]

Very helpful

[@dmprasanga]

thanks Brother ❤

[@awandaik4203]

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

[@TEKNISHA]

Already uploaded. Check this video. kzbin.info/www/bejne/hpnSZGaXh7ple8k

[@karunakarvemishetty1134]

Hello Sir, when dragged to next rows same of first index answer reflecting next row. Could u please help

[@mistenterprises1235]

Wonderful.thanks a lot dear

[@TEKNISHA]

You are very welcome

[@ryl_2.067]

if we have same name in sheet mutiple time and I want same data in different row then how to do it?

[@aminmdbadrul8024]

Great content. Thanks for the helpful video. I have a problem once I use those formula in my worksheet, b coz my worksheet in D6 to G15 got some blank cell and Word & numbers mixed. To get the correct value what should I do ? Pls advice me if anyone know the solution or share me a video link. Thank you so much

[@krishnavamsisai]

Super sir

[@TEKNISHA]

Thank you vamsi..

[@souravgupta1769]

Can it was done through x lookup

[@prathappoojari5415]

I applied same formula for similar problems but it is showing #NA

[@Essensiell_Styrke]

How do you make it work in reverse, for example: I would like to know what subject Alex scored a 100 on, so I know the values Alex and I know i am looking for his highest score on any one of the subjects (in this case I look for approximate match for a score of 100). How would that formula look?