Courtsey of Youtube.This Video content is delivered to you directly from Youtube.com

Index Match Function in Excel in Hindi Simple and Easy- Better then Vlookup

Uploaded by: asthetic011

319356 views

Pivot Table - Super Trick

1026432 views • 06-04-2014

Top 40 Excel Shortcuts in Hindi

878352 views • 05-06-2018

More videos  

Download Practice File here Index match Function in excel is one of the most powerful lookup function of excel, It overcomes all the limitations of VLOOKUP Function in Excel. It is the combination of two function in excel. Index Function and Match Function. Index Function have mainly two arguments first one is range i.e array and second one is column number or Row no.. Match Function unlike Index function having three arguments look up value, table array, and Match Type. In VLOOKUP Function There are some limitations like you can look up rightwards only, Vlookup is case sensative, You cannot insert new column in table array etc. Index Match is faster then VLooKUP, in INdex MAtch you not need to count columns of the table array. It can look up vertically and horizontally also. What inspired me to make this video on Index Match Hindi in Excel I did see many videos on on index match but they explained it as it is in the same language which you can find in help in excel. Secondly, Most of the videos tried to explain it simultaneously which is hard to grasp at once. because Index function brings value of target cell and Match Function brings number of the particular cell. In this video I divided application of function in three parts. First I explained how Index Function works, Second I explained how Match function works and then I explained how the combination of index and match function works. I did not just stop there, I also explained the limitations of VLOOKUP by applying it with INDEX MATCH side by side. IndexFunction MatchFunction EasyExplain Index Match function works in all office version starting EXCEL 20007, 2010, 2013 and Excel 2016. Even in Office 365 as well.

Please select the category that most closely reflects your concern about the video, so that we can review it and determine whether it violates our Community Guidelines or isn't appropriate for all viewers. Abusing this feature is also a violation of the Community Guidelines, so don't do it.

Oops, your web browser will be unsupported soon.

Our site is optimized with a wide range of browsers, please upgrade to a modern, fully supported browser. Find the latest versions of supported browsers below.

Get Latest

FireFox

By Mozila

Internet Explorer

By Microsoft

Chrome

By Google