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

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)
drive.google.c...
Playlist Folder-Excel Lookup Functions-IndexExample1.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#index+match#Innozant #indexmatch #Indexmatchfunctionexcel

[@artibhavsar6570]

TX sir apne to mera excel sikhane ka problem he solve kar diya. Me time nikal ke har roj video dekhake practise karti hu. Or abhi to samaj me bhi ane laga he. Apak bahut bahut 🙏 sir

[@Innozant]

Thanks Arti..Happy learning dear..God bless you..❤❤🙏🙏

[@sohansharma1770]

Arti from ahmedabad ?

[@shoaibwarsi3338]

Wow sir kaash main india main hota every teacher is brilliant teacher 👌👍 love your style sir 🇵🇰

[@AnilPatel-wz6qy]

Anilbhai d patel Sir.you are great sir Sir me 50 se jayda program sabake dekhe Lekin apke padhaneka tarika sabar alag stayil to lajab hai Thankyou sir

[@Innozant]

Love you dear.. Thanks..Happy Learning ❤️❤️

[@davidsonsunny2886]

Underrated channel . Dileep Jha is an excellent tutor . Subscribed

[@Innozant]

Really means a lot to me

[@dipak5651]

I don't think there is any other channel which can teach us Index and match so effortlessly as you are teaching. Jabardast 😊

[@Innozant]

Thanks.Keep learning

[@kritikasingh2210]

YOU are best sir, thanku, m kabse isi cheez ka solution dhundh rhi thi.... or aapne itni asaani se kraa diyaa. Thankyou Sir.

[@Innozant]

Thanks dear..Keep Learning ❤️

[@AmitMishra-hc6nd]

Bahut sari videos dekhi but aaj samajh aya! Sir aapne jo baat baar baar boli array wali usi se mujhe samajh aya aaj index match

[@Innozant]

Are wah..Good Hai...chalo finally..❤❤

[@rastogipradeep]

Just from today i've started watching your videos. Your teaching method is amazing. No doubts left after your videos. Your efforts are really appreciable. Hats off to you sir.

[@Innozant]

Thanks Pradeep Ji.. Recommended you to start your learning journey step by step in sequence

[@sandeepaswal8944]

Namstai Sir Ji. Index + Match Bahut hi achai sai samja diya. Your teaching super. Aap point to point describe kartai ho.

[@Innozant]

That Aswal sahab..Keep watching ,learn and enhance your skills

[@abhinavsinghchauhan2127]

bhaut hi simple aur saral bhasa me,,,,nice video

[@Innozant]

Thanks 👍

[@arijeetkumarsharma226]

Guru ji, your all videos are awesome.

[@rahulkumawat5102]

Thank you so much sir.... I have a lot from your many of videos.... It's helpful in my office work as well...... I will be learn continuously as well. Thank you again 🙏

[@Innozant]

Thanks.keep learning

[@hemendrakumarvarshney8825]

A gr8 teacher like you is creating a fission reaction effect.. so simple and lucid way of teaching. 👏👏👏👏👏🙏

[@Innozant]

Thanks . Really means a lot to me.

[@dominatorgaming2980]

Bhai ek no. channel hai ye excel ke liye.

[@Innozant]

Thanks dear

[@swatijohari5557]

ive gone through several video..for index and match use...This one is super Easy and with excellent explanation..Thanks a lot!!

[@Innozant]

Thanks Swati..We welcome you @innozant family to experience the taste of Success.❤️❤️🙏🙏 Really means a lot to me❤️

[@diwanshusharma8219]

Thnq sir Muje excel class me itne acche se smj ni aaya jaisa aapne explain kiye sir😊🙌🙌🙏🙏

[@Innozant]

Keep learning dear..👍❤️

[@aaqibchaudhary786]

amazing video, very formal way to teach. I watche all video of this chennal.

[@Innozant]

Thanks dear.. Recommend you to start your Learning journey from playlist Basic Excel onwards.❤️👍

[@Demon07291]

LAST WALA TO BARIYA THA SIR JI....BIG LOVE FOR YOU

[@Innozant]

Thanks Shubha

[@Sekhar_Home]

Teaching too much awesome. Its help me in Office productivity

[@Innozant]

Thanks dear

[@zakirhossain7413]

i like your way of teaching. Thank u. Love from Bangladesh.

[@Innozant]

Thanks Zakir Hossian sahab..Happy learning dear

[@sourabhmaurya6225]

Thank you sir your videos help me a lot...🙂

[@rupamsingh9787]

Sir you are the bestest of the best.

[@Innozant]

Thanks Rupam

[@KuKu_247]

too much batter by Vlookup & hlookup, thanks for sharing valuable Index & Match formulas advantage

[@Innozant]

Thanks Kalyan

[@taxbazaar7364]

I appreciate your hard work, sir.

[@Innozant]

Thanks

[@msports4522]

Very Nice 👍 Sir, I am very near to left your video but I find what I want. Thanks.

[@omkarchimbalkar5912]

Excellent teaching

[@Innozant]

Thanks Jay

[@daynight6875]

Bhut hi shandar sir..

[@hemantgusain1260]

Thanks you sir for explaining index match with such a easy way.

[@Innozant]

Thanks for valuable appreciation dear 🤗

[@aakankshasrivastava9497]

Welldone Sir👍Thanks for clearing the concepts with each possible solutions..

[@Innozant]

Thanks Aakanksha..Hv a wonderful day ahead..

[@akak3585]

Thank you very much sirG

[@amanvarma8032]

Thanks Sir, Excel me Gadha Majdoori Karne se bach gaya main. Pranaam.

[@Innozant]

Hahaha.. thanks

[@daynight6875]

Sir me user form bhi shikh rha hu or usme bhi aapke videos bhut help krte👌👌 he pls.. Sir user form ki playlist bhi bnaiye....🙏🙏🙏🙏

[@Innozant]

Sure dear

[@DeepakKumar-is2kh]

Very nice video, I have learned a lot of things. Keep on

[@nagarajgb5053]

Super ji🎉

[@davidsonsunny2886]

Excellent tutoring brother . It is always a learning experience watching your videos

[@Innozant]

Thanks dear.Happy learning

[@abhishekshirsekar2065]

Ur alway great sir ,u save lot of my time m ragar to meet u sir (Maharashtra/mumbai)

[@Innozant]

Thanks Abhishek Ji for such a valuable feedback.Offcourse dear will meet ..Aayenge Mumbai Darshan krne to jaroor mulaquat hogi humari.Life me seekhna Kabhi mat band Karna hai..Ok...aage badhte rahiye..👍❤️🙏

[@madhavtewary2421]

very good explanatory video sir!

[@Innozant]

Thanks Madhav

[@surajitmaji1348]

Bahut khub...

[@dhanashreesawant5970]

ty sir great explanation. I was struggling to understand index match.Thanks alot😊

[@Innozant]

Thanks dear.Happy learning ❤️

[@rajeshmane9616]

Very good teaching method.

[@Innozant]

Love you all🙏❤️Keep supportung

[@anshumsahu4940]

Thank you..informative video

[@Innozant]

Thanks Anshum..Happy learning dear❤️❤️

[@Herukamahesh]

❤MAN OF THE MATCH❤❤❤

[@KuldeepSingh-nq1vi]

Great Video Sir

[@Innozant]

Thanks

[@PriyankaSingh-yi9io]

U r so brilliant sir

[@Innozant]

Thanks Priyanka.Have a wonderful career ahead ❤️

[@staterolife1651]

Sir it was very useful function. Thank you sir.be continued..

[@Innozant]

🙏♥️🙂 Thanks.

[@l.n.j.collegejhanjharpur4134]

Thanks a lot...great explain the topic

[@gopallaltailor7888]

Nice sir❤❤

[@battlefansshorts8941]

Thanks sir#❤🌹😊

[@Innozant]

Thanks Ravi ji

[@deepakchauhan4974]

well explained sir, understood properly

[@Innozant]

Thanks Deepak Ji..Happy Learning dear..Have a great day ahead

[@avinvashisht5979]

Thank u so much sir ....for your detailed explanation

[@Innozant]

Thanks Avin for your valuable appreciation ❤️❤️

[@karankapoor200]

great sir👌🏻👌🏻👌🏻

[@Innozant]

Thanks Karan ,Ajkal Kahan gayab hain..bht kam practice kar re h

[@bhoopendraraghav9781]

Very well explained sir g.

[@Innozant]

Thanks Bhoopi Sahab.

[@RohitSingh-df6nj]

Dear Sir, Thanks a lot...great explain 👏👏👏

[@Innozant]

Thanks Rohit ji❤️

[@TECHNOGautam]

sale tera niklaa value kya ye bta suar >>>>>>>>>>>>???

[@blossomashok]

Very nice video

[@tarulatabhatt4037]

VERY GOOD EXPLENATION.THANK YOU.

[@Innozant]

Thanks for your valuable comment

[@mahaboobhossain5076]

Excellent video brother

[@Innozant]

Thanks dear

[@shrikantbadge3978]

Great Sir. Very dynamic. Thanks.

[@Innozant]

Thank Shrikant .Hv a nice day

[@arunkumarsinghark3024]

🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l 🌷🌷सीखते रहो, सिखाते रहो 🌷🌷🙏👍

[@sydulislam7995]

Awsome!

[@mohiniverma81]

Please tell me while doing vlookup, hlookup or index match we are freezing row and column right, freezing row we have to freeze column three times and vice versa plz explain me in detail

[@roshan3113]

Thanks sir.apkaa मंगल ho.

[@vijaysahal4556]

good sir 👍🏻👍🏻👍🏻👍🏻

[@mahaboobhossain5076]

Getting multiple values with array formula by index and match that vlookup function can not do it in that case using iferror index if small and row function with aggregate function will do the job brother.Aap ka video bohot accha lagta hain.Dilip Sir aap ka har ek video outstanding.I like every video.

[@Innozant]

Aayenge complex example bhi pehle sabko concept seekhayen phir aate hain maidaan me amazing Questions ke saath.😀

[@kishanagravat7319]

I Have watched many videos but no one has explained the way you have.

[@Innozant]

Thanks Kishan Ji

[@bishtlokesh1297]

This is very simple function

[@Innozant]

Kuch aage aane wale me example me milte hain ki kitna simple..abhi to aagaj hua hai dear.😀

[@phonekegyame1431]

Thank you sir

[@Innozant]

Thanks

[@SinghSurinder16]

Superb

[@Innozant]

Thanks Singh Sahab 🙏❤️

[@sapibkhansapibkhan8560]

Nice sir g

[@sverma7798]

Gajab

[@VimalKumar-ih6ik]

Beautiful

[@satishojha6240]

Good morning sir thanku for index match concept.But I think Index match functions use the data in large size otherwise vlookup is best only for right side value will be taken.have nice day sir

[@Innozant]

Good morning,Yes vlookup bus more optimized in compare to other.abhi kuch din index ki tareef phir disadvantages bhi ginayenge..😊

[@pankajverma-sh2hb]

Great

[@Innozant]

Thanks Pankaj Ji🙏❤️

[@sharkthinks3038]

mazedar

[@sudhirsharma1874]

Very unique way of explaining concepts.

[@Innozant]

Thanks Sudhir Ji❤️🙏

[@vikramkumarReg.office]

bhai....m ek table se index function lgane ki kosis kr raha hu....but m failed to get it done. Could you please do this for me. Great support from your side if possible.

[@siddharthdharmadhikari1704]

Hi sir, video is superb and very easy to understand, thanks u for such a informative video. I have one concern While practicing this sheet I am facing one issue the $ sig is not populating in formula as well as obtained value. Only 9 value found instead of $9.00. Is their any key for selection of unit like ($). Please clarify.

[@Innozant]

Didn't get your query ..You want to freeze the column and row then use F9

[@virendersroha1754]

Sr 2nd q me Ary puri select kr skte h

[@eklachaalo]

Sir mere pas ek payment wala sheet ha, usme se kuch payment ho gaya,but second time jab firse payment dunga toh usme se hume kaise pata chalega ke konsa payment huya hai or nehi.please help. mai vlookup se karta hu but usme ek hi nam ka dusra koyee hai wo aajata ha.bahati problem ho raha ha.

[@virendersroha1754]

Sr 2nd Q me Ary total select bhi le skte h

[@Innozant]

Kya khna chahte h nhi aaya smjh ..repeat kijiye

[@virendersroha1754]

@@Innozant mera mtlb ye h ki 2nd Q me apne aray pura kyu ni select kiya pura be to select kr skte h

[@yogeshrao5924]

Good

[@gumnaam6068]

If I want to highlight the table's cell for the data that the formula retrieved, how to do that. I tried doing it through conditional formatting but couldnt figure. Pls tell if possible. Like main chahta hu, table ka wo cell bhi highlight ho jaaye jaha se wo data fetch ho ke aaya hai, as soon as I type the formula and hit enter.

[@gauravbhatia7987]

Thnq sir

[@Innozant]

Thanks 🙏👍👍❤️

[@mghosh1578]

Thanks

[@Innozant]

Thanks dear❤️

[@shikhathecreative6675]

maine last k question me match reverse kraa like phele location ka match then product ka match to ye output nhi dera ... kya index match phele vertical match then horizontal match ke rule pr chlta h aise cases me???

[@soniabhi8327]

Sir. Index match me duplicat value me 1st velue hi aati hai.. 2n value count nahi hoti.. pls samjaye.. dept. No. Brnch D1 316.61 m1 D2 520.49 m1 A5 520.49 m2 No. Ki value se muje brnch aur dept. Lena hai.

[@RMKserve]

I am back on your channel after long time. I am not able to find look up function, index match, direct, off set, video. Please tell me in which play list these videos are availble❤️❤️🇵🇰

[@Innozant]

Lookup besic to advanced playlist is there .kindly restart your learning journey ❤️

[@RMKserve]

Thank you i found it🇵🇰🇵🇰❤️

[@RISHABHSINGH-gy3uv]

index match right drag aur down drag me kam karega agar karega to kon sa cell freeze karu sir

[@Innozant]

👍❤️

[@traderpankaj33]

🎉🎉🎉

[@HoneySingh-ds1rm]

Aapne bola column nhi hain match use karte samay par product column to hain .plz thoda samjha dijiye .main look up and match ,index me naya hoon

[@saddamtexcell857]

Sir if my look up value contain same name multiple times in a row with different dates and class then which formula i will use to get the date between 31-1-2023 to 31-1-2023…

[@nrskohat1114]

i want to find out age wise, genser wise and class wise strength, which formula will be applied

[@SachinKumar-sl3ue]

If colum have repeated numbers ???

[@mkeverything6867]

Sir mere paas ek badi list hai usme se mujhe 4 value ek saath match karani hai vo bhi uske saare columns or rows bhi kese nikalenge

[@Innozant]

Detail explanataion ke saath query @innozantofficial par share kijiye ..will guide you

[@raajkumar-kf5cu]

Sir mujhe digit plase holder sikhna hai

[@mahaboobhossain5076]

Dynamic offset function with sum function video need plzzzz

[@Innozant]

Lookup series ke videos sequence me upload ho rahe hain..match Index,choose,indirect phir aayeg ano. Offset ka..have patience.😊

[@mahaboobhossain5076]

@@Innozant thankx

[@sharesbest5867]

Superb bro

[@prashanttyagi1156]

Sir mere pass data hai , coloum a co. Name, coloum b product name is repeted, coloum c is qty, coloum d in product I'd, mujhe doosre sheet metn result mein a coloum mein sare product I'd hai aur single product name alag alag coloum mein hain, mujhe index match ke through product ki qty chahiye coloum mein product wise. Bahut kiya ho nahi paya. Any solution.

[@Dinesh-hv5ip]

goodone

[@Innozant]

Thanks Dinesh

[@tahirurrehman6870]

Sir i need practice material,where can i find?

[@satender7625]

❤️