MENU

Fun & Interesting

How to use Excel Index Match | Index + Match Function Example Series Best Explanation in Hindi

Innozant 127,686 5 years ago
Video Not Working? Fix It Now

Learn how to use index + match function in excel for one way and two way lookup Watch this video tutorial to find out how you can use Index & Match for simple and complex lookup problems. Simple and to the point explanation for you. Why index match is better than vlookup & why use index match instead of vlookup? 1. VLOOKUP, which searches only to the right, INDEX and MATCH can look in both directions – left and right. 2. INDEX & MATCH can perform two-way lookups 3. INDEX & MATCH is less prone to errors 4. INDEX and MATCH is more flexible than VLOOKUP. 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-IndexExample1.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... #index+match#Innozant #indexmatch #Indexmatchfunctionexcel

Comment