Using INDEX and MATCH together to lookup data. Basics in 4 mins (Excel for beginners tutorial)

In this beginners tutorial we learn all you need to know to get starting with sing the INDEX and the MATCH functions together. These can be used to lookup information in a more dynamic way - learn how to use these functions as you watch. This easy beginners tutorial is the third of our four INDEX and MATCH tutorials.

Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!

What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)

Or check out the other videos in this series:

[pgcsec]

This is the first time I have seen it explained in this way and the use of the individual match functions to get the data we wanted from a particular cell made it so much easier for me. Thank you. I feel a lot more confident with Index and Match now.