Index and Match Formula in Excel Hindi

This easy and simple tutorial is all about Index Match Function in Excel. 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.
----------------------------------------------------------------
Download Exercise File: https://drive.google.com/file/d/1WSU9-gKzFN5Q8VFn6acLa8D-wLsZSVdd/view?usp=sharing
----------------------------------------------------------------
Related Videos:
1. Drop Down List:-
https://youtu.be/YQEGlaghtBI

2. Vlookup and Match Function:-
https://youtu.be/54mWSjpZNdg

3. Vlookup Function:-
https://youtu.be/I_33jLRvqmQ
________________________________________
Please SUBSCRIBE our channel.

Video is published on Powerex by Jitendra
#indexmatch
#powerexbyjitendra
#excel



Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research.

Fair use is a permitted by copyright statute that might otherwise be infringing.

Non-profit, educational or personal use tips the balance in favor of fair use.

Contact Us:
Instagram: https://instagram.com/kumarjitendra11?igshid=zd7v216sfxr7

Facebook : https://www.facebook.com/PowerEx-by-Jitendra-108422660912839/