Index + Match Function in Excel - Father of Vlookup || Best Ever Explanation in Hindi
Vložit
- čas přidán 29. 08. 2024
- 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 CZcams 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 :* czcams.com/video/Xkq0-xXAj48/video.html
*Complete Powerpoint Tutorial :* czcams.com/video/OekrBhNybP0/video.html
*Xlookup Complete Tutorial :* czcams.com/video/0LjfRVD7srU/video.html
*Vlookup Complete Tutorial* : bit.ly/2K0C1Sb
*Excel All Formulas :* czcams.com/video/C9y53fedo04/video.html
*Office Work in Excel :* czcams.com/video/PT8D1qQwe1k/video.html
bht bakwas tha.. kam ki bat km bakwas pahle sunni padti 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
बहुत ही अच्छी तरह से समझाया है आपने। दरसल ये सच है कि मैं आपकी ही वीडियो देख कर इसे कर पाया। लेकिन मैं ये भी कहना चाहता हूं कि ये वी लुक अप से सिर्फ़ इसी मामले में आगे है कि ये दोनों तरफ़ के डेटा दे सकता है लेकिन ये सिर्फ़ एक ही डेटा दे पाता है। अगर हमें किसी स्टूडैण्ट के सारे डेटा एक साथ प्रिण्ट आउट के लिये चाहिये तो ये इस काम को नहीं कर सकता जब कि वी लुक अप सारे कालम्स के डेटा एक बार में डिस्प्ले कर देता है, इसीलिये वी लुक अप की उपयोगिता कभी समाप्त नहीं हो सकती। ये सिर्फ़ स्टूडैण्ट के नाम के साथ उससे जुडे किसी एक डेटा को एक बार में बता सकता है (फ़ादर्स नेम, रोल नम्बर, किसी सब्जैक्ट के नम्बर इत्यादि) पर ये सारे डेटा एक साथ नहीं दे सकता जो वी लुक अप आसानी से दे देता है, अत: ये सिर्फ़ चैक करने के लिये ही ठीक है। ये रोल नम्बर से स्टूडैण्ट को भी नहीं ढूंढ सकता उसके लिये इसका अलग से दूसरा वर्जन तैयार करना होगा।
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
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!
Really your teaching style nd examples are very helpful..... thanks you so much....
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......
Very Helpfull Video Just Extracted data after watch watching ur Video...Thanks
most of your video I am watching. Its very helpful. Thank You
thanks dipak sir ji aap bohat acha Kam kar rahe ho .ek kahavat he Gyan batne se Gyan badhta he.
Thank you very much...Deepak sir....You are my literally inspiration in IT field.
Thank you very much deepak apke sare excel video mere liye bhut helpful hai
Aap ke bolne andaaz mast hai Deepak sir carry on bro sab ko samaj ajayega thanx bro
Deepak sir, your way of teaching is very good. You are best teacher
🐨🐯🐮🐷🐮🦊🐮🐻🐰🐯🦊🐯🐯🐯🐯🐯🐯🐯🦊🐰🦊🐹🐯🐰🦊🦊🐮🦊
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
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
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.
Very interesting style se smjhaya apne Thnk you so muxh
🤗😊
very good explaination, thanks for the content
Finally i learned it thank you
Thank you very much sir ji. Masterpiece 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
THANKS FOR EASILY UNDERSTANDABLE DEMO AND EXPLANATIONS.
I PRAY YOUR CHANNEL GROW MULTIPLE TIMES. YOU ARE SUCH A GREAT TEACHER OF EXCEL.
Thanks g 🙏
You are such a great teacher & your teaching methods also great.
I love your videos
thank you sir ji very much you are best teacher 🙏👍
very well clarify the formula and i am very happy how you shown by break up of formula 👍 now i am your subscriber..
Thank you very much for this informative video. You are doing a great work.
thanks bro, tons of love from Pakistan
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
Ham apka Excel ka total video dekh rahe hai
Advance Excel ❤
Kya mast formula hai bro maza aara hai formula se khelte hoye
सर मेने आपके विडियो से बहुत कुछ सीखा हे तो आप मेरे टीचर हुऐ और आज आपको कैसे भूल सकते है
" Happy Teachers day "
Thanks for Teach us
Your mic gives best quality out put...
Apka tutorial bohot hi powerful hai
Index formula तो जादू है। बहुत पसंद आया। मन में एक प्रश्न है ,यदि drop down दो से अधिक भी हों तो क्या index +match funtion काम करेगा ? यदि हाँ तो कैसे ? उम्मीद है आप मदद ज़रूर करेंगे।
Very easy to understand by such way you explained... *Ontime Edu*
Deepak Sir,
बहुत बड़िया | ; )
Each and every steps are explained very neatly. Just bravo brother
I’m waiting for the same functionality in huge data
Awesome Sir. This was very helpful to me and i learn a lot from all your video. Thanks
👍👍😊😊😊
Nice job, index aur match function advance use ke vedio ka intezar hai.
Sir ap bhot ache ho hmare confus doors ho gya
Very Nice Formula sir, I clearly understand.. Thank You Sir..
czcams.com/video/3rvoqNWHqm0/video.html
Sir, thanks for this video.
Your presentation really great
Thnaku so much specialy for special trick 👍👍
Great learning video again. Thanks.
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.
THANKS A LOT SIR
Amazing video sir
It's very useful for me
Thank you.
Superb Combination !!!
Sir aap ka video bahut acha lagta hai
😊😊😊❤️
good Mr.deepak, you help me a lot
U r a genius Sirji
Deepak sir thumps up for your energy 💥
Learnt a lot❤️
Very nice approch mr deepak,
Its very good, knowledge booster video. thanks for update.
czcams.com/video/3rvoqNWHqm0/video.html
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
Thanks sir, as usual explained very well.
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.
very good brother ...hats off to you !!
Thank you for very informative and useful video
😊
you are best sir g thanks for such fantastic videos.
Video bahut badiya h.
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
God always bless you and your knowledge!
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
Thanks bhai.. very good
Very good explaining style
Sir you are very hard work
Thanks Deepak Sir. Please send VIDEO for INDEX + MATCH in Large datas with multiple worksheets.
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
very good
It is very usefull formula for filter data into information
Awesome sir ji
Excellent!!...You should write a book
Deepak sir Aapka yeah video bahut achha hai, lekin aapne Item name/ Rate Combine Down Drop kaise kiya woh batana please
very nice video.really like it keep up the good work.
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.
Thank you sir for publishing this viedo
Very nice 👌 thanks sir 👍
Sirji if a product has 2 or 3 values how to get the latest rate or 2nd rate or 1st rate???
Awesome. Thanks for the info. Very helpful.
😊
Thank you sir.
Very Good Concept
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..
Very Helpful video
very well explained
Dhanyawad sir 🙏
wonderful & helpful
super, very good!
Hello deepak
How to use index +match function for Date and products ? In one table
I want to search product from date Wise will you show me please
Date. Product
2/3/19. Abc
3/3/19. Xyz
2/3/19. Abc 2
3/3/19. Abc
4/3/19. Abc
In one date same product multiple time how to filter or search which function should apply
Awesome sir you great sir 🙏🙏🙏 thanks sir 🙏 🙏🙏
Thanks bro... "Vande Matram"
Sir agar hum ek invoice banate hai just like mobile ka invoice banate hai tab kya ye Kam kare ga formula kyuki Hume product name se hi uske rate ki show karwana hai ya product id se hi uske rate aur product name dno show karwana hoga
Aur sir party k name se hi Hume party ka address, GST no. Aur GST kitane percentage lag to hai aur kitane percentage discount de rahe hai ye sab Ho jaega sir bataiye and invoice no., Date order no. Bhi change kaise kare ye bhi hai ek question
Aur kya hum log index+match function se students k roll no. Se full details results m show karwa sakte hai ya nahi sir please reply me sir
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.
Dear Sir very nice
Namaste. Sir I have learned the usage of Index and Match function. Thanks. Please point out differences in Index and Match function with Dsum function.