सर आपने वह कहावत तो सुनी होगी की आंखे फटी की फटी रह गईं / या जैसे सांप सूंघ गया सर आज कुछ एसा ही हुआ आज ओफिस मे मेरे सिनियर कलिग ने अचानक मुजे ओफिस मे बुलाकर पूछा की ( B -- p - q M -- s - E - J -- n r - GH - f ) इस लाइन को बिना कोई छेड़छाड़ कीये सभी Small लेटर को केपीटल लेटर मे बनाकर दिखा सकते हो सर यह देख मे कुछ पल मन ही मन मुसकुराया 😊 और फीर सर जो मेने आपसे सीखा था वह Function =Proper चला दिया और जो रिजल्ट आया और उसे देख उसका मुंह कुछ पल के लिए 🤯 ऐसा हो गया जैसे कहा गया है सर बाद मे उन्होने मुजे उनका 👍 दिखाया और कहा गुडजोब यदी कुछ महिने पहले मुझसे यह पूछा गया होता तो वह मे नही कर पाता यह मे जानता हु सर आज जो हुआ ऊसका पूरा CREDIT आपको जाता है 🙏 Thank you Sir
Sir ap nay vlookup aur hlookup ka concept bohot acha bataya hai kabhi nhai bhulay ga table chahay jis tarah ka bhi ho bus hamay dekhna ye hai k lookup value vertical hai ya horizantal aur kuch nhi dekhna hai very nice concept bataya hai ap nay thank you sir (🌹) ye dil aur phool special ap k liye hai meri taraf se aur sath man i livo you.
Sir jabse Aapke channel par subscribe kiya seriously sir kahin aur excel sikhne ka mann Nahi karta kyunki sir mere sabhi concept clear hote ha rahe hai Jo meine aapke chanel ke through sikha hai amazing sir
I hardly learnt 3-5 ways to extract a value via Vlookup however it seems like and ocean which is completely elaborated in this playlist. Moreover, the way you have made the videos and the examples to clear the concepts is truly amazing.
Sir sabse acchi baat mujhe aapka teaching methods lagta hai aap kitni aasan tarike SE concept clear karte ho teaching toh har koi kar leta hai but jab tak concept clear na ho toh padhne mein interest nahin aata sir you are the ones of the best teacher of excel I have ever seen ❤️🙏👍 sir
aaap k he motivated and greet sikhane k trike say kcuh thora bahot seek k muje new job mile wo excel k based ye sirf aaap ki mhnat hai sir bs dua kijyega or b new chezin sekhne ki muje himat mile aaap say love you sir
Sir agar hum first column me koi bhi ek data choose karte hai to second column me us se related data hi select krne ke liye mile kya possible hai data validation or vlookup ke ke through agar nhi to fir kese kare koi chota sa example mil jata
Hello sir This is Anjali Gundial first of all i want to say thanks for giving a detail explanation of each and every topic I have one request i want excel formulas in sequence wise in category wise so that i would be easy for me to learn can you provide me or would you tell me where i will get Thankyou!
Thanks Anajali for your valuable appreciation,Kindly watch Career Guide Playlist -MIS LEARNING PROCESS video. How to learn step by step in depth course ,Also you may find videos in sequence playlist under videos description and Download link for Master assignment.Keep Learning & Keep Exploring 👍❤️
Sir , I have to practice these files. There is a drive and I am not getting the lookup files there. If you could please mention that in which folder lookup files are it will be really helpful .
You are creating a file for your customer service department to use . When a customer calls in , the customer service employee needs to quickly have the part number available in order to help the customer . The customer will provide the model year and model number , and your worksheet should calculate the correct part number .(sir is question ko krne ki trick bta do ki formula kaise lgega bss...plzz sir)
Sir. Plz detail expalination requir between vlookup and filter/advance filter where as same result has comes why we use vlookup. We should b use filter/advance filter instead of vlookup. Kindly explain it. I will thankful to you. If U clearify my confusion plz. Stay bless. Thanks and Regards.
Dear first of all filter is one time work.just extract the data based on your requirement but what if we have multiple data source eg.. different workbook from where we want to extract data from and it is updated on regular basis
Seracheble drop-down list me multi rows kese laye Exam: Row1. Row2.Row3. Row4 A. 20. 30. 40 B. 30. 40. 50 To ab me A serach Karu to drop down me a ka data ki sari rows ka data chahiye Kya ye possible he?
Video ka title dekhen pehle ..Hlookup Explained.Sayad aapko wo jaadooo wale..aag laga do aur tricks wale video jo youtube par milte hain wo hi pasand hai..wo dekhen. Ye channel unke liye hai jinke paas proper time..patience hai..aur wo jaddo dekhne nhi..In depth course karna chahate hain step by step.. Thanks for your suggestion.But ab tak ka ye aapka pehla comment dikha jise ye lecturue kaam ka nhi laga..aapka time waste karne ke liye aapse maafi chahte hain aur aapse request hai ab koi bhi video is channel ka mat dekhna😀🙏
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](/img/1.gif)
सर आपने वह कहावत तो सुनी होगी की आंखे फटी की फटी रह गईं / या जैसे सांप सूंघ गया सर आज कुछ एसा ही हुआ आज ओफिस मे मेरे सिनियर कलिग ने अचानक मुजे ओफिस मे बुलाकर पूछा की ( B -- p - q M -- s - E - J -- n r - GH - f ) इस लाइन को बिना कोई छेड़छाड़ कीये सभी Small लेटर को केपीटल लेटर मे बनाकर दिखा सकते हो सर यह देख मे कुछ पल मन ही मन मुसकुराया 😊 और फीर
सर जो मेने आपसे सीखा था वह Function =Proper चला दिया और जो रिजल्ट आया और उसे देख उसका मुंह कुछ पल के लिए 🤯 ऐसा हो गया जैसे कहा गया है सर बाद मे उन्होने मुजे उनका 👍 दिखाया और कहा गुडजोब यदी कुछ महिने पहले मुझसे यह पूछा गया होता तो वह मे नही कर पाता यह मे जानता हु सर आज जो हुआ ऊसका पूरा CREDIT आपको जाता है 🙏 Thank you Sir
Sir ap nay vlookup aur hlookup ka concept bohot acha bataya hai kabhi nhai bhulay ga table chahay jis tarah ka bhi ho bus hamay dekhna ye hai k lookup value vertical hai ya horizantal aur kuch nhi dekhna hai very nice concept bataya hai ap nay thank you sir (🌹) ye dil aur phool special ap k liye hai meri taraf se aur sath man i livo you.
Good job sir! the way you teach is really exceptional. Finally i understood where to use VLOOKUP or HLOOKUP, you cleared my confusion.
Keep learning
bht ache se concept clear krte hen sir ap..
Sir jabse Aapke channel par subscribe kiya seriously sir kahin aur excel sikhne ka mann Nahi karta kyunki sir mere sabhi concept clear hote ha rahe hai Jo meine aapke chanel ke through sikha hai amazing sir
Thanks Pawan.apko aur kahin dekhne ko jarurat ho nhi hogi..ye ehsaas ho jayega kuch din baad dear
I hardly learnt 3-5 ways to extract a value via Vlookup however it seems like and ocean which is completely elaborated in this playlist. Moreover, the way you have made the videos and the examples to clear the concepts is truly amazing.
Thanks Suraj ji
first time dekha hai trika sir aaaj pta chala kab and kahan kise h and vlookup use hota hai sach main sir aaap bahott great teacher hain duniya k
Thanks dear ❤️
Ab Vlookup or Hlookup ka confusion door hua Sir.
Na Naa ye bhi sahi tha sir.
Thank you
Thanks Satish Ji..God bless you
Sir sabse acchi baat mujhe aapka teaching methods lagta hai aap kitni aasan tarike SE concept clear karte ho teaching toh har koi kar leta hai but jab tak concept clear na ho toh padhne mein interest nahin aata sir you are the ones of the best teacher of excel I have ever seen ❤️🙏👍 sir
Thanks Pawan for your love and support..❤️
@@Innozant sir my friend very impressive your teaching methods I recommend him to watch your channel and learn excel basic to advanced
aaap k he motivated and greet sikhane k trike say kcuh thora bahot seek k muje new job mile wo excel k based ye sirf aaap ki mhnat hai sir bs dua kijyega or b new chezin sekhne ki muje himat mile aaap say love you sir
Thanks Dear... Congratulations..God Bless you
Very energetic
And
Enthusiastic
Great teacher
Thanks Sharma sahab..Happy learning ❤❤🙏🙏
Thank you very much sirG
Dear sir, I enjoyed very much your Excel series vdos, U teach us very explaining method which is very helpful to beginner 👍
Thanks Yash..Happy learninv.Reallg means a lot to me dear❤
Thank you so much bhaiya.... Your 3-4 videos made me calm as i am having a test . Thanks
❤️👍
सर् आप बहुत अच्छा पढाते हो।
उसके लिए धन्यवाद आपका.
सर् कुछ अच्छा सीखने को मिलता है तो टाइम मायने नही रखता .Excellent quality training Sir ji.
थैंक यू संदीप जी
सीखना कभी मत छोड़िये और जिंदगी में आगे बढिये
You teach so good, I was finding for this video , I got it.Thanks
Keep learning
Sir aap mjhe plz bataiye beginners ke liye basic , mujhe apki vedios bht achi lagti hai aab bht ache se samjhate hai
Bataya sonali maine..aapko jaise bola hai usi sequence me aapko seekhna hai dear..koi issue aaye to @innozantofficial telegram par contact kar sakte h
Conceptual lecture Awesome.......
Idea clear Sir... Thank You..
Amazing thank you sir
Your way of explaining is so amazing that if anyone see your video they will not able to restrain themselves from subscribing your channel
Thanks Rahul Ji for your love and support.Happy New Year to you and Your family 🙏❤️
Amazing class, enjoying & learning, each of your tutorial series gives me confident that I'm better n better 😄, thank you so much.
Thanks Rahini..Keep learning.. Practice on regular basis..Have self assessment.👍♥️
Your explanation is too good. Thanks🌹
👍🙏❤️ Thanks
Good job doing sir
very great sir
thanks a lot sir
Sir, you explained very well.
Thanks Hemant ji.hv a nice day
which one is better? lookup , vlookup and hlookup?
great video sir👍🏻👌🏻🙏🙏
Nice explained v and h lookup sir...Thank you..Pl upload sperate study excel in description
Thanks. Playlist wise videos are there dear
Niiiiice Video with Niiice explain 👍👍
Okay sir hum Ready hen is video main vloockup and Hloockup clear ho gya.
Hum tyar hen apke next question ke answer ke liye???
Good..👍❤️
very nice explanation ! As usual. thanks
So nice hai
You are great sir
🙏🙏
Nice sir g
Sir agar hum first column me koi bhi ek data choose karte hai to second column me us se related data hi select krne ke liye mile kya possible hai data validation or vlookup ke ke through agar nhi to fir kese kare koi chota sa example mil jata
Wah bhai maja aagaya
Thanks Ashok Ji..God bless You❤️
nice explanation sir....
Thanks Kaushal🙏❤️
NICE
Nice video sir
Thanks Rahul
Hello sir This is Anjali Gundial first of all i want to say thanks for giving a detail explanation of each and every topic I have one request i want excel formulas in sequence wise in category wise so that i would be easy for me to learn can you provide me or would you tell me where i will get
Thankyou!
Thanks Anajali for your valuable appreciation,Kindly watch Career Guide Playlist -MIS LEARNING PROCESS video.
How to learn step by step in depth course ,Also you may find videos in sequence playlist under videos description and Download link for Master assignment.Keep Learning & Keep Exploring 👍❤️
Great..
Hlook up bahut rare use hota hai na , same hai sirf horizontal hota yeh, thank you this concept
Yes
Sir , I have to practice these files. There is a drive and I am not getting the lookup files there. If you could please mention that in which folder lookup files are it will be really helpful .
Lookup and reference folder is there ,You may get all practice set there
Sir you are super ho
Gd for basic hookup
Thanks Virendra,Keep learning
You are creating a file for your customer service department to use . When a customer calls in , the customer service employee needs to quickly have the part number available in order to help the customer . The customer will provide the model year and model number , and your worksheet should calculate the correct part number .(sir is question ko krne ki trick bta do ki formula kaise lgega bss...plzz sir)
Sir practice sheet kayse milega link PE to schedule alag type ka dikhte hai
Sir. Plz detail expalination requir between vlookup and filter/advance filter where as same result has comes why we use vlookup. We should b use filter/advance filter instead of vlookup. Kindly explain it. I will thankful to you. If U clearify my confusion plz. Stay bless. Thanks and Regards.
Dear first of all filter is one time work.just extract the data based on your requirement but what if we have multiple data source eg.. different workbook from where we want to extract data from and it is updated on regular basis
Seracheble drop-down list me multi rows kese laye
Exam:
Row1. Row2.Row3. Row4
A. 20. 30. 40
B. 30. 40. 50
To ab me A serach Karu to drop down me a ka data ki sari rows ka data chahiye
Kya ye possible he?
how to download big to adv excel practice sheet only ????
I like it
Thanks Bhoopendra ,Keep watching ,learn and share.
Vlookup with choose function video need
Vlookup+chose and hlookup+choose both videos are available there in lookup series .
Hlookup with choose function need brother
Already there in lookup series
🙏
❤️🙏
Tnnq
H lookup sir
🌟🌟🌟🌟🌟
Thanks Trajit ,Share with your friends
no
No??
Kindly share your query Himani
🙄 bhaiya time waste
Itni bakchodi nhi chlti jldi jldi mudde p aao
Video ka title dekhen pehle ..Hlookup Explained.Sayad aapko wo jaadooo wale..aag laga do aur tricks wale video jo youtube par milte hain wo hi pasand hai..wo dekhen.
Ye channel unke liye hai jinke paas proper time..patience hai..aur wo jaddo dekhne nhi..In depth course karna chahate hain step by step..
Thanks for your suggestion.But ab tak ka ye aapka pehla comment dikha jise ye lecturue kaam ka nhi laga..aapka time waste karne ke liye aapse maafi chahte hain aur aapse request hai ab koi bhi video is channel ka mat dekhna😀🙏
@@Innozant baht he sahi jawab diya sir aaap nay love you sir