Рет қаралды 1,224,013
👉 FREE Excel Course. ENROLL NOW: event.webinarj...
What is Vlookup??
Download the workbooks used in this video: learn-with-lok...
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: www.instagram....