Mastering Excel - INDEX Function Explained (An Alternative to VLOOKUP) | How to use Excel Index - the right way

In this video explained INDEX formula as an alternative to VLOOKUP in Excel. The INDEX function will return the value at a given position in a range or array. The INDEX function is often used with the MATCH function. INDEX has 2 different uses: 1) look up a value that is at the intersection of a row and column 2) look up a specific table and then within that specific table look up a value that is at the intersection of a row and column. Download the Assignment Master Practice Folder here (All Playlist Example at one place) https://drive.google.com/drive/folders/1y5h4SMwPLk12xZ2-2U1SDBIQqyH5bz4P?usp=sharing Playlist Folder-Excel Lookup Functions-IndexExplained.xlsx) Website - "http://www.innozant.com" Let's Connect: Instagram ►http://www.instagram.com/innozantoffi... Facebook ► https://www.facebook.com/innozant Twitter ► https://twitter.com/innozant Linkedin ► https://www.linkedin.com/company/inno... #indexfunction #Innozant #indexmatch #Indexmatchfunctionexcel