Excel: INDEX and MATCH
Тәжірибелік нұсқаулар және стиль
Learn how to use the INDEX and MATCH functions together in the same formula to perform powerful lookups in your Excel spreadsheets. My entire playlist of Excel tutorials: bit.ly/tech4excel ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's the practice file that goes with this video: bit.ly/indexandmatch #exceltutorial #excel
Пікірлер: 78
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!!!
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.
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
This is the best INDEX/MATCH video I've found. I have saved it in my notes. Thanks
Best explanation I've read or seen. Thanks for such great videos. They've really helped.
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 !!
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. 🙂
Thank you so much for the most professional and at the same time simple and clear explanation. It is most useful!
your explanation is such crystal clear, that a naive too, can understand the whole lesson.
You don't know how much people you help with these videos thx so much for the toturios
I watched a few index/match videos. This is the first one that clicked for me!! Thank you so much!!😃😃😃😃
Thankyou sir for easily explaining about how Index match function works, i understood it completely, your video made my day easy thanks for upload.
I really find your videos helpful alot🤝🏽🤝🏽 and I was asking if you demonstrate how to go about " Power Bi " just like the others.??
Thank you for the most informative tutorial: you made me happy today in my quest for the proper explanation! 😃
crystal clear. Best by far. Exact and to the point
I cannot wrap my brain around this concept! It’s so frustrating.
You are the best teacher in Microsoft lots of respect from india
YOU ARE AMAZING! Thank you! Great work!
Very clearly explained. Thank you!!!
That's brilliant, There is no better explanation than this One...
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....
Ngl This is nuts, keep up the good videos man :)
dude you saved my time and a lot of money... thanx a ton
This is very nice formula. Thank you admin.
Keep up the great work!
I really get a great support from this video ❤
Best explanation I've seen on youtube
Thank you very much. That helps me a lot.🎉
I saw many videos for this concept but couldn't able to understand it but now i got it...
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.
Thanka alot🙏
Great tutorial!
Very good and helpful
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?
This one is useful thank.
thanks this helped me
I was really expecting this videos,. Absolutely great.
its great explanation..
This is excellent
Thanks you help me alot
thanks ,this is great ,
Awesome!
Many thanks Sir
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 .
Thankyou again. I am still not understanding why use Match/Index functions when XLookup exists. Maybe a video demonstrating the functions superseded by XLookup?
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?
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.
great video
Can you filter product category and month ?
You have mentioned DVD sales for June month and extracting March Month Sales !!!
I also want to know can we add 2 formulas i 1cell or colume ? If yes. So how can we do that?
Thank you! (:
I wish you could provide the Excel file to practice. :(
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
Can you please tell me what's the use of vlookup and hlookup??
Great but why are some data giving wrong answers yet the selected array has the answer on all vloolup, xlookup and index and match?
can you do this across worksheets?
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.
I am not able to download the same sample spreadsheet. Can you please share the link
Can you please tell me formula for minus one cell to other cell
In the starting it was looking not so useful But at the end, it was like; waoooooo
useful
How to put colour like that in table?
Dear Sir,tq for info,but i need , how to sum multiple columns at the same time,please send me
good
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
Hey, the link to the table didn't work
Question can it Answer a word ??
👍
Couls this be achieved with Xlookup?
@techteachersandstudents
11 ай бұрын
yes
easy - peasy - japanesey Still wonder how come so few views on this video,
你这是什么版本?Excel 2019 吗?
@yasminkhalifa8709
3 жыл бұрын
但他不懂中文,你知道嗎?!?!?
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