VLOOKUP Complete Tutorial ( हिन्दी ) - Vlookup in excel - VLookup formula with examples

vlookup complete tutorial ( हिन्दी ) - vlookup in excel - vlookup formula with examples in hindi #vlookup #deepakeduworld #excel here in this wideo i will share MS Excel Full Vlookup Tutorial zero to advanced lavel in Hindi vlookup tutorial for beginners
My New Channel : bit.ly/3qFrbl5
Don't Miss Xlookup Magical Formula : • What Xlookup Can Do Fo...
In this video, we have discussed the following topics of VLOOKUP in Detail.
How Vlookup Work
Vlookup Basic
Vlookup Examples
Vlookup Exact Match
Vlookup Approximate Match
Range Lookup
Dynamic Vlookup
Vlookup With Automatic Column Index
Vlookup Errors
Double Vlookup
Vlookup With Multiple lookup Values
Lookup All Data Of Same Lookup Value
Vlookup in Multiple Tables
Vlookup in Multiple Sheets
Vlookup in Multiple Workbooks
ADVANCED EXCEL FORMULAS ► goo.gl/bbHYu2
Training File 1 : drive.google.com/file/d/1sp5w...
Training File 2 :
drive.google.com/file/d/1rdkK...
Training File 3 :
drive.google.com/file/d/10z4_...
Hope you will like the video. Thanks For Watching Friends.... Have A Nice Day...
Deepak EduWorld Playlist's:
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's in excel ► goo.gl/dFhg54
Subscribe Deepak EduWorld ► / deepakeduworld
Instagram ► / deepakeduworld
Facebook page ► / deepakeduworld
LinkedIn ► / deepakeduworld
Facebook Group ► / deepakeduworld
We Always Provide Useful & Helpful Content On The Deepak Eduworld KZbin 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 : vlookup,vlookup in excel,excel vlookup,vlookup formula,vlookup function,vlookup tutorial,excel vlookup tutorial,vlookup in hindi,how to use vlookup,vlookup formula in excel,vlookup with example,vlookup in excel in hindi,vlookup excel tutorial,excel vlookup formula in hindi,how to use vlookup in excel,vlookup formula in excel with example,VLOOKUP Complete Tutorial,excel formulas and functions,deepak eduworld,deepak edu

[@DeepakEduWorld]

Vlookup is so powerful but *XLOOKUP is King* of Excel 👉 kzbin.info/www/bejne/Zn3Nl4WMeZymqLc 👈 Learn This New & Improved Powerful Formula

[@sudamagupta7391]

@TT Collection Nice

[@jabirkhan208]

Sir u block me I'm ur subcriber

[@Shoyebchouhan]

F4 key s kasai lock krte h mere pass 2007MsExcal h to kyaa kre deepak sir please reply me

[@satishsarode5809]

Id मे अगर 00100 लिया तो रेकॉर्ड दिखायगा क्या

[@lakshyablogger2678]

@@sudamagupta7391 6

[@ashishkumarsingh4722]

Basic Vlookup 2:38 Exact Match Vs Approximate match (Range Lookup) 7:41 Dynamic Vlookup 15:25 Vlookup With Automatic Column Index 19:56 Vlookup N/A Error 25:17 Vlookup With Multiple Lookup Values 29:10 Vlookup To Extract All Data Of Same Lookup Value 33:35 Double Vlookup 43:50 Vlookup in Multiple Tables 46:12 Vlookup in Multiple Sheets 51:15 Vlookup in Multiple Workbooks 54:56

[@Ashutosh-cp4gs]

Very helpful keep doing🙏

[@infoteria8875]

Thanks

[@afreenshaikh4341]

Ashish sing good

[@bhavapritaapara9274]

Thank you

[@Rahulkumar-dg5pu]

Thanks

[@rafsanjony7976]

Abhi ye jamana main koi bhi eisa nehi sikhata... Mera life me up best teacher in world. If it'll be possible Definitely I'll bow if your soft leg🙏🏼🙏🏼🙏🏼. Thanks a lot from my deep hurt. Sir I'm a big fan of you.. may god make you alive for lifetime untill the world isn't destroyed🙌.....

[@bibekanandamanna5442]

मेरा भी यही कहना है।।। कुछ दिन पहले यक बड़े data के साथ मुझे काम करना था। अगर आपका साथ नही मिलता तो शायद ही हम यो काम कम्पलीट कर पाते।।। Thanks a lot.....! 💐💐💐 You are a great teacher.......

[@brutalavijit88]

Thoda jada hogya😉👍

[@dipbanerjee9777]

I am very fresher in vlookup and I have learned very well by watching your this video. Thank you Mr. Deepak for your excellent training in vlookup.. 🙏

[@trishnamoniroy5523]

Aap sb chote chote shij sikha dete h sir ajjkl to koyi nhi sikhate aese 🙏🙏🙏🙏thank u very much sir..🙏🙏🙏

[@NaveenTamtaIamExcelVBA]

Check #NaveenTamtaVBA

[@vinitdalvi9630]

Welcome 🤗

[@SonuSingh-mi5hg]

Starting to chote chiz se ho hoti hai mam

[@kumarsambhu6364]

Bat to sahi hai mmm👍

[@MdIrfan-2017]

Shij😅

[@anubhaagrawal8218]

Hlo Sir, This is our good luck that we learn Excel from a tutor like you. Pls make this type of informative tutorial (all in 1) more & more, so that we can learn more in least time. Heartiest Thankful to you. I request you to make tutorial on HR labour & factory laws.

[@NaveenTamtaIamExcelVBA]

Check #NaveenTamtaVBA

[@KhanKhan-iu3we]

Your teaching method is so amazing sir.

[@dhananjaypatkulkar6410]

Unknown Heroes ho yaarrr aap jaise Teachers....!!!! Nothing Fancy Straight Knowledge...Naman hai Aapko!!! Thankss!!!

[@RohitDabi]

Bahut shandar or kam ka video h mene pura video dekha or sb bahut acche se smjhaya h thanks you sir

[@s.k5100]

Aapko bauhat bauhat dua de raha hoon sir... Knowledge hona ek alag baat hoti hai...aur kisi tak knowledge pohancha dena easy way se ...Wo alag baat hoti h....kaash ki aap hamare life mai teacher hote

[@yrrao2009]

Superb way of teaching sir. For VLookup, I was A Zero till yesterday. Now after watching your VLookup video, I am sure that I can effectively use it for my official work and I can help my friends too. Thanks for your guidance sir 🙏

[@jyotusingh]

After press f4 dollar sign is not coming sir why??

[@yrrao2009]

@@jyotusingh Could you please write down the exact video TIME where you have found this "f4" function key to use. INFACT F4 Function key REPEATS the IMMEDIATELY PREVIOUSLY USED COMMAND. So just check this fact and come back. If still you are not clear, then please write down the TIME STAMP of the video viz. At 7.05 Minure of the video or like that..

[@nadeemjanjua764]

Wonderful communication with exceptional precision. Hats off to you sir

[@vrushalikharat8386]

Teach very deeply...bahot badhiya Sirji..thnku

[@chyarmennanda]

Sir G , me computer class nhi ki par aap k VDO dekh-dekh k bahut kuch sikh gaya hu . Thank you so much Sir G for all these VDOs,❤️❤️❤️ love from Odisha

[@NaveenTamtaIamExcelVBA]

Check #NaveenTamtaVBA

[@harishmehara1714]

Thanks a lot sir i was finding this formula since too many days u r " THE GREAT"

[@tanviwadhawan3193]

Amazing sir you are the great KZbinr for learning. Thank you so much

[@AdilKhan-fl7zw]

Out standing lecture. Well done. Adil. Pakistan. 👏👏👏👏👏👏

[@srikanthkasala7850]

Excellent Sir, You did great job for unknown persons about basics and Adv Excel of Vlookup... Thanks so much... We're great to learn day by day...... awesome....

[@NaveenTamtaIamExcelVBA]

Check #NaveenTamtaVBA

[@shankarlalkarnani5147]

Aditya2

[@AltafHussain-kt2xq]

Ma Sha ALLAH , Keep it up

[@awasthi1977]

You & Your teaching method is amazing, this is very easy to understand, thanks a lot Sir

[@hindu8095]

You are a true excel master 🙏🏼

[@iftikarhussain1703]

Hi there! Really done a great job by doing such an informative video session. Kindly clear me the query below- 50:36 min- VLookUp in multiple tables- You have shown here the table array to be

[@RanjeetKumar-kb3oq]

Jaise jaise video dekhta gya mere vlookup se related saare doubts clear ho gaye 🥳🥳 Thank u so much sir 😊 Thnk u so much 🙏🙏

[@DeepakEduWorld]

😊😊😊😊😊😊

[@NaveenTamtaIamExcelVBA]

Check #NaveenTamtaVBA

[@muhammadtaqi1494]

I have watched so many videos on Excel formulas. The knowledge you deliver is excellent. You are hero both in knowledge and the way you convey your message. I will try to meet you any time in my life and solute you.

[@JKMAHAWAR7]

बहुत शानदार और ज्ञानवर्धक वीडियो बनाया है। ऑफिस के कार्यों के लिए बहुत उपयोगी है।

[@NaveenTamtaIamExcelVBA]

Check #NaveenTamtaVBA

[@ashishpatil7852]

BEST TEACHING SKILL THANK YOU SIR JI

[@NaveenTamtaIamExcelVBA]

Check #NaveenTamtaVBA

[@sourabhchaudhery5904]

bhai jo ap example wali file share kr dete ho description me wo bht easy kar deta hai ...wrna kuch teachers toh hamara app dowload krke file waha se le lo ye wo krte hai ....ap best ho isliye .. thanks bhai

[@tarulatabhatt4037]

VERY POWERFUL TEACHING

[@rahulsaxena547]

Deepak Bahi You are very very intelligent person in world.

[@ashutoshkumarsriwastava8776]

B3 kya hai sir

[@meenapinto3173]

BEST TEACHING SKILLS. THANK YOU SIR JI.

[@monporoshneog4725]

Thank you. Radhey Shyam

[@poojasachdeva6314]

bahut clearly samjaya . hardly aise videos milte hai. keep going sir

[@yatingupta603]

Bhai ji bahut video deakhi par samjh ni aaya NA wali problem aati thi Apki ek baar deakhne se hi concept clear ho gaya समझाने का तरीका बहुत बढ़िया है. Thank you......

[@NaveenTamtaIamExcelVBA]

Check #NaveenTamtaVBA

[@ashishkashyap6520]

बहुत बहुत धन्यवाद सर इतने महत्वपूर्ण ज्ञान को इतने आसान तरीके से समझाने के लिये.........

[@noobgamers4563]

Me pichhle kaafi dino se excel ke tutorials dekh raha hu but finally iss video ko dekhne ke baad mujhe vlookup samajhme aaya hai. Thank u sir🙏

[@Kuldeepsharma-lq6qo]

Gajab ho srr app i just started the excel course master bana ka chodoga aap Jaldi sa 1 million ho jaiya bsss.... 🥰🥰🥰

[@p.shivaramakrishna1392]

Hi, ur videos are really helping us to learn excel, I have a query regarding automotive coloumn index in vlookup. U have shown for one row to do automotive vlookup, can u explain if multiple rows we need to do the same how to do it. I have done but errors are coming. It will helps if u show for multiple row to fill automatic column index in vlookup

[@aseemsingh.1548]

Lock only the Column of the 'Look-up Value'. For example, if the Look-up value is in 'D2', then lock only the Columns 'D' by writing $D2. Therefore, use only one dollar sign before the column and none in between ! Then u can easily drag down and use for more rows.

[@ghumansaab2314]

I have watched the full video you have explained in a very good way

[@NaveenTamtaIamExcelVBA]

Check #NaveenTamtaVBA

[@Vivek-xc8pu]

This video is described technical understanding of vlookup. And it's awesome video😘😘😘

[@ajaymalviya6856]

Sir ap bahut ache tarike se samjhate ho chahe kitni bhi complicated formula ho 🙏🙏🙏🙏

[@brutalavijit88]

Awesome kyuki 58mins video orr only 129MB (720p)mai. It's gazab❤️

[@prashantbiradar2902]

Only 89 MB with 720p HD Resolution

[@helloworld2041]

@@prashantbiradar2902 720 ma hoti he nhi dowld

[@prashantbiradar2902]

@@helloworld2041 Konsa downloader use kar rahe ho.. Wo batawo

[@helloworld2041]

@@prashantbiradar2902 utube ma jo dowld ka option aata h vo 144p ya 360p ma he aata h

[@skyadav2020]

@@prashantbiradar2902 64 MB

[@oriheor]

Hello Sir, How can i input a custom value into a cell that has a formula, but i also want to keep the formula intact as well???

[@ruchimishra8142]

You are amazing man seriously Thank you so sooooooooooo much I don't know a single word word Like 'E' Of excel but you are really amazing Thank you for this amazing video ❣️

[@shwetashetty3232]

You teach very properly correctly main thing zooming is imp while teaching... so that we can see clearly & can learn & easily.. thank you sir.. great sir keep it up👍👍

[@akborhossen9991]

Sir, Can we combine Vlookup With Automatic Column Index and Vlookup With Multiple Lookup Values together? Thank you

[@rajnipandey9901]

Sir kindly reply

[@supriyodas4519]

Hi Deepak, please clarify the following problem: In "COLUMNS" sheet, you have shown how to derive/obtain the data under "Quantity", "Price" and Amount" by dragging the cell from "Item Name" so in a similar way while there are 2 lookup values (sheet 7), can we not obtain the data for "date of order" and "item" along with the "amount"? Yeh, baat, clear nehi ho raha hai.

[@lokeshsharma2742]

same issue

[@lokeshsharma2742]

select B3:c3

[@rushabhkale5426]

Thank you sir aap free me video de re ho esliye apke jaisa pyara koi nh hai KZbin par aisehi free me video dete raho or gariboka aashirwad lete raho.

[@umermukhtar4472]

Amazing Sir, God bless you

[@DINESHKUMAR-kf2qh]

Sir... Excel mai biggners to advance leval k videos k link provide kigeye Plz..

[@SachinKumar-pk2ow]

Sir bahut achha trika se samjhate ho ap.. thankyou sir

[@Atiq123]

Very nice.Thanks Sir!

[@nurulhaque89]

Best video regarding Vlookup I have ever seen. Thank you very much for creating a nice tutorial

[@NaveenTamtaIamExcelVBA]

Check #NaveenTamtaVBA

[@ankitsharma_10]

Very well explained. Amazing work by you sir👍. It helped me alot.

[@savitapawaskar2230]

Deepak sir... aapka ye video mere bahot hi kaam aaya hi.... aapka bahot bahot shukriya... very easy to understand also..... thank you so much.....

[@piyushkaushal7103]

THANK YOU SO MUCH I LIKE YOUR VIDEOS

[@irfansanaji2906]

Bahot achcha sir khuda aap ko khush rakhe. IRFAN 💻🖥

[@pranay2533]

You are awesome trainer

[@amolvislavath3480]

Bhai bohot hi acche se shikha samjha rahe ho, aise hi videos late Raho

[@kuldeepsharma8747]

Out standing, very easy format for new learner. out standing teaching skills brother..

[@praviendhengale]

Bahut hi badhiya explanation , thanks sir

[@sabeerahmedmemon7735]

Thank You bahya for an excellent lecture.

[@khalidsaifullah5080]

wonderful formulas and great explanations

[@priyadcosta46]

Thank you Mr. Deepak for all your help and teachings, God bless you

[@masoodahmad7932]

Very simple and excellent training session 🎉

[@y2vikram]

Very nice tutorial

[@ajayamte6038]

Helped a lot. Thank you

[@pujashakya691]

Very very great sir ..too good vlookup video

[@surajnath9929]

Awesome Video...Thank You Sir....

[@AnandGyan02]

THANK YOU SIR FOR YOUR EFFORT GOD BLESS U

[@anilshah4338]

You are the great sir

[@parthpant4365]

Best video . . Best channel and your teaching and explain way is fabulous👍👍👍👍👍👍

[@DeepakEduWorld]

😊😊😊😊😊

[@sanjayrathee6599]

Great sir ji

[@lbbam2955]

very useful

[@sazalsarkar2130]

Excellent, Wonderful & Wow My Dear Dada.

[@ycmotovlog]

Awesome 👍😎

[@pradeeppatra8856]

Nice explanation

[@karaokesongs5425]

God bless u Sir. Nicely explained💐🙏

[@kamleshchandel6952]

really hard work deepak Bhai direct mind pr effect karta hai apka tarika

[@shaziakhan9945]

Excellent💯👍 videos har chez clear h

[@Mr.SBV_92]

आपके सभी वीडियो बहुत कुछ सिखाते हैं... और यह तो सबसे ज्यादा अच्छी और उपयोगी वीडियो है... थैंक्स दीपक सर

[@vyasravi5842]

Very Nice Explain and good example.

[@arunkumarsinghark3024]

बहुत बहुत शुक्रिया सर जी धन्यवाद्

[@saifullahbtm1786]

Very important video sir I'm watching your All video's

[@sweetysinha007]

Thank you very clearly explained!

[@sudarshanmalasha2153]

YOU ARE GREAT BOSS

[@XO_Ravi]

Thnku sir.. Gud explanation 🌺🙏

[@jayantamaity7852]

Very good sir

[@nishasinha9086]

thanks sir bahut achha video h bahut help hua

[@zahidqamar2143]

Thank you Deepak, your video has cleared my concepts about vlookup,

[@sumanasaha1832]

I am from Bangladesh. I like u vedio sooooo much.you learning vedio is so much helpful.

[@surendraverma5599]

गज्जब भाई,very helpful

[@NaveenTamtaIamExcelVBA]

Want to learn VBA check #NaveenVBA

[@uflgaming]

Good Sir G I am from Lahore Pakistan bohat hi asaaan tarika se samjhaya apne thank you.

[@RajniKohli-jk4ic]

Thanku sir it's amazing

[@Rahulkumar-dg5pu]

Simply Awesome like always , hat's off Sir such easy to understand teaching 👍👍

[@amitsaini1970]

Great sir🙏🙏

[@electricus_aniruddhachanda8184]

Excellent. Yahi to chahitha mujhe Thnx Sir ji

[@indiansfunniestvideo5178]

Itna mushkil ko itna asaani se samjhaya thank you

[@AnkitKumar-zc6tj]

Bahut jabardast ek ek baat samaj m aa gyi sir excellent

[@Khan-mc3gi]

u are great i saw lot of video but was confuse your video clear my vlook up concept 👍

[@udaypratap1288]

Thank you sir ISI Tarah aur imp formula Hain plz define Kare.