क्या है Vlookup? (हिंदी में)

👉 FREE Excel Course. ENROLL NOW: https://event.webinarjam.com/register...

What is Vlookup??

Download the workbooks used in this video: https://learn-with-lokesh-lalwani.thi...

Friends, as an Excel user, the most common question comes in is how to fetch some data out of a huge database from at one go? And the answer is Vlookup...This is one of the most amazing functions in Excel. We can apply Vlookup to compare two different datasets also.

Syntax:

Lookup Value = This is the common field in both the datasets.
Table Array = selection of our master data i.e. a database where we have those values which we need to match like PAN number, Emp ID, Phone Number etc. and those values also which we need to fetch on the bases of the lookup value like Employee name, Salary, Department etc.
Col, Index, Num = This stands for Column Index Number, this refers to that column number of our table array from where we need to fetch the values.
Range Lookup = This could be either True (Approximate Match) or False (Exact Match). In this example, we will be using False.


For more such videos subscribe to our channel:    / @learnwithlokeshlalwani  

Follow me on Instagram: https://www.instagram.com/learnwithlo...

______________________________________________________________________
⚠️ Disclaimer:
Ye video sirf educational purpose ke liye hai. Jo earnings mention ki gayi hain, wo estimated figures aur personal experience par based hain. Aapki actual earnings aapke effort, market demand aur platform policies par depend karegi. Is video mein kisi bhi guaranteed income ka promise nahi hai. Koi bhi online earning method shuru karne se pehle apni research zaroor karein.

🔔 Video pasand aaye to Like, Share & Subscribe zaroor karein!
📩 Agar koi sawaal hai, to comment section mein pooch sakte hain!

#EarnOnline #SecondSalary #Freelancing #SideIncome #PassiveIncome