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
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🙌.....
मेरा भी यही कहना है।।। कुछ दिन पहले यक बड़े data के साथ मुझे काम करना था। अगर आपका साथ नही मिलता तो शायद ही हम यो काम कम्पलीट कर पाते।।। Thanks a lot.....! 💐💐💐 You are a great teacher.......
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......
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 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..
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
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
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....
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.
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
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
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.
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
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.
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.
Can you please upload one video regarding, how to set vlooklup in Formate (any document) Example 3 colum - A B C 3 raw value - 1 2 3 Or i have one sheet ther one A4 size blank space, so I want to at 3 corner we mention just names like A B C and automatically bye use of vlooklup filed the value of ABC, bade on only name, without applying formulas
Vlookup is so powerful but *XLOOKUP is King* of Excel 👉 th-cam.com/video/0LjfRVD7srU/w-d-xo.html 👈 Learn This New & Improved Powerful Formula
@TT Collection
Nice
Sir u block me I'm ur subcriber
F4 key s kasai lock krte h mere pass 2007MsExcal h to kyaa kre deepak sir please reply me
Id मे अगर 00100 लिया तो रेकॉर्ड दिखायगा क्या
@@sudamagupta7391 6
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
Very helpful keep doing🙏
Thanks
Ashish sing good
Thank you
Thanks
Thanks!
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.. 🙏
Gajab ho srr app i just started the excel course master bana ka chodoga aap
Jaldi sa 1 million ho jaiya bsss.... 🥰🥰🥰
Aap sb chote chote shij sikha dete h sir ajjkl to koyi nhi sikhate aese 🙏🙏🙏🙏thank u very much sir..🙏🙏🙏
Check #NaveenTamtaVBA
Welcome 🤗
Starting to chote chiz se ho hoti hai mam
Bat to sahi hai mmm👍
Shij😅
Unknown Heroes ho yaarrr aap jaise Teachers....!!!!
Nothing Fancy Straight Knowledge...Naman hai Aapko!!! Thankss!!!
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🙌.....
मेरा भी यही कहना है।।।
कुछ दिन पहले यक बड़े data के साथ मुझे काम करना था। अगर आपका साथ नही मिलता तो शायद ही हम यो काम कम्पलीट कर पाते।।।
Thanks a lot.....! 💐💐💐
You are a great teacher.......
Thoda jada hogya😉👍
👍
bahut clearly samjaya . hardly aise videos milte hai. keep going sir
Thank you sir aap free me video de re ho esliye apke jaisa pyara koi nh hai TH-cam par aisehi free me video dete raho or gariboka aashirwad lete raho.
Bahut shandar or kam ka video h mene pura video dekha or sb bahut acche se smjhaya h thanks you sir
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......
Check #NaveenTamtaVBA
बहुत शानदार और ज्ञानवर्धक वीडियो बनाया है। ऑफिस के कार्यों के लिए बहुत उपयोगी है।
Check #NaveenTamtaVBA
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 🙏
After press f4 dollar sign is not coming sir why??
@@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..
really hard work deepak Bhai direct mind pr effect karta hai apka tarika
Jaise jaise video dekhta gya mere vlookup se related saare doubts clear ho gaye 🥳🥳
Thank u so much sir 😊
Thnk u so much 🙏🙏
😊😊😊😊😊😊
Check #NaveenTamtaVBA
Excellent💯👍 videos har chez clear h
Best video . . Best channel and your teaching and explain way is fabulous👍👍👍👍👍👍
😊😊😊😊😊
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🙏
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
jitni tareej ki jaye kum hai aapki Deepak ji
🙏
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
Check #NaveenTamtaVBA
Bhetreen yar bhot hi achy trhan se samjaty ho ap yar 👏👌👍
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....
Check #NaveenTamtaVBA
Aditya2
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.
Check #NaveenTamtaVBA
Deepak sir... aapka ye video mere bahot hi kaam aaya hi.... aapka bahot bahot shukriya... very easy to understand also..... thank you so much.....
Thank you very much sir for sharing knowldge.
Bahut jabardast ek ek baat samaj m aa gyi sir excellent
Bahut hi badhiya explanation , thanks sir
Ma Sha ALLAH , Keep it up
Sir ap bahut ache tarike se samjhate ho chahe kitni bhi complicated formula ho 🙏🙏🙏🙏
Deepak Bahi You are very very intelligent person in world.
B3 kya hai sir
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
Your teaching method is so amazing sir.
Nc class ....very hardworking sir g..God bless you..your way of teaching awesome ....
I have watched the full video you have explained in a very good way
Check #NaveenTamtaVBA
आपके सभी वीडियो बहुत कुछ सिखाते हैं... और यह तो सबसे ज्यादा अच्छी और उपयोगी वीडियो है... थैंक्स दीपक सर
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
Gajab video bhai 🥰👍
बहुत बहुत धन्यवाद सर इतने महत्वपूर्ण ज्ञान को इतने आसान तरीके से समझाने के लिये.........
Sir bahut achha trika se samjhate ho ap.. thankyou sir
BEST TEACHING SKILL THANK YOU SIR JI
Check #NaveenTamtaVBA
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.
Awesome kyuki 58mins video orr only 129MB (720p)mai. It's gazab❤️
Only 89 MB with 720p HD Resolution
@@prashantbiradar2902 720 ma hoti he nhi dowld
@@helloworld2041 Konsa downloader use kar rahe ho..
Wo batawo
@@prashantbiradar2902 utube ma jo dowld ka option aata h vo 144p ya 360p ma he aata h
@@prashantbiradar2902 64 MB
Good Sir G I am from Lahore Pakistan bohat hi asaaan tarika se samjhaya apne thank you.
Thanks a lot sir i was finding this formula since too many days u r "
THE GREAT"
God bless u Sir. Nicely explained💐🙏
BEST TEACHING SKILLS. THANK YOU SIR JI.
Thankyou abhi tak mene jiski bhi videos dekhi apki video se samaj aya hai baki sab bahut jaldi jaldi me batate hau
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
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.
Very Nice Explain and good example.
Sir... Excel mai biggners to advance leval k videos k link provide kigeye Plz..
Bhai bohot hi acche se shikha samjha rahe ho, aise hi videos late Raho
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???
Thankyou so so so much for this wonderful tutorial in one video in which you explained all the topics in detail, keep growing ❤
बहुत बढ़िया सीखते हो Sir इतने सारे Chennal देखें लेकिन आपका #bestExcelChennal है।❤
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.
same issue
select B3:c3
thanks sir bahut achha video h bahut help hua
Sir, Can we combine Vlookup With Automatic Column Index and Vlookup With Multiple Lookup Values together? Thank you
Sir kindly reply
Sir Your Are Great Sir Love Uhh Mujhe Apne Tution Me Bhi Samjh Nhi aya Tha? But Aapki Video Dekhi To totaly Samjh me aa Gya Sir ❤Love Uhhh Sirr❤
Bahut achha hai video❤❤
I have seen many videos in TH-cam on the topic of complete vlookup but i found your video is best on vlookup.
बहुत बहुत शुक्रिया सर जी धन्यवाद्
Thanks for your lovely guidance 🙏🙏🙏❤️❤️❤️👍👍👍🎉😍
Very nice Dear Sir ❤
Aaap bahut acche se batate ho sir .... Explanation I too good
You’re best ❤
you take lot of efforts to make excel video. Thank you so much
Madt video tha bhai..👌
Bahut achaaa samjha hai bhai aapne very good
Thank you so much sir for this Vlookup video in details.. 😊
Thank you Mr. Deepak for all your help and teachings, God bless you
Thank you Sir 🙏👍 God Bless You 👍👍👍👌👌👌🙏
Sir Maine subscribe kr Diya🙏🙏🙏
Great sir🙏🙏
You are a real teacher
Tnk you so much sir. Muje umeed nhe tha ke youtube se Etna kuch shikne ko milga. Ar jaise apke vdo Deka Mera sob tnsn dur ho gya 👍
Fantastic sir ... Aap sach main bahut kmaal ke video bnate o ...
#NaveenVBA Check our for VBA Tutorial
Excellent Sir❤
Awesome 👍😎
Very simple and excellent training session 🎉
❤❤❤❤ love you brother, thank you so much for free jabjust knowledge
Can you please upload one video regarding, how to set vlooklup in Formate (any document)
Example
3 colum - A B C
3 raw value - 1 2 3
Or i have one sheet ther one A4 size blank space, so I want to at 3 corner we mention just names like A B C and automatically bye use of vlooklup filed the value of ABC, bade on only name, without applying formulas
god bless you 🙏
your class is very useful and very good
I must give a big salute to you sir
thanks sor
Extremely helpful video 👍
Sir Apne bahut achha samjhaya mene bahut vedioes dekhi par muje kuch samjh nahi aya lekin apko vedio bahut achhi h 😊😊😊
Thanks for sharing video we learned about excel because of you. We highly obliged to you forever
Nice and very informative video sir ji
Itna mushkil ko itna asaani se samjhaya thank you
Thank you sir. Very good teaching.
Excellent .... Hats off dear god bless to you buddy
Fantastic and Superb Deliverance.Need to explore about All advanced learning in excel.
Excellent 💯💯💯👌👍
Teach very deeply...bahot badhiya Sirji..thnku
I Have watching full video, excellent video, Good information,
#NaveenVBA Check our for VBA Tutorial
Thankyou so much brother God bless you aap isi tarah sey simple way mey samjate ho that's good
Knowlege is precious time doesn't mine. i am very grateful to you sir.thank you.
Excellent.. needful information 👍🙏
Thanx I apiciate your work, I have been watching your video from 1 months. Really i learn lot. God bless u.
Bahot achcha sir khuda aap ko khush rakhe. IRFAN 💻🖥
u are great i saw lot of video but was confuse your video clear my vlook up concept 👍