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

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,

[@DeepakEduWorld]

Dosto kaisa laga video 😊

[@adilashraf5121]

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

[@JAY_JAY_SHREE_HARI_2024]

👌

[@mhzone3644]

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]

OP informative video you makes 👌

[@AjaySingh-hr8yq]

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

[@sagarsinghrana1322]

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

[@arechb]

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

[@klrahul1304]

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

[@DeepakEduWorld]

🙏❤️

[@RoshniMishra-zg5ot]

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

[@tapasyajha7183]

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

[@skthetiger5340]

Excellent & fruitful as always ❤. Thank you Sir.

[@arunkumarsinghark3024]

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

[@pramodchandelpkc]

Very Helpful. THANKS for Sharing

[@user-dw6dv9jc4t]

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

[@acoustic_sumneet]

Best video on CZcams explaining INDEX-MATCH!

[@user-xf5hp7sn8h]

tum gajab ho bhai!

[@DeepakEduWorld]

😊

[@balramyadav7873]

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

[@vikas261196]

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

[@nityaguru5483]

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

[@vijays2676]

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

[@nidhikitoli2301]

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

[@rajnipandey9901]

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 😅

[@FFGDHIRAJ1M]

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

[@R2SEXPRESSrishi706]

Sir Aap se Request hai ki POWER BI ki complete Series le aaiye Aap k style m mazza aata h sikhne ko milta h islie aapko request kia ha mane🙏🏻

[@bickysonkar1119]

Bahut a66a laga sir ji 😊

[@ranatariq637]

Thanks Deepak Sir, for deeply explain index match .

[@smipk786]

Watching from Pakistan. Nicely explain it

[@sgandhi5925]

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.

[@asifmahmood7742]

AAP ka Samajne ka method Boht acha hai.
Thanks

[@MrMONURAM]

Mai computer coaching jata hu lekin itna good to vaha bhi nahi batate jitna good aap batate ho

[@Shivrajchopra]

🙏🙏🙏🙏🙏 pranam guru ji

[@traj0654]

Excellent I like 👍

[@jaymakwana7490]

Ekdm jkkas explaination thi sir

[@surendrababu9184]

Excellent explanation thank you.

[@ankitchauhan4221]

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.

[@qutubuddinmultani1552]

Excellent work in just short time.

[@sandiptribhuvan8434]

❤ nice

[@RohitKumar-uy7cx]

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

[@manasbhageria8827]

Very nicely explained. Amazing.

[@aleembaig6856]

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

[@vinodtripathi4634]

bahut achh laga apkaey samjhaney ka tarika thanks bhai

[@pradipkumarbiswal3366]

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

[@SeemaSharma-lj3cf]

very well explained, extremely useful.

[@shaktichauhan6111]

Thank u sir ji bhut acha sa samjya aapne ❤

[@Moizfoodi]

Sir ap ka teaching krnay ka taraqa bhut buriya ha …. Love you …. Shabir from Dubai

[@powerhousepk7870]

Behtareen method of teaching

[@user-zq9zj2pp9p]

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]

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

[@arunkumarsinghark3024]

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

[@rapperunique6372]

Easy and point to point 👉🏻♥️💯

[@AhGhulva]

good job boss

[@ubaidshaikh3615]

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

[@arslanghazi2386]

Love you Respected Sir from Pakistan 🇵🇰😊

[@saleemmalik4490]

Love from Pakistan

[@Rahul-gupta649]

Very informative videos sir ❤

[@kalpanathakur8878]

Same hamare sath bhi aisa hi ho raha hai

[@usmantahir1193]

Deepak. Greetings from Pakistan. You are best.

[@abdulwaki8590]

Excellent explanation bahi I m from Lahore Pakistan regards

[@rajsahu1029]

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

[@Bhavyasamaraho]

Aap excel 365 use karte ho na?

[@arunprasad5056]

very nice bhai, Vande matram

[@shoumyachoudhury2439]

Main 3 din se index match samazh nahi paa Raha tha paid course leke bhi,ab ye video dekhe shayad kuch samazh aajaye

[@chandraprakashpandey8827]

U r very the best Computer teacher
For me

[@yousafoilmills3787]

ONE OF BEST

[@AnilKumar-bb2fo]

Gajab formula hai sir
❤❤

[@sargamkumar6848]

Mst laga video sir salute hai aapko

[@sherlasherla1306]

Wonderfull bro super...detailed one

[@rajpatel4596]

Good👍👍👍👍❤❤❤❤

[@kumarparth6478]

bhai kal mera paper hai aaj ye dekh liya ab top karunga

[@pramodkumar3335]

Nice

[@HimSha07]

Jabardast video hai bhai... Good job.

[@anuragsharma2668]

❤wow sir very nice

[@pintu4420]

Very useful video bhai

[@ajaybalotiya8444]

Out of standing sir maje aa gaye dada

[@ishikagirdher454]

Thanks well explained.

[@faimashaikh7935]

Superb excellent very well explanation ❤

[@ganeshpoojary475]

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

[@zooby830]

very informative video thanks bro

[@ratneshscm]

Very nicely explained

[@sandeepgupta6526]

nice, it's very useful, thanks

[@waqasahmed8698]

Superb explanation dear Sir 👏

[@AftabAhmed-uw4ki]

Good work practice file daty ho

[@manjitsaini4740]

Sir amaskar, sir Kya app Excel me Ek latest video bana sakte ho sale purchase, stock opening balance or closing balance daily basis par daily date wise show ho with profit loss margin. Jo aaj ki closing balance hai wo Kal ka opening in se p ho Ana wali Kal ki date me in simple way

[@SarfarajKhan-gj5xt]

very helpful video sir

[@ravichandra5763]

Thank u Sir.

[@ohwhy6301]

thank you sir

[@anujgaikwad7454]

Thanks sir

[@pinakidas9689]

Nicely explained 👍

[@DeepakEduWorld]

Thank you 🙂

[@abdulazizqureshi5714]

GREAT VIDEO SIR

[@maheshsanghani6380]

good video .

[@naveenkaushik9963]

Great skill ❤❤

[@AftabAhmed-uw4ki]

Very nice explanation thank your if interview question different types per video lao if with vlookup if with sumifs if with index match plz🙏🏻🙏🏻🙏🏻

[@alishersundrani]

Please massing sheet pe aik videos bnaen, jis main member name, advance, per day, extra, total, bqaya lene hain, bqaya dene hain. Please please please please.

[@ilyasmwt4804]

Hi moto,amazing

[@mariantonys]

gajab ka cheej hai

[@Raj_funny_456]

thanks sir❤❤

[@nishant9001]

deepak bhai thank you

[@naeemqureshi4930]

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.

[@hemrajpanchal3137]

fantastic explain thanx brother

[@user-pz6yz5eg1c]

hi sir
for the index formula = index(B2:F12,2,) I AM GETTING VALUE ERROR

[@ENdanger2022]

Thankyou from shillong

[@raghavkumar5042]

Thank You Deepak.

[@rajendraparakhi550]

Very nicely explained 👌

[@yourmusic4690]

i learn a lot from this video thanks

[@rahulsachan6818]

awesome.