Excel Index Match Tutorial

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

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

[@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

[@poizonbee1902]

@@prabhurajswami285 atleast be thankful that u were not born in a war torn country...or some other country where its a puppet of a bigger european nation....it's so pathetic to watch greedy people like you....sure, will i say that my country is perfect ?absolutely not, its far from it but still it gave you something....

[@adammarktucek3177]

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

[@Blueberrythepompom]

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

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

[@janemensah5443]

Finally, I understand index and match through this channel.Thanks

[@StevenAllaway]

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

[@TEKNISHA]

Glad it helped!

[@axelnordstrom7549]

Best I have seen. You are a king, Thanks!

[@lukehults3365]

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

[@TEKNISHA]

You are so welcome!

[@kamalguliyev6022]

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

[@maheshkaushik6537]

Thanks for giving learning ❤❤❤

[@TEKNISHA]

Glad it Helped!!

[@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

[@stefania14750]

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

[@THEcrazyPANCAKE41]

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

[@sandeepdimri8930]

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

[@TEKNISHA]

Glad that this helped you

[@lavelclaytorsProjectswPurpose]

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

[@gunelabdullayeva4184]

So clearly studying. Thanks

[@TEKNISHA]

Most welcome!

[@gregrichards1660]

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

[@aroraenu]

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

[@TEKNISHA]

Glad that this helped you…

[@peterjarabek5541]

Thanks a lot indeed. Match + Match combination:)

[@TEKNISHA]

You are very Welcome!!

[@danter399]

Thanks for the video, regards from Argentina!

[@TEKNISHA]

You are Welcome Dante

[@gautamsharma1979]

I liked the way you teaches

[@TEKNISHA]

Happy to help!!

[@hassanalianees5530]

This is brilliant. short and to the point

[@MuhammadKamran12345]

Nicely explained. ❤

[@manzoorpashteen2291]

Thank a lot my Dera sir ❤️💕💖

[@TEKNISHA]

You are welcome…

[@reubenangachi5043]

Fantastic! Easy to understand

[@0202Jhum]

Very helpful. Thanks!

[@TEKNISHA]

Glad it was helpful!

[@sydb1264]

Thank you!!! Very helpful!!!

[@TEKNISHA]

You are very welcome

[@juanmolina3192]

Thank you Teknisha. Very helpful and oriented instruction.

[@TEKNISHA]

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

[@dre.7107]

You explained it well. Thanks!

[@TEKNISHA]

Glad that this helped

[@alexnava3075]

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

[@ManinderSingh-re1ec]

Thank you sir, you made my day👍

[@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

[@Moon-cu1nw]

Thank you sir, Highly APPRECIATED!!!

[@timmyxamm6049]

Very well understood. Thanks

[@TEKNISHA]

Glad it was helpful!

[@dhanunjay99]

U made my day Thank i❤🎉

[@Donald_Dsouza]

Your video is very useful…thanks.

[@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.

[@jaspreetsingh-ib3zy]

Very good explanation....thanku sir

[@TEKNISHA]

Thank You Jaspreet!!

[@Ayushh-t1k]

Thanks a lot for sharing.. Much helpful video

[@muhammadirfan672]

Excellent 👍

[@TEKNISHA]

Thank you

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

[@andresplaysPH]

This helps a lot! Thank you!

[@TEKNISHA]

You are welcome

[@digitaltools3011]

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

[@nickbell6311]

Thanks for uploading beautiful video, very informative

[@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.

[@1MinuteEDM]

Excellent tutorial, well explained!!! Thank you

[@TEKNISHA]

Glad that this tutorial helped you

[@endahlarasaty4257]

Simple but dimple ways thanks

[@bandidphasengkeo5220]

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

[@legacygk2811]

Thank you so much Sir!!

[@vinaysharma7585]

Love your effort to to teach us 👍👍👍👍

[@vincentmbati7266]

I love the expertise the Indians have.

[@shajibethel1353]

Explained well, Thank You

[@Mysterus88]

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

[@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.

[@mistenterprises1235]

Wonderful.thanks a lot dear

[@TEKNISHA]

You are very welcome

[@masoodnkhan1]

thks, it helped a lot!

[@shivlisona8049]

Thanks a lot❤❤❤

[@maqsoodkakar9189]

Thanks bro 👍

[@TEKNISHA]

You are very Welcome!!

[@GeorgeAJululian]

Thanks Sir very helpful and useful

[@lukmanaliyuyahaya]

Thanks alot Man!

[@TEKNISHA]

Happy to help

[@jezdel6298]

Thank you for this video.

[@TEKNISHA]

Glad that it helped

[@johnq3543]

Excellent video, Thank you

[@nitishtandon4835]

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

[@souadbohsali4997]

Thank you ....too clear

[@masyusuf4952]

THANKS DUDE

[@TEKNISHA]

You're welcome!

[@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?

[@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

[@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

[@abhashtripathi9234]

Is it possible to connect different sheet data to make marksheet

[@syedahmad143]

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

[@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)

[@RupeshRegar]

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

[@karanc360]

Great Tutorial! Simple and easy to follow. Thanks!

[@TEKNISHA]

Glad you enjoyed it!

[@sergiosolischeca6934]

Great... very objective and well explained

[@terenceforka9113]

Hello Teknisha, do you have a website contact where one can get through to you?

[@TEKNISHA]

You can contact me at [e-mail]

[@elibarikimakundi1602]

THANKS, SUCCEDED TO USE BOTH INDEX AND MATCH FUNCTIONS

[@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

[@GK_My-Art_Box07]

Thank you soo much sir

[@TEKNISHA]

Happy to help

[@harshitpradhan-l6x]

Can you please tell me how you put $ sign after selecting a range.

[@satosoujirou]

F4 button

[@dmprasanga]

thanks Brother ❤

[@andreausa123]

Great & thank you very much !

[@magin10011]

Would this work for an inventory list where the skus are going horizontally and date going vertically?

[@TEKNISHA]

Yes, index match looks for row and column information to get the data from the particular cell. As long as all your skus are in 1 horizontal row and all the dates are in 1 vertical column

[@magin10011]

@@TEKNISHA thanks! Im still trying to get this to work so that I can enter a date and it pulls the data for that sku on that date and fills it into another table. How do I incorporate a Today() function In this?

[@TEKNISHA]

@@magin10011 if you are looking for TODAY() date, then in the lookup value (in the index match function) you enter TODAY(). If you are still having issues, you can email me the file / sample data to [e-mail].

[@TEKNISHA]

@@magin10011 hey. If you are looking for a specific date, then you don't need to use today(), as today() will give you the current data. You need to lookup for the date (that you enter) to get the SKU inventory on that date

[@mparthur144]

Which one is more powerful: xlookup or indexmatch?

[@alfiedj]

Clear and concise tutorial. Great job sir 👍

[@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?

[@ChristopherMwangi-vq9jm]

Very helpful

[@FromPradeep]

if aur sum ko ek sath kab use karte hai? please sir tell me in the next video

[@mq6219]

Will this work on a table? its seems it's not.

[@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?

[@abdalbastsalm5801]

very Excellent

[@Shiit_though]

Pls tell me which key for $ sing in formula

[@TEKNISHA]

“F4” . Press F4 function key to fix the reference ($)

[@mystudentsxoxo]

Nice, thank you Sir,

[@TEKNISHA]

Most welcome

[@AbhishekSingh-nc3ep]

Awesome 😊

[@krishnananda9466]

Explained well

[@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

[@bramwibowo1638]

What is the difference between index and lookup formula? It also can be done by lookup + match formula right?

[@krishnavamsisai]

Super sir

[@TEKNISHA]

Thank you vamsi..