Excel for beginners: INDEX and MATCH functions to lookup data from multiple tables

In this beginners tutorial we take a look at the next step in using the INDEX and the MATCH functions together. This time we look at using these to lookup data from multiple tables. Learn the method as you watch! This is the fourth 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:

[querrythis]

Perfect example for my thanks for the help

[latihan]

Tq very easy to digest.. Do u hv any video on making dynamic listing from multiple tables with drop down list?

[ubaidillahmuhammad]

nice and good job. but please put all excel practiced files in the description....