# Okebiz Video Search Title : क्या है Vlookup? (हिंदी में) Duration : 14:29 Viewed : 26,038 Published : 23-11-2018 Source : Youtube

👉 FREE Excel Course. ENROLL NOW https://hi.switchy.io/learnwithlokesh...

What is Vlookup??

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: https://www.youtube.com/channel/UCFAr... VLOOKUP Complete Tutorial ( हिन्दी ...58:36 | 126,924 PIVOT TABLE का परिचय (हिं�...33:00 | 836 Excel में Vlookup Formula सीखें...07:57 | 452,241 VLookup in Excel Part 1 | VLOOKUP सिर्�...31:23 | 472,970 How to use IF, AND, OR functions in Excel (ह�...12:48 | 77,374 Vlookup in Excel | Excel Vlookup formula in Hin...11:21 | 95,113 7 Ways To Use Vlookup in Hindi | Vlookup use �...18:44 | 490,564 How to Use Vlookup Formula to Find Particular D...11:36 | 220,792 