Excel: INDEX and MATCH

[@deebaxley7800]

Have watched **many ** of your videos and they always make me smile because I always go, "oh, that's how" - they make sense and are easy to follow. You have a great gift of teaching.

[@shinydas909]

Same here. This tutorial gave me a wide smile on my face

[@regnig58]

I’m taking an accelerated Excel summer class, using SIMnet. You explained this concept so well! So much more understandable than the text book!!! Thank you so much!!!

[@richardgordon]

Thank you for a brilliant tutorial. Been trying to get my head around the Index Match combo function and had a terrible time understanding it. Your tutorial straighten me out.

[@Jacteaux]

PERFECTLY done! I get so tired of watching videos where I have to scroll to the part where they stop showing us how to get to the point of what we came to learn. Not only do you get right to the point you don't "um" and "uhhhh", your speech cadence is not too fast or slow, and you make it easy to understand. Thank you!!!! I've watched many Index/Match videos and yours is the best. New Subscriber now. 🙂

[@pdas9013]

your explanation is such crystal clear, that a naive too, can understand the whole lesson.

[@dd-1280]

This is the best INDEX/MATCH video I've found. I have saved it in my notes. Thanks

[@kuunami]

I watched a few index/match videos. This is the first one that clicked for me!! Thank you so much!!😃😃😃😃

[@kapilmehra2874]

Well explained my friend

[@naughtyprincipal4174]

Thankyou sir for easily explaining about how Index match function works, i understood it completely, your video made my day easy thanks for upload.

[@mukeshprajapati2677]

You are the best teacher in Microsoft lots of respect from india

[@user-wo3dm5xe4l]

Thank you so much for the most professional and at the same time simple and clear explanation. It is most useful!

[@barakuda2711]

Thank you for the most informative tutorial: you made me happy today in my quest for the proper explanation! 😃

[@carolinehiggs6813]

Best explanation I've read or seen. Thanks for such great videos. They've really helped.

[@damn5940]

You don't know how much people you help with these videos thx so much for the toturios

[@siyakholwakhiphi1556]

That's brilliant, There is no better explanation than this One...

[@donkahl63]

Very clearly explained. Thank you!!!

[@LordBransty]

This is fantastic. Thank you very much!

[@BLOODBR3ED]

dude you saved my time and a lot of money... thanx a ton

[@ennamarine5464]

I really get a great support from this video ❤

[@philiplbrown]

Fantastic tutorial. I'm intimidated by the Index and Match functions to apply it in the workplace to improve quality and efficiency, but this well presented and structured tutorial gives me ample motivation. WELL DONE !!

[@keifer7813]

Best explanation I've seen on youtube

[@genesis_1111]

Thank you very much. That helps me a lot.🎉

[@adammalak426]

This is very nice formula. Thank you admin.

[@MjMojo]

YOU ARE AMAZING! Thank you! Great work!

[@deinbleiz]

Great tutorial!

[@Hajira353]

I saw many videos for this concept but couldn't able to understand it but now i got it...

[@a.856]

Thanka alot🙏

[@arthurmakawa9876]

I really find your videos helpful alot🤝🏽🤝🏽 and I was asking if you demonstrate how to go about " Power Bi " just like the others.??

[@kimberbearly7909]

crystal clear. Best by far. Exact and to the point

[@dossen]

There's one more trick that would have put the cherry on (if it was in Excel then?): Setting validation to only allow values from an array on the two input cells in column j.

[@dvk5780]

Ngl This is nuts, keep up the good videos man :)

[@alamiralshafay]

Very good and helpful

[@cyanocorax3094]

Thanks you help me alot

[@robinparba]

Keep up the great work!

[@GeorgeAJululian]

Many thanks Sir

[@Brandezi84]

I cannot wrap my brain around this concept! It’s so frustrating.

[@collection725]

thanks ,this is great ,

[@jennieyang1415]

This is great. Can this be done in reverse? I mentioned an example in a comment in the "Create an excel macro" video about it but seems more appropriate for this video instead. So instead of finding out what values of sales, can you start with empty sale array so that one can fill in the sales values in the array by using the index and match (perhaps?) to populate the array with sales numbers....

[@ShahrukhKhan-kl8vo]

great video

[@pastrystine2706]

thanks this helped me

[@michaelguthrie2344]

Thankyou again. I am still not understanding why use Match/Index functions when XLookup exists. Maybe a video demonstrating the functions superseded by XLookup?

[@MedoHamdani]

This one is useful thank.

[@mghayadar]

This is excellent

[@aniposter2478]

SIR FOR MATCH AND INDEX FUNCTION DOES It INVOLVE in any of the data entry form fill sources and can u teach me how to calculate rate in inventory or the formula for rate.and its awesome video of basic excel .

[@MediaOPS]

its great explanation..

[@Cosmos1987]

You have mentioned DVD sales for June month and extracting March Month Sales !!!

[@NathanielStockwell]

Thank you! (:

[@denisekobrin9338]

Quick Question, what is the advantage of grouping versus creating one worksheet and then copying it by right clicking the worksheet and creating a copy?

[@tituskiokomichael185]

Great but why are some data giving wrong answers yet the selected array has the answer on all vloolup, xlookup and index and match?

[@aneskovic90]

Hello. First of all I just want to say your concept and way of explanation is amazing and thank you for the effort you are making to teach us. :) Next thing is, I am getting N/A as a result when I shouldn`t be. I chose small searching area in table so I could be sure the requested value is in selected array and I chose 0 match type. After ENTER, EXCEL returns N/A. What are the possible scenarios that could cause this? Is it possible this is my mistake?

[@aneskovic90]

Forgot to mention, the value I searched was a text so I used quotes regularly.

[@trayjunie12]

can you do this across worksheets?

[@edwinmarume4438]

to make it more interesting put a drop down list on month and category to avoid typing everytime u want a new month or category

[@likakoch1410]

I wish you would go further to show example of how to use these functions in real life with thousands of rows of data. I cannot imagine using this formulas the way you showed in real life.

[@joshliu2410]

I was really expecting this videos,. Absolutely great.

[@tahrin.choudhury]

I wish you could provide the Excel file to practice. :(

[@arulgk9673]

Awesome!

[@hamzash4251]

I also want to know can we add 2 formulas i 1cell or colume ? If yes. So how can we do that?

[@Salalkhan]

I am not able to download the same sample spreadsheet. Can you please share the link

[@MamathaGudugula]

Dear Sir,tq for info,but i need , how to sum multiple columns at the same time,please send me

[@ibrahimjamal368]

Can you filter product category and month ?

[@behindthescene2727]

useful

[@hamzash4251]

How Can i open new sheet by typing any cell...? For example.. i want to i have a sheet of costumer name and address ext ext... Now how can i open my costumer's month sales detail i putted on another sheet... Can i open his sales detail by clicking his name cell

[@yasminkhalifa8709]

Can you please tell me what's the use of vlookup and hlookup??

[@mikelennon1078]

Would you be able to share a sample formula with Excel/Match for below example ( One to Many) ? Lets say my Contact Sheet has over 10 Columns but I only would like to return the 4 Columns (Contact Name, Title, Cell # and Email address.) for all contacts within a company. Can you suggest a index match formula please? I would appreciate it. Also is it possible that one can edit/update the a.m 4 contact values right from there?

[@hamzash4251]

Can you please tell me formula for minus one cell to other cell

[@enochauston4068]

good

[@devanshsaini3908]

In the starting it was looking not so useful But at the end, it was like; waoooooo

[@skip031890]

Couls this be achieved with Xlookup?

[@techteachersandstudents]

yes

[@bernardannannketiah7853]

Please kindly share with us the dataset for this tutorial....the file link above is not working

[@techteachersandstudents]

Try copy/pasting it into your browser. Does it still not work? bit.ly/indexandmatch

[@millenniumnamoijam1074]

How to put colour like that in table?

[@Jsjhvwkwbhik11]

👍

[@meahdoarts4882]

Question can it Answer a word ??

[@danielphillips7649]

Hey, the link to the table didn't work

[@henrikmanukyan3152]

easy - peasy - japanesey Still wonder how come so few views on this video,

[@user-vl8dy1os6r]

你这是什么版本？Excel 2019 吗？

[@yasminkhalifa8709]

但他不懂中文，你知道嗎？！？！？