Index and Match Formula in Excel Hindi

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: drive.google.c...
----------------------------------------------------------------
Related Videos:
1. Drop Down List:-
• How To Create Auto Upd...
2. Vlookup and Match Function:-
• How to Use Vlookup wit...
3. Vlookup Function:-
• Vlookup Formula in MS ...
________________________________________
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: ...
Facebook : / powerex-by-jitendra-10...

[@veenanegi-tr4kp]

Aapki video ache se samajh aati aati i mean to say aapka samjhane ka tarika it's very nice thanks sir itni nice video banane ke liye

[@veenanegi-tr4kp]

Your video is very nice

[@deepakdalal8731]

Very nice sir.ji👌👌👌

[@PowerExbyJitendra]

Thanks and welcome

[@AmitGupta-bl2iu]

Best👍💯👍👍

[@PowerExbyJitendra]

Thanks Amit

[@SehrawatFitHealth]

nice sir ji.. 👍

[@PowerExbyJitendra]

Thanks Rahul ji

[@mdubaidasim3093]

Excellent

[@PowerExbyJitendra]

Thanks

[@priyavicky3131]

Nice👌👌

[@PowerExbyJitendra]

Thank you! Cheers!

[@MirMdFariduddin1980]

Same data are present in different cells of different columns.say "Farid" is present in B2,C5,D1,E4,etc. Now how can I extract" Farid " in say A cell? Plz guide me with your valuable information .

[@TanvirMostofa]

Dear sir,
I am facing some problems with the index match function (Vba macro Excel)
But i can not explain. I want to share an excel file to describe . I need help. Please help me . If you want to help me, please send your mail address to share the file.