How to use Index and Match function (Advanced Excel)

About this tutorial:

Video duration: 00:11:09
How to use Index and Match function
: Learn how to overcome limitations of Vlookup function with Index Match functions.
This video includes examples of how to set up and use this data validation function for a two-way lookup.
Tutorial for Index Function:
Tutorial for Match Function:
This video is created by Ramgopal from Presentation Process in Excel 2016 for Office 365. Visit for more.
**Link to get Microsoft Office 365:**


Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads