Index + Match Function in Excel - Father of Vlookup || Best Ever Explanation in Hindi
ฝัง
- เผยแพร่เมื่อ 7 ก.พ. 2025
- index match function in excel - Watch this video tutorial to find out how you can use Index & Match for more complex lookup problems which cant be solved by vlookup. when we use index match together its became more powerful than vlookup. This video shows you how Index Match works with simple and to the point best explanation. It first shows you how Index works on it's own and then how Match works and then puts the two Excel functions together. watch this video to know about index match excel formulas in hindi in ms excel 2007 2010 2016 2013.Father of Vlookup
My New Channel : bit.ly/3qFrbl5
Complete Microsoft Word Tutorial : • How To Do Office Work ...
Complete Powerpoint Tutorial : • MS Power Point Tutoria...
Xlookup Complete Tutorial : • What Xlookup Can Do Fo...
Vlookup Complete Tutorial : bit.ly/2K0C1Sb
Excel All Formulas : • 40 most useful excel f...
Office Work in Excel : • 🤓 How To Do Office Wor...
Download Training File drive.google.c...
Index Formula in Excel - Vlookup से भी Powerful कैसे है ये index function - देखिये
• Index Formula in Excel...
Match function becomes more powerful when it is used with other functions.. this match functions do magical works with other formulas. must watch below list of videos.
1. How To Use Match Formula In Excel in Hindi
• How To Use Match Formu...
2. Index + Match Function in Excel - Father of Vlookup || Best Ever Explanation
• Index + Match Function...
3. How To Use VLOOKUP With MATCH Function In Excel || 2D Lookup || Hindi
• How To Use VLOOKUP Wit...
4. Hlookup With Match Function in Excel in Hindi
• Advanced MS Excel - Hl...
VLOOKUP VIDEO SERIES:
1. vlookup in excel with example in Hindi
• Vlookup in Excel With ...
2. How to use vlookup for multiple values || Trick to use vlookup for large data
• सारा Data एक बार में V...
3. Vlookup in multiple sheets in excel || In Hindi
• Vlookup in multiple sh...
4. How To Use Double VLookup in Excel-Nested vlookup
• How To Use Double VLoo...
5. Dynamically Updated Vlookup Formula in Excel
• How To Make a Dynamica...
6. How To Use Vlookup With Multiple Excel Workbooks
• How To Use Vlookup in ...
7. HLOOKUP in excel with example in Hindi
• HLOOKUP in excel with ...
8. lookup Magic 😮 Trick - Vlookup नहीं Smart Vlookup 👌 सीखो अब..
• Vlookup Magic 😮 Trick...
9. Index Formula in Excel - Vlookup से भी Powerful कैसे है ये index function - देखिये
• Index Formula in Excel...
10. How To Use Vlookup 👉 For Multiple Lookup Values In Excel
• Vlookup in Excel in Hi...
11. How To Create Picture Lookup In Excel 👉 image vlookup लगाना सीखो 😎
• How To Create Picture ...
12. Index + Match Function in Excel - Father of Vlookup || Best Ever Explanation in Hindi
• Index + Match Function...
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP ►
• How To Make Passport S...
Subscribe Deepak EduWorld ► / deepakeduworld
Instagram ► / deepakeduworld
Facebook page ► / deepakeduworld
LinkedIn ► / deepakedu. .
Facebook Group ► / cse92
We Always Provide Useful & Helpful Content On The Deepak Eduworld TH-cam Channel, Here MS Excel Tips And Tricks, And Tips And Tricks For MS Word, And Internet Tips And Tricks, Along With The Computer Related Useful Information In Simple Hindi Language. I You Can Visit Our Channel Playlist's. It Is Our Effort To Get This Information Useful For All Types Of Excel Users, MS Word Users, Computer Users And Internet Users.
Tags:
#Deepakeduworld, deepakeduworld, excel tutorial, index match function in excel, excel tips, computer tips, deepak nehra,
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](/img/n.gif)
दोस्तों ये वीडियो आपको कैसा लगा ? आपके मन में जो भी विचार है हमें Comments मै लिख के जरूर बताएं 🥰
*My New Channel :* bit.ly/3qFrbl5
*Complete Microsoft Word Tutorial :* th-cam.com/video/Xkq0-xXAj48/w-d-xo.html
*Complete Powerpoint Tutorial :* th-cam.com/video/OekrBhNybP0/w-d-xo.html
*Xlookup Complete Tutorial :* th-cam.com/video/0LjfRVD7srU/w-d-xo.html
*Vlookup Complete Tutorial* : bit.ly/2K0C1Sb
*Excel All Formulas :* th-cam.com/video/C9y53fedo04/w-d-xo.html
*Office Work in Excel :* th-cam.com/video/PT8D1qQwe1k/w-d-xo.html
bht bakwas tha.. kam ki bat km bakwas pahle sunni padti h
बहुत ही अच्छी तरह से समझाया है आपने। दरसल ये सच है कि मैं आपकी ही वीडियो देख कर इसे कर पाया। लेकिन मैं ये भी कहना चाहता हूं कि ये वी लुक अप से सिर्फ़ इसी मामले में आगे है कि ये दोनों तरफ़ के डेटा दे सकता है लेकिन ये सिर्फ़ एक ही डेटा दे पाता है। अगर हमें किसी स्टूडैण्ट के सारे डेटा एक साथ प्रिण्ट आउट के लिये चाहिये तो ये इस काम को नहीं कर सकता जब कि वी लुक अप सारे कालम्स के डेटा एक बार में डिस्प्ले कर देता है, इसीलिये वी लुक अप की उपयोगिता कभी समाप्त नहीं हो सकती। ये सिर्फ़ स्टूडैण्ट के नाम के साथ उससे जुडे किसी एक डेटा को एक बार में बता सकता है (फ़ादर्स नेम, रोल नम्बर, किसी सब्जैक्ट के नम्बर इत्यादि) पर ये सारे डेटा एक साथ नहीं दे सकता जो वी लुक अप आसानी से दे देता है, अत: ये सिर्फ़ चैक करने के लिये ही ठीक है। ये रोल नम्बर से स्टूडैण्ट को भी नहीं ढूंढ सकता उसके लिये इसका अलग से दूसरा वर्जन तैयार करना होगा।
very well clarify the formula and i am very happy how you shown by break up of formula 👍 now i am your subscriber..
BHAI thank you thank you very much me ye aek formula janta nahi tha or isi vajah se kafi din se mera project atka hua tha but ap ne aj bata ya to kayi dino ka baki project mera khatam ho gaya ........ agian thank you very very much sir......
Hi Deepak,
I am working in Aditya Birla Group in Dubai for past 4 years in Field of Excel Automation.
And i must appreciate you for the way you are explaining to the learners.
I usually do not see the basic videos but your thumbnail was too attractive to refuse.
Kudos to Excel.
Also in case you or any of your excel enthusiastic friend want to join for some role ill be happy to help.
From
Mudit Lalwani
Hi Deepak... Any opportunity for PPT and excel skillset
Hi Am looking for the same
😳
L
Xlookup is really best bhai... And the way u taught me... Bhai.. Nxt level tha...bhot shukriya... Indexmatch b sahi h lekin complex hai... But xlookup mast h
Very Helpfull Video Just Extracted data after watch watching ur Video...Thanks
Sir aap ka video bahut acha lagta hai
😊😊😊❤️
thanks dipak sir ji aap bohat acha Kam kar rahe ho .ek kahavat he Gyan batne se Gyan badhta he.
most of your video I am watching. Its very helpful. Thank You
Bundle of Thanks Sir Ap Ney kafi Intizar Karwa. Zara Jaldi Jaldi Video Launch Karin.
Ok g.. My sechudle was too busy.. But now i will try to publish videos regularly
Very nice approch mr deepak,
Really your teaching style nd examples are very helpful..... thanks you so much....
thank you sir ji very much you are best teacher 🙏👍
thanks bro, tons of love from Pakistan
Finally i learned it thank you
Thank you So much Deepak Bhai for your wonderful work. You're an Angel and Blessing in disguise. Bow to the Excel King, Excel Knight. God Bless!
Thank you very much deepak apke sare excel video mere liye bhut helpful hai
Ham apka Excel ka total video dekh rahe hai
Advance Excel ❤
thanx buddy. was tring to apply multiple match function with Index but I was getting confused. video helped me to get the huge number level.
सर मेने आपके विडियो से बहुत कुछ सीखा हे तो आप मेरे टीचर हुऐ और आज आपको कैसे भूल सकते है
" Happy Teachers day "
Thanks for Teach us
Thank you very much...Deepak sir....You are my literally inspiration in IT field.
Apka tutorial bohot hi powerful hai
Very interesting style se smjhaya apne Thnk you so muxh
🤗😊
Great learning video again. Thanks.
Starting se table ka define krege to aur jada better hoga .. because beginners k lie bhi acha h..phle se hi table and sb rkha hota h apne
Deepak sir, your way of teaching is very good. You are best teacher
🐨🐯🐮🐷🐮🦊🐮🐻🐰🐯🦊🐯🐯🐯🐯🐯🐯🐯🦊🐰🦊🐹🐯🐰🦊🦊🐮🦊
Kya mast formula hai bro maza aara hai formula se khelte hoye
very good explaination, thanks for the content
Sir, thanks for this video.
Aap ke bolne andaaz mast hai Deepak sir carry on bro sab ko samaj ajayega thanx bro
Thnaku so much specialy for special trick 👍👍
Sir plz upload video on daily basis. We want to learn more from you . video was splendid .
Ok g.. I will try to publish videos daily
Your presentation really great
Thank you very much sir ji. Masterpiece video
Sir ap bhot ache ho hmare confus doors ho gya
Index formula तो जादू है। बहुत पसंद आया। मन में एक प्रश्न है ,यदि drop down दो से अधिक भी हों तो क्या index +match funtion काम करेगा ? यदि हाँ तो कैसे ? उम्मीद है आप मदद ज़रूर करेंगे।
Very nice 👌 thanks sir 👍
Sir , ek request hai aap se. Sir koi aisi video banaiye unlogon ke liye Jo aapki advanced level ki Puri videos dekhne ke baad and unki practice ke baad , apne aapko test kar sakaein. Test video banaiyege please.
I PRAY YOUR CHANNEL GROW MULTIPLE TIMES. YOU ARE SUCH A GREAT TEACHER OF EXCEL.
Thanks g 🙏
Video bahut badiya h.
Your mic gives best quality out put...
very good brother ...hats off to you !!
U r a genius Sirji
Sir , achha mis report bananeke liye kon kon se excel formulas ki Sabse jaada jarurat hai kya iska ek video upload kar sakte hai? I really trust you sir. It's really good whenever I watch Ur videos I gain more knowledge in excel. thank u so much sir.
G blkul
THANKS A LOT SIR
Thank you very much for this informative video. You are doing a great work.
Thank you for very informative and useful video
😊
Sir you are very hard work
You are such a great teacher & your teaching methods also great.
I love your videos
THANKS FOR EASILY UNDERSTANDABLE DEMO AND EXPLANATIONS.
Sirji if a product has 2 or 3 values how to get the latest rate or 2nd rate or 1st rate???
Learnt a lot❤️
Thanks bhai.. very good
Very Good Concept
Thanks sir, as usual explained very well.
very nice video.really like it keep up the good work.
Sir ek vedio banao jismai more of one sheet mai index formula laga sake.
Nice video.
😊😊😊
Hi Deepak, I have seen number of videos on Advanced Excel, but I found your videos are well explained in details, you have explained very calmly and concept wise. I have saved all your links, your channel is Assets to me. Allah aapko aur success and long life de. Aameen
Superb Combination !!!
Whenever ur doing.. Please do it with full column and row..please don't do it in drop down..
That is the one thing u please change.. Apart from that ur the best from all.
Awesome Sir. This was very helpful to me and i learn a lot from all your video. Thanks
👍👍😊😊😊
Amazing video sir
It's very useful for me
Thank you.
Deepak Sir,
बहुत बड़िया | ; )
Dear Sir very nice
Very easy to understand by such way you explained... *Ontime Edu*
Sir, I see your excel videos on youtube regularly. 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 am waiting for your reply.
Your's
Vishwa Deepak Pandey
super, very good!
Jai hind sir.
I am a soldier of indian army
Sir apne jo is video me drop down list banayi h itms name/rate ki plz ap use suru se bana ke dikhana taki puri tarah se samjh aa jaye
Waise apki independent drop down list ki video dekha hu pr plz ek baar time mile to jarur drop down list ke regarding jo bhi queries h pl clarify karna.
Jai hind sir..
wonderful & helpful
Thank you sir.
very well explained
Awesome sir ji
Its very good, knowledge booster video. thanks for update.
th-cam.com/video/3rvoqNWHqm0/w-d-xo.html
very good
Great badiya
Very Nice Formula sir, I clearly understand.. Thank You Sir..
th-cam.com/video/3rvoqNWHqm0/w-d-xo.html
Nice job, index aur match function advance use ke vedio ka intezar hai.
God always bless you and your knowledge!
Deepak sir thumps up for your energy 💥
Bro I am Chartered Accountant your content is great but Ads is in huge number which is not right thing
good lesson
😊
Very helpful
😊 Thanks
good Mr.deepak, you help me a lot
Oh great.. just found it "Index + Match Function in Excel - Father of Vlookup " something which I was looking for.. (Y) great Thankx
Sir how make drop down
@@luqmanghulamkhan pick and drop down
Deepak sir please start making video on SAP in costing field it will helful to most of us. Because your explanation is superb .
Okay g.. I will publish video shortly
Very good explaining style
mesmerizng sir
Dhanyawad sir 🙏
you are best sir g thanks for such fantastic videos.
Thank you sir for publishing this viedo
Awesome. Thanks for the info. Very helpful.
😊
Thanks a lot
Very Helpful video
Fantastic boss
Hello Sir,
My Greetings.
Sir, I see your excel videos on youtube regularly. 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 am waiting for your reply.
Your's
Vishwa Deepak Pandey
Dear Deepak Sir good evening how ru hope ur fine sir this video index + Match formulae is really awesome sir please iam requesting you to prepare videos on MIS reports and Dash boards Thank you Sir
Ok g.. Please wait.. I will publish video as soon as possible
Thank you very much sir, sir ek question hai apse k aapne Rate aur Item name cell ko kaise drop down list lagaya, mujhse teeno cells ka i.e. product id bhi list me aa ja rhe ahi. please bataiye.
बाबुमुसाय, शानदार है रै। thanks