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:
#ramgopalexcel
This video is created by Ramgopal from Presentation Process in Excel 2016 for Office 365. Visit Presentation-Process.com for more.
**Link to get Microsoft Office 365:**

Disclosure:…

Post Author: OfficeTutes.com

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