Uploaded by: asthetic011319356 views
Excel VLOOKUP formula with Multiple sheets vlookup in Excel in Hindi
1403835 views • 16-05-2016
Excel क य Formula अपक सर थकन मट दग Work Smarter Not...
743975 views • 04-09-2017
EXCEL Magic Create 100000 salary pay slip in 1 Second Print 2,4,6,8 Slips Per ...
404221 views • 10-02-2019
Excel Complex Lookup Find Header based on Lookup Criteria in Matrix with INDEX ...
79052 views • 17-08-2017
The New XLOOKUP Function Compared to VLOOKUP INDEX MATCH in Excel
28658 views • 5 month(s) ago
Excel म Macro सखल घट क कम मनट म हग How to Use Mac...
887737 views • 14-07-2018
COMBINE Multiple Excel WORKBOOKS into One ExcelJunction.com
940508 views • 18-06-2017
Using Lookup Formula in MS Excel 2007 Tutorials in Hindi Part 23
726594 views • 08-01-2015
INDEX MATCH Excel Lookup Functions - All You Need To Know in 10 Minutes EMT 161...
12830 views • 2 month(s) ago
MACRO PART-1 Advanced Excel 2019 Powerful Function in Hindi Amazing Use of Macro...
244558 views • 02-05-2018
Lookup and Find the 2nd, 3rd, or the Nth Matching Value in Excel
187524 views • 05-07-2017
How to create a Pivot Table in Excel Pivot Table Excel
540150 views • 21-04-2017
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.