Index + Match Function in Excel - Father of Vlookup || Best Ever Explanation in Hindi
Вставка
- Опубліковано 28 кві 2018
- 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.com/open?id=1a_L...
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 UA-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,
दोस्तों ये वीडियो आपको कैसा लगा ? आपके मन में जो भी विचार है हमें Comments मै लिख के जरूर बताएं 🥰
*My New Channel :* bit.ly/3qFrbl5
*Complete Microsoft Word Tutorial :* ua-cam.com/video/Xkq0-xXAj48/v-deo.html
*Complete Powerpoint Tutorial :* ua-cam.com/video/OekrBhNybP0/v-deo.html
*Xlookup Complete Tutorial :* ua-cam.com/video/0LjfRVD7srU/v-deo.html
*Vlookup Complete Tutorial* : bit.ly/2K0C1Sb
*Excel All Formulas :* ua-cam.com/video/C9y53fedo04/v-deo.html
*Office Work in Excel :* ua-cam.com/video/PT8D1qQwe1k/v-deo.html
bht bakwas tha.. kam ki bat km bakwas pahle sunni padti h
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!
बहुत ही अच्छी तरह से समझाया है आपने। दरसल ये सच है कि मैं आपकी ही वीडियो देख कर इसे कर पाया। लेकिन मैं ये भी कहना चाहता हूं कि ये वी लुक अप से सिर्फ़ इसी मामले में आगे है कि ये दोनों तरफ़ के डेटा दे सकता है लेकिन ये सिर्फ़ एक ही डेटा दे पाता है। अगर हमें किसी स्टूडैण्ट के सारे डेटा एक साथ प्रिण्ट आउट के लिये चाहिये तो ये इस काम को नहीं कर सकता जब कि वी लुक अप सारे कालम्स के डेटा एक बार में डिस्प्ले कर देता है, इसीलिये वी लुक अप की उपयोगिता कभी समाप्त नहीं हो सकती। ये सिर्फ़ स्टूडैण्ट के नाम के साथ उससे जुडे किसी एक डेटा को एक बार में बता सकता है (फ़ादर्स नेम, रोल नम्बर, किसी सब्जैक्ट के नम्बर इत्यादि) पर ये सारे डेटा एक साथ नहीं दे सकता जो वी लुक अप आसानी से दे देता है, अत: ये सिर्फ़ चैक करने के लिये ही ठीक है। ये रोल नम्बर से स्टूडैण्ट को भी नहीं ढूंढ सकता उसके लिये इसका अलग से दूसरा वर्जन तैयार करना होगा।
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
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
Thank you very much deepak apke sare excel video mere liye bhut helpful hai
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......
Thank you very much...Deepak sir....You are my literally inspiration in IT field.
THANKS FOR EASILY UNDERSTANDABLE DEMO AND EXPLANATIONS.
Very Helpfull Video Just Extracted data after watch watching ur Video...Thanks
most of your video I am watching. Its very helpful. Thank You
Really your teaching style nd examples are very helpful..... thanks you so much....
Finally i learned it thank you
Very easy to understand by such way you explained... *Ontime Edu*
very good explaination, thanks for the content
thanks dipak sir ji aap bohat acha Kam kar rahe ho .ek kahavat he Gyan batne se Gyan badhta he.
You are such a great teacher & your teaching methods also great.
I love your videos
Deepak Sir,
बहुत बड़िया | ; )
Very clearly explained.. Thank you
Thank you very much for this informative video. You are doing a great work.
you are best sir g thanks for such fantastic videos.
Very nice approch mr deepak,
Nice job, index aur match function advance use ke vedio ka intezar hai.
God always bless you and your knowledge!
Simply Amazing Deepak Sir
Its perfect, thank you very much.
Aap ke bolne andaaz mast hai Deepak sir carry on bro sab ko samaj ajayega thanx bro
Sir, thanks for this video.
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.
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
बाबुमुसाय, शानदार है रै। thanks
Thank you very much sir ji. Masterpiece video
Its very good, knowledge booster video. thanks for update.
ua-cam.com/video/3rvoqNWHqm0/v-deo.html
Very Nice Formula sir, I clearly understand.. Thank You Sir..
ua-cam.com/video/3rvoqNWHqm0/v-deo.html
very well clarify the formula and i am very happy how you shown by break up of formula 👍 now i am your subscriber..
Very interesting style se smjhaya apne Thnk you so muxh
🤗😊
Amazing video sir
It's very useful for me
Thank you.
Awesome Sir. This was very helpful to me and i learn a lot from all your video. Thanks
👍👍😊😊😊
thank you sir ji very much you are best teacher 🙏👍
Great learning video again. Thanks.
Apka tutorial bohot hi powerful hai
Kya mast formula hai bro maza aara hai formula se khelte hoye
Superb Combination !!!
Deepak sir, your way of teaching is very good. You are best teacher
🐨🐯🐮🐷🐮🦊🐮🐻🐰🐯🦊🐯🐯🐯🐯🐯🐯🐯🦊🐰🦊🐹🐯🐰🦊🦊🐮🦊
Sir ap bhot ache ho hmare confus doors ho gya
Dhanyawad sir 🙏
Deepak sir thumps up for your energy 💥
Thnaku so much specialy for special trick 👍👍
THANKS A LOT SIR
Video bahut badiya h.
Your presentation really great
Learnt a lot❤️
Dear Deepak, I learned this formula, apply on my simple data worked quite satisfactory thanks for that,Now I have a problem I have multiple dependent data for selecting one component, at least five criteria I made a data with cell merge to create it will it work or can you upload new video to explainthis complexity? I willbe very thankful to you.
Awesome sir you great sir 🙏🙏🙏 thanks sir 🙏 🙏🙏
Awesome. Thanks for the info. Very helpful.
😊
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
Ham apka Excel ka total video dekh rahe hai
Advance Excel ❤
Thanks sir, as usual explained very well.
It is very usefull formula for filter data into information
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 good brother ...hats off to you !!
Really ! great learning
Best explaination sir...
U r a genius Sirji
very nice video.really like it keep up the good work.
Thank you sir for publishing this viedo
Thanks bhai.. very good
Very good explaining style
Very Helpful video
Awesome sir ji
thanks bro, tons of love from Pakistan
Each and every steps are explained very neatly. Just bravo brother
I’m waiting for the same functionality in huge data
Your mic gives best quality out put...
I PRAY YOUR CHANNEL GROW MULTIPLE TIMES. YOU ARE SUCH A GREAT TEACHER OF EXCEL.
Thanks g 🙏
wonderful & helpful
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
Thank you sir.
thanks, it helped a lot
Great badiya
Sir you are very hard work
super, very good!
Sir aap ka video bahut acha lagta hai
😊😊😊❤️
very good
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
Hi Dipak, pl explain how to set dropdown list for some field not all. As per your above example, at E7 Rate & Item Name Diplay, while Product in same row, but not display.
mesmerizng sir
सर मेने आपके विडियो से बहुत कुछ सीखा हे तो आप मेरे टीचर हुऐ और आज आपको कैसे भूल सकते है
" Happy Teachers day "
Thanks for Teach us
Thank you for very informative and useful video
😊
Very nice 👌 thanks sir 👍
Superb!!!
very well explained
Excellent!!...You should write a book
Thank you so much.
Thanks Deepak Sir. Please send VIDEO for INDEX + MATCH in Large datas with multiple worksheets.
Very Good Concept
Deepak sir Aapka yeah video bahut achha hai, lekin aapne Item name/ Rate Combine Down Drop kaise kiya woh batana please
Supeer Deepak sir
Buhat hi aala
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