Excel मे Vlookup के साथ खेलना सीखो | VLOOKUP Formula in Excel in Hindi | Excel Tricks in Hindi 2022
दोस्तों इस विडिओ मैं आपके लिये एक रियल जॉब क्वेरी लेके आया हु जिसमे आपको Vlookup फार्मूला की एक जबरदस्त प्रैक्टिकल प्रॉब्लेम देखने को मिलगा।
इस प्रॉब्लेम को सॉल्वे करने के लिये मैंने vlookup और match फार्मूला का इस्तेमाल एक साथ किया। तो आप भी अगर Excel मे vlookup फार्मूला को सीखना चाहते है और साथ कैसे vlookup फार्मूला की मदत से हम रियल जॉब प्रॉब्लेम को सॉल्वे करते है सीखने के लिये इस विडिओ को पूरा जरूर देखें।
इस प्रॉब्लेम की प्रैक्टिस करने के लिये मैं नीचे प्रैक्टिस फाइल की लिंक दे रहा हु इसे डाउनलोड करें और इसकी प्रैक्टिस करके मुझे कमेन्ट मे जरूर बताए क्या आप इस प्रॉब्लेम को सॉल्वे कर पाए है या नहीं?
Practice Files: drive.google.com/uc?export=do...
90 % To 95% डिस्काउंट - On Computer Courses :
learnmorepro.com/courses/
🖥️ Features and Details of Learn More Paid Courses :
⏰ Life Time Access ✅
📋 Course Test ✅
🗞️ Course Completion Certificate ✅
📁 Practice files ✅
⏰ Instant Access ✅
Facebook Page Link : / learnmoreeasily
Telegram Channel Link : t.me/learnmoreindia
My Other Channels :
Curiosity : ✅
/ @curiosity9432
Real Tutorial : ✅
/ @realtutorial550
Tally Tutorial :✅
/ @tallytutorial
Complete Technology :✅
/ @completetechnology
Satish Tech ;✅
/ @satish_tech
My KZread Gears :
Best Mic for Recording (Condenser Mic) : amzn.to/2UUMDnH
Best Mic for Recording (Dynamic Mic ) : amzn.to/3pQgyvD
My DSLR Camera Canon 200D : amzn.to/39ciw3E
My Laptop (Video Editing) : amzn.to/2UXQj8h
Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
Antivirus : amzn.to/3l3TIgi
Screen Recording Software : bit.ly/2J39n2j
Video Editing Software : bit.ly/3nOPlri
Green screen with Stand : amzn.to/2KAl1Cu
Пікірлер: 84
Learn Satish Sir courses with Certificate Download Course App : bit.ly/3BWfQVa Courses Website :bit.ly/skill_course ✅ Watch on Desktop : skillcourse.in/
Jabarjast sir apka exel me koi jawab hi nahi hai tnq tnq sir
Brilliant sir Jo apnay file di ha... Pasa wasool of subscription thanks 👍 love 💕 from Pakistan
SIR SUPERB
Mast laga khelne 🎥 me.. Easy process result mine blowing
सर आप अदभुत हो। Thank u so much ❤️
Sir really very easy method use karte hai aap. I like your videos alway. thank you.
Bhai mujhe aapka video aur aapka tech karne ka tarika dono hi bahut accha lagta hai
Super duper hit video sir thankyou so much
Very Very Nice Sir Sir Aapka Padhana Hame Bahut Achha Lagta hai 👇👇👇👇👇👇👇👇👇👇 Teacher Ho To Sir Aapke जैसा दिल से शुक्रिया Sir
Great
Amazing Speechless❤
Aap sabse achhe teacher hai sir ji
Maja aa gya😎
Thank you Sir for making this video helped a lot...
Sir aap bahut achha se sikhate Hain
Very useful i have seen many times.
Lajwab sir👌
GREAT
learned a lot from the video
Very magical trick sir Thanks a lot
Nice video for office work agent.
Excellent Thank u Sir
Bahut mast h sir
sir, thanks a lot.
Superb 💓
Superb vedio
Ek number
Thanks sir for helping me
Thank you so much sir 🙏
Excellent. I have learned excel from you. Thanks Sir
@Motivationfactkunalgole
2 жыл бұрын
Motivational video 👉kzread.infoUFcRP-aPANA?feature=share🔥👍🏻
Very amazing sir
Love you from Pakistan
Very interesting sir
Thx sir great
Bhoot acchi video thi sir Sir company mai jo kaam hota hai usse related excel ke data cleaning and work wali video banao mera matlab real kaam se related
@iwill1389
5 ай бұрын
@Exceldelhiwala channel pe advance if formula hy.. 80+ hours ka Interview base Ques
@pramod76783
5 ай бұрын
@@iwill1389 link send karo
Very powerful video
Maza aa Gaya
Sir apki baat hi alg h
It's too good video
Bahot hi badhiya sir...
@Excel_Tutorial
2 ай бұрын
Keep watching the new videos I am uploading.
Very nice sir 👍
👌👌👍👍
Most important office work in Excel pe Video banae 🙏🙏🙏🙏🙏🙏🙏
@iwill1389
5 ай бұрын
@Exceldelhiwala channel pe advance if formula hy.. 80+ hours ka Interview base Ques
Sir Xlook up ki upar detail me ek video chaiye sir
Nice i like
Sir power BI pr b video laaye...
Nice sir
Very simple
Aap jo padate hai na vo bahut zyada samaj me aata hai
Sir aap ise xlookup pr bhi bata dijiye
Hi I am a great admirer of your work I want to make a excel sheet which can keep of records of upcoming shipments from various suppliers and countries with product detail and all shipment detail like bill of lading and other detail Please help me on this
Sir please explain how to use month filter in this video.
sir how you make lecture video.. i mean you make video separate from mobile/camera and combine with computer screen.
🕉️🇮🇳🙏Res Sir 🙏 what ABOUT prices if price row included how to apply formula guide please.🕉️🇮🇳🙏
Sir y Jan Feb me filter kese lgaya h
I have solved this problem using SUMPRODUCT .which is easier than vlookups.
sir mera row ()& colum() vlookup formula par nhi lagata h only 1&2 tak chalrha h. eske baad aage nhi ho raha h.
Sir, I have a doubt Kya aapka full course KZread pr available h ya uske liye pay krna padta h?????? Please sir reply.....
@iwill1389
5 ай бұрын
@Exceldelhiwala channel pe advance if formula hy.. 80+ hours ka Interview base Ques
sir mera ek doubt hai " mne excel me ek formula lagaya like 11/2 = 5.5 toh ye jo 5.5 aaya ye(5.5) merko without decimal me chahiye means mai formula lagau aur without decimal me aaye toh iske liye kya karna padega sir aap bya dete toh thodi help ho jati
@iwill1389
5 ай бұрын
@Exceldelhiwala channel pe advance if formula hy.. 80+ hours ka Interview base Ques
Hello sir me vlookup use karta hoo but kai baar table array vali sheet me vlookup jata hi nahi uska reason bata denge
window11 pr excal h
Ye drop down table kaise banate hai
@vishalbhati912
2 жыл бұрын
Shortcut bata raha hu. ALT dabane K baad A V V dabana ya fir ALT D L EK MENU KHULEGI USME LIST CHUNNA OR FIR USS RANGE KO SELECT KR LENA JISKI DROP-DOWN LIST BANANI HE
Sir please under 35000-40000 best laptops
YE FORMULA KAM NAHU KAR RAHA VLOOKUP WALA LAKIN MATCH WALA WORK KAR RAHA H SIR HELP KARREN
Sir aap mujko free me pda sakta ho kya or sertifict ke sath me grib family se bilong kerta hu
@iwill1389
5 ай бұрын
Bhai rs 1/ per day pe hy @Exceldelhiwala channel pe advance if formula hy.. 80+ hours ka Interview base Ques
why use to formula vlook up????
Sir, I liked the teaching style, in this video you thought vlookup with match very nicely, I am maintaining payroll in simplified manner i.e. monthly data in n unique manner of all 12 months Is it there any concept in vlookup to get final total of all sheets in a single worksheet or have to copy and paste vlookup formula for 12 times as you thought multiplication
@vishalbhati912
2 жыл бұрын
Use vlookup with column formula. U don't need to copy paste it 12 time.
@Motivationfactkunalgole
2 жыл бұрын
Motivational video 👉kzread.infoUFcRP-aPANA?feature=share🔥👍🏻
Bate bohat bolte ho .
wahiyat
Respected Satish sir, i have a data from HRMS, i need to use Vlookup formula, need to collect some information please give me ur number can't explain by typing