Look Up Values with INDEX and MATCH functions in Microsoft Excel

Looking to master Microsoft Excel's Index and Match functions? Look no further! In this lesson, I will show you how to use the INDEX and MATCH functions in Microsoft Excel.

In this video, we'll dive deep into these two powerful functions, exploring everything from their basic syntax to their more advanced capabilities. Whether you're a beginner looking to learn the ropes or a seasoned Excel pro looking to take your skills to the next level, this video is for you.

We'll start with an overview of both functions, discussing their similarities and differences and highlighting some common use cases for each. From there, we'll move into more specific examples, walking you through the steps required to use Index and Match to perform tasks like looking up values in a table, creating dynamic charts, and even performing more advanced data analysis.

Throughout the video, we'll provide clear, concise explanations and easy-to-follow demonstrations, making it simple for you to follow along and start putting these functions to work in your own spreadsheets. And as an added bonus, we'll also provide some tips and tricks for optimizing your use of Index and Match, helping you save time and improve your efficiency.

So if you're ready to take your Excel skills to the next level, click play, and let's get started!

0:00 Introduction
1:09 Create a dropdown list
2:31 How to use the MATCH function in Excel
4:47 How to use the INDEX function in Excel
6:47 How to nest the MATCH function in the INDEX function in Excel

[Sassiemahyour]

your videos are so helpful and interesting to watch. Thank you

[jessicayucaidi]

This was the best tutorial thanks so much!

[oanhluong]

Your lecture is very helpful for me as a first learner of Excel. I hope you can help to come out with how to create the student hourly semi-monthly payroll spreadsheet with tracking work-study, student hourly, and how to calculate minimum wage increase. Thanks

[giorgidvali]

Another useful video, thank you so much!!!

[siyatsheikhwarsame]

You're doing a great job, God bless you.
Appreciate 🙏🙏🙏🙏

[CideeTV]

Tq for this video..help to improve my report

[larrykeem]

Thank you for the excellent tutorial. I do have a question. I am working with large Excel DB with almost 20 other legal entities. I always copy and paste the data I need from the entities report into the Master DB. I would like to automate the Master DB to the 20 entities with index formula. Do you have an idea of how I can get that done. That means when the entities complete the report month by month it should populate automatic in the Master DB. Thanks in advance.

[ericdcosta]

Hi, what if you wanted to have a third search function? For example, after a quarter, you wanted to see the value on an exact date?

[jessicasbritton]

Does this only work for cells with numbers? Or is this applicable to data stored as text also?

[peteramaocha]

Interesting at first but I was confused at the end when😅 you were referencing and changing cells with formulas lol

[jeffwilliamson]

Do you do special projects for people? I have a special project that I can't seem to figure out Please let me know if you do
Thanks
Jeff

[hlejscz]

Hello sir, you have a very nice presentation here. Do you have a website where I can reach out for your contact? Thanks

[muhammadimranbukhari]

I need index match function with condition of different dates start and ends