Videos | Books | What's New | FAQ | Testimonials | Buy Credits | Support | Login | My Account

Finding Data using INDEX and MATCH Added to Library on 04 Nov 2007 Length: 6 mins View Tutorial Movie Download File Used The Index and Match commands offer a very powerful way to extend the functionalty of the Vlookup command. In this tutorial we examine how these two commands can be used on their own and then combine them to show how we can complete the above form based on the seletion of the customers name. once you have mastered these two commands then you will have a powerful technique to find any data in Excel Related Tutorials: Vlookup Feedback for this tutorial: "Great tutorial. " "I watch the videos a couple times through, take a few notes and then try them out just as you have modeled them and then I try to find the ways the function will be useful in what I do...you make learning very easy and convienent, thankyou!" "You have a wonderful way with breaking things down. I look forward to working through this myself to solidify my understanding." "Read some articles on the web about how valuable INDEX/MATCH is, but couldn't figure it out. Thanks to your tutorial, I feel really comfortable using it, and will use it frequently. Don't have to sort lists like VLOOKUP."