Excel INDEX + MATCH Formula Explained | Index Match का मैजिक Vlookup & Xlookup नहीं कर सकते

Рет қаралды 263,323

Күн бұрын

Excel INDEX+MATCH Formula Explained | Index Match का मैजिक Vlookup & Xlookup नहीं कर सकते
dosto is video me maine excel ke index formula, match formula & index+match formula ko bilkul detail me explain kar diya hai, excel me jo kaam vlookup formula and xlookup formula nahi kar saktey wo kaam index match formula aasani se kar deta hai #indexmatch #excel #deepakeduworld
00:00 intro
00:18 index formula
06:31 match formula
10:00 index+match formula
My Channels :
A to Z Excel : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : bit.ly/364SVGV
Download training File : bit.ly/3OTrG9H
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 TUTORIALS ►
bit.ly/3kJyIBv
Thanks for Watching
Deepak EduWorld
References : index match,excel,index match in excel,index match excel,excel index match tutorial,index match function in excel,how to use index match,how index match works,index match multiple criteria,vlookup,excel index match,excel formulas,index formula,vlookup formula,excel vlookup,index,learn excel formulas,vlookup in excel,vlookup formula in excel,excel formulas and functions,match formula in excel,match,xlookup formula,xlookup formula in excel,excel formulas,

Пікірлер: 415

@DeepakEduWorld 11 ай бұрын

Dosto kaisa laga video 😊

@adilashraf5121 11 ай бұрын

Sir jo pure column m jo match lagaye h wo error bata rha h

@JAY_JAY_SHREE_HARI_2024 11 ай бұрын

👌

@mhzone3644 11 ай бұрын

Mainy apki video daikh daikh kr,,,5hours ka Kam 5 min sy bhi km time main fix kr Liya hy,,,fast sale system,,oor us pr 100+ formulas used Hain,,,wo bhi online

@amitsingh131193 11 ай бұрын

OP informative video you makes 👌

@AjaySingh-hr8yq 11 ай бұрын

Which Excel version have you used in this video?? Because it is not working in Office 2016.

@bankingexam9470 17 күн бұрын

Abe yaar main 10k deke advance excle Sikh raha hoon with macros but teaching is so poor I can't tell .but ye video main kitna acha se batya hai thank a lot yaar

@footprintsaryan 19 сағат бұрын

Thanks for video, Found it ueful

@sagarsinghrana1322 11 ай бұрын

Ab Tak ka sabse best video hai sir and sir aap kisi bhi topic ka video kanao uska full video banao sir JAI HIND

@RoshniMishra-zg5ot 9 ай бұрын

you make the concept so easy..in a single video you taught everything about vlookup, index and match.. great...

@arechb 7 ай бұрын

समजून देण्याची आपली पद्धती अतिशय चांगली आहे. ज्याला काहीही ज्ञान नाही त्यालाही समजेल अशी पद्धत आहे. आपले उच्चार स्पष्ट आहेत. समजून देताना समोरच्या व्यक्तीच्या मनात कोणताही गोंधळ निर्माण होत नाही. प्रत्येक पायरी क्रमशः आहे

@acoustic_sumneet 5 ай бұрын

Best video on KZfaq explaining INDEX-MATCH!

@skthetiger5340 11 ай бұрын

Excellent & fruitful as always ❤. Thank you Sir.

@ankitchauhan4221 11 ай бұрын

Bohot hi gajab kaa formula hai... Pehle me starting starting ne dekha tha, aaj se 2..3 saal pehle, to itna samaj nahi ata tha, but regular dekhne ke baad achhi practice ho gai hai. Thank u sir ji.

@klrahul1304 11 ай бұрын

Mene All Excle aap se hi Shikha Hai गुरु जी (मेरा प्रणाम स्वीकार करे 🙏🏽 )

@DeepakEduWorld 11 ай бұрын

🙏❤️

@arunkumarsinghark3024 10 ай бұрын

आप बहुत ही सरल भाषा में समझाते हैं एक बेहतरीन teacher की तरह, जैसे ऑफलाइन classes में पढ़ते पढ़ाते हैं, बहुत बहुत शुक्रिया सर, एकदम एकबार में ही कांसेप्ट clear हो जाता है आपके विडियोज को देखकर l 🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹❤🌹🌹 🌹 सीखते रहो, सिखाते रहो l❤ 🌺हमेशा हंसते मुस्कुराते रहे l कभी अपने लिए तो कभी अपनों के लिए l🌺🌹🌹❤

@vijays2676 11 ай бұрын

Very well explained, before watching your video, INDEX & MATCH WERE SCARING ME, but not now. Wonderful !!😇😀

@pramodchandelpkc 10 ай бұрын

Very Helpful. THANKS for Sharing

@ExamTips11 3 күн бұрын

really good

@tapasyajha7183 2 ай бұрын

Thankyou so much sir... Concept ache se samjh aaya hai sir bhut easily samjhaya hai sir aapne really thankyou sir ...❤

@user-zq9zj2pp9p 6 ай бұрын

deepak Bhai,i watched ur video before interview,just to brush up skill and finally i got selected in price water house. Thanks.if you are in delhi please let me know will give you a gift...

@DeepakEduWorld 6 ай бұрын

Thank you very much my dear… aapka selection ho gya isse bada kya gift hoga mere liye… ❤️

@aleembaig6856 10 ай бұрын

Excellent as usual .Can you pls explain how we can Vlook for values based on two criteria from another sheet.

@surendrababu9184 11 ай бұрын

Excellent explanation thank you.

@ranatariq637 4 ай бұрын

Thanks Deepak Sir, for deeply explain index match .

@nityaguru5483 11 ай бұрын

महोदय जी आप बहुत अच्छा समझते है। आपको कोटि-कोटि धन्यवाद।

@qutubuddinmultani1552 11 ай бұрын

Excellent work in just short time.

@rajsahu1029 11 ай бұрын

Wah. Only in one click all row or column sorted. I may use this result for making drop-down list of column headings or Row headings

@shreyatiwari4985 15 күн бұрын

bahut badhiya sir....ek number explanation

@HimSha07 6 ай бұрын

Jabardast video hai bhai... Good job.

@manasbhageria8827 6 ай бұрын

Very nicely explained. Amazing.

@fultoos3081 18 күн бұрын

TOO informative ,Thank you sir

@smipk786 8 ай бұрын

Watching from Pakistan. Nicely explain it

@nidhikitoli2301 9 ай бұрын

Bohot acha hai sir ye formula Aap bohot ache se samjhate hai. Formula ko.

@asifmahmood7742 11 ай бұрын

AAP ka Samajne ka method Boht acha hai. Thanks

@jaymakwana7490 4 ай бұрын

Ekdm jkkas explaination thi sir

@user-dw6dv9jc4t 4 ай бұрын

This function not work in Excel 2013 & previous version , but work in Google sheets. Thanks for sharing of your knowledge

@usmantahir1193 10 ай бұрын

Deepak. Greetings from Pakistan. You are best.

@mhu516 Күн бұрын

I appreciate your cooperation

@rapperunique6372 11 ай бұрын

Easy and point to point 👉🏻♥️💯

@rajnipandey9901 9 ай бұрын

Thank you so much sir ye gajab ka formula hai sir and jin logo ko value ya NA ka error aa rha hai mujhe bhi yhi dikkt ho rhi thi kyuki sir 2021 version use kr rhe hai or syd hum log old version pr h isliye me 2010 use kr rhi hu to meine same practice google sheet pr kr di vha pr ye same result de rha hai ap log bhi vha se help le skty hai thank you 😅

@AnilKumar-bb2fo 11 ай бұрын

Gajab formula hai sir ❤❤

@vikas261196 3 ай бұрын

Only video which help me understand the concept of index + match. Thanks

@SeemaSharma-lj3cf 7 ай бұрын

very well explained, extremely useful.

@FFGDHIRAJ1M 6 ай бұрын

Bohot maza aa gaya sir ❤ esliye samja diye ap ❤ just amazing ❤

@bickysonkar1119 7 ай бұрын

Bahut a66a laga sir ji 😊

@naeemmushtaq4467 8 күн бұрын

Zabardast Yaar, really impressed, maza aa gya. keep it up. and i am sub...ing your channel now👌👌👌

@DeepakEduWorld 4 күн бұрын

Thanks and welcome

@arunkumarsinghark3024 11 ай бұрын

बहुत बढ़िया सर

@sherlasherla1306 5 ай бұрын

Wonderfull bro super...detailed one

@sgandhi5925 2 ай бұрын

Great Sir. Crisp and Clear explanation of combining Index and Match Functions. After searching various sites, at last I got exactly what I was looking for in my mind from you in this video. Thank you a lot.

@faimashaikh7935 8 ай бұрын

Superb excellent very well explanation ❤

@ganeshpoojary475 11 ай бұрын

Really Excellent Sir ji 👍👍👍👍👍👍👍👍👍👍 Thank you so much sir

@sargamkumar6848 6 ай бұрын

Mst laga video sir salute hai aapko

@balramyadav7873 3 ай бұрын

आपके समझाने का तरीका बहुत लाजवाब है sir thank you so much

@naveenkaushik9963 11 ай бұрын

Great skill ❤❤

@powerhousepk7870 8 ай бұрын

Behtareen method of teaching

@arunprasad5056 11 ай бұрын

very nice bhai, Vande matram

@muhammadfarhad2057 11 ай бұрын

Excellent Sir...

@prashanttripathi5179 11 ай бұрын

Very Helpful😊

@shaktichauhan6111 9 ай бұрын

Thank u sir ji bhut acha sa samjya aapne ❤

@shwetavarshney8059 11 ай бұрын

VERY INFORMATIVE

@RohitKumar-uy7cx 9 ай бұрын

Awesome sir Sir offset formula bhi aise hi a to z explain kar dijiye 🙏 please

@maloykrgupta7775 10 ай бұрын

Woowww. Excellent Boss ❤❤❤❤

@vinodtripathi4634 7 ай бұрын

bahut achh laga apkaey samjhaney ka tarika thanks bhai

@chandraprakashpandey8827 10 ай бұрын

U r very the best Computer teacher For me

@lalitmohan9405 11 ай бұрын

Excellente

@user-vn6lf1tg6t 10 ай бұрын

You are wonderful sir💫

@Rahul-gupta649 2 ай бұрын

Very informative videos sir ❤

@ravichandra5763 11 ай бұрын

Thank u Sir.

@rajendraparakhi550 9 ай бұрын

Very nicely explained 👌

@sandeepgupta6526 9 ай бұрын

nice, it's very useful, thanks

@ravitejamom 25 күн бұрын

Thanks a lot... wonderful explanation

@anuragsharma2668 11 ай бұрын

❤wow sir very nice

@pradipkumarbiswal3366 10 ай бұрын

Apka har vdo very advance Level ka he.thank you sir

@NehaGupta-wj9li 2 ай бұрын

Excellent explaination!!

@prantogomes8569 7 ай бұрын

Outstanding Sir❤❤❤❤

@prathmeshranpura 15 күн бұрын

you're doing great job sir. learnt a lot.

@zooby830 4 ай бұрын

very informative video thanks bro

@mohanjoshi5639 9 ай бұрын

Amazing formula ❤

@ubaidshaikh3615 11 ай бұрын

First like..❤❤❤... Deepak Sir... Artificial intelligence tool or chat gpt Excel series start kijiye.. please

@nikhilbhardwaj6524 9 ай бұрын

Very helpful thank you 😊

@waqasahmed8698 4 ай бұрын

Superb explanation dear Sir 👏

@ishikagirdher454 4 ай бұрын

Thanks well explained.

@raghavkumar5042 11 ай бұрын

Thank You Deepak.

@ajaybalotiya8444 7 ай бұрын

Out of standing sir maje aa gaye dada

@kmanoj392 17 күн бұрын

Nice

@naeemqureshi4930 11 ай бұрын

mr deepak I m follower of your excel experties..I m facing a problem in excel....sir I have a large database....I set a search formula and I want to select and filter first 3 letters only of my description column.....I tried many times this formula but remain fail.....now I wish to guide me this formula.....I know you have all problems solution....I never miss your any videos regarding excel.