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

[@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 ❤️❤️

[@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..❤❤

[@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 ❤️

[@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

[@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

[@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

[@abhinavsinghchauhan2127]

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

[@Innozant]

Thanks 👍

[@arijeetkumarsharma226]

Guru ji, your all videos are awesome.

[@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❤️

[@dominatorgaming2980]

Bhai ek no. channel hai ye excel ke liye.

[@Innozant]

Thanks dear

[@Demon07291]

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

[@Innozant]

Thanks Shubha

[@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.

[@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.❤️👍

[@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

[@diwanshusharma8219]

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

[@Innozant]

Keep learning dear..👍❤️

[@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

[@KuKu_247]

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

[@Innozant]

Thanks Kalyan

[@rupamsingh9787]

Sir you are the bestest of the best.

[@Innozant]

Thanks Rupam

[@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

[@taxbazaar7364]

I appreciate your hard work, sir.

[@Innozant]

Thanks

[@sourabhmaurya6225]

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

[@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

[@msports4522]

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

[@daynight6875]

Bhut hi shandar sir..

[@amanvarma8032]

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

[@Innozant]

Hahaha.. thanks

[@hemantgusain1260]

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

[@Innozant]

Thanks for valuable appreciation dear 🤗

[@akak3585]

Thank you very much sirG

[@DeepakKumar-is2kh]

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

[@davidsonsunny2886]

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

[@Innozant]

Thanks dear.Happy learning

[@aakankshasrivastava9497]

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

[@Innozant]

Thanks Aakanksha..Hv a wonderful day ahead..

[@Herukamahesh]

❤MAN OF THE MATCH❤❤❤

[@virendersroha1754]

Sr 2nd q me Ary puri select kr skte h

[@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

[@omkarchimbalkar5912]

Excellent teaching

[@Innozant]

Thanks Jay

[@rajeshmane9616]

Very good teaching method.

[@Innozant]

Love you all🙏❤️Keep supportung

[@nagarajgb5053]

Super ji🎉

[@surajitmaji1348]

Bahut khub...

[@anshumsahu4940]

Thank you..informative video

[@Innozant]

Thanks Anshum..Happy learning dear❤️❤️

[@staterolife1651]

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

[@Innozant]

🙏♥️🙂 Thanks.

[@dhanashreesawant5970]

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

[@Innozant]

Thanks dear.Happy learning ❤️

[@PriyankaSingh-yi9io]

U r so brilliant sir

[@Innozant]

Thanks Priyanka.Have a wonderful career ahead ❤️

[@arunkumarsinghark3024]

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

[@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.

[@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.

[@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???

[@l.n.j.collegejhanjharpur4134]

Thanks a lot...great explain the topic

[@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.😀

[@avinvashisht5979]

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

[@Innozant]

Thanks Avin for your valuable appreciation ❤️❤️

[@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

[@bhoopendraraghav9781]

Very well explained sir g.

[@Innozant]

Thanks Bhoopi Sahab.

[@mahaboobhossain5076]

Excellent video brother

[@Innozant]

Thanks dear

[@tarulatabhatt4037]

VERY GOOD EXPLENATION.THANK YOU.

[@Innozant]

Thanks for your valuable comment

[@RISHABHSINGH-gy3uv]

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

[@Innozant]

👍❤️

[@roshan3113]

Thanks sir.apkaa मंगल ho.

[@deepakchauhan4974]

well explained sir, understood properly

[@Innozant]

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

[@sudhirsharma1874]

Very unique way of explaining concepts.

[@Innozant]

Thanks Sudhir Ji❤️🙏

[@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

[@KuldeepSingh-nq1vi]

Great Video Sir

[@Innozant]

Thanks

[@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

[@kishanagravat7319]

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

[@Innozant]

Thanks Kishan Ji

[@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.

[@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

[@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.

[@SachinKumar-sl3ue]

If colum have repeated numbers ???

[@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..😊

[@shrikantbadge3978]

Great Sir. Very dynamic. Thanks.

[@Innozant]

Thank Shrikant .Hv a nice day

[@nrskohat1114]

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

[@karankapoor200]

great sir👌🏻👌🏻👌🏻

[@Innozant]

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

[@blossomashok]

Very nice video

[@gopallaltailor7888]

Nice sir❤❤

[@battlefansshorts8941]

Thanks sir#❤🌹😊

[@Innozant]

Thanks Ravi ji

[@RohitSingh-df6nj]

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

[@Innozant]

Thanks Rohit ji❤️

[@TECHNOGautam]

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

[@tahirurrehman6870]

Sir i need practice material,where can i find?

[@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…

[@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.

[@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🇵🇰🇵🇰❤️

[@vijaysahal4556]

good sir 👍🏻👍🏻👍🏻👍🏻

[@YashSharma-oe5bt]

Sir I am not getting the link of download the practice sheet based on playlists

[@Innozant]

Dear Yash..Kindly check master assignment link in video description.. Direct video link is broken now..m working on it to restore that

[@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

[@VimalKumar-ih6ik]

Beautiful

[@sydulislam7995]

Awsome!

[@SinghSurinder16]

Superb

[@Innozant]

Thanks Singh Sahab 🙏❤️

[@vishwadeepak4126]

Sir, mere pass file name book 1 excel me Emp Name and uska DL No. hai uske aage mujhe cab Number lana hai. Dusare Excel file name book 2 me 1st column me cab no. and 2nd column me DL No. hai jahan se mujhe book 1 me cab no. value as output lana hai. Vlookup with choose ke though to maine kar liya but index and match se kaise hoga. Please help me sir its urgent I have send file in your email ID

[@Innozant]

Ok..free time me check krte hain apke query ko..itna jaldi nhi dekh payenge dear..bht jyada workload rhta hai❤️

[@sapibkhansapibkhan8560]

Nice sir g

[@sverma7798]

Gajab

[@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

[@pankajverma-sh2hb]

Great

[@Innozant]

Thanks Pankaj Ji🙏❤️

[@mghosh1578]

Thanks

[@Innozant]

Thanks dear❤️

[@huzaifahshah3841]

Good sir but where is Vlookup function because this is vlookup series not index?

[@Innozant]

Dear it's lookup maharaj series .. And any function able to do lookup is a part of lookup series functions. E.g choose ,indirect,index,offset😊

[@huzaifahshah3841]

@@Innozant thanks sir yours reply v happy

[@yogeshrao5924]

Good

[@kushaljindal8430]

Sir,my value is not changing automatically.......but formula is correct

[@Innozant]

You are doing some mistake kindly check it

[@gauravbhatia7987]

Thnq sir

[@Innozant]

Thanks 🙏👍👍❤️

[@sharkthinks3038]

mazedar

[@Sudhir_vhra]

Bhai mai job karta hu mera data karge h tum apne hisab se ek workbook me batate ho mujhe huge workbook pe work karke index match lagana h column me data aa raha h jab formula pest kare niche ki row me to data nahi aa raha error aa raha h bata do bhai koi esa video nahi banate ho mujhe ek sath index kagagkar total row me data lana h ek sath

[@chowdhurysunzidmahbub79]

How to search Right to Left?