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??

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: https://www.youtube.com/channel/UCFAr...

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

SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
VLOOKUP Complete Tutorial ( हिन्दी ) - Vlookup in excel - VLookup formula with examples VLOOKUP Complete Tutorial ( हिन्दी ...
58:36 | 126,924
PIVOT TABLE का परिचय (हिंदी में) PIVOT TABLE का परिचय (हिं...
33:00 | 836
Excel में Vlookup Formula सीखें (Hindi) 🔥 Excel Expert Excel में Vlookup Formula सीखें...
07:57 | 452,241
VLookup in Excel Part 1 | VLOOKUP सिर्फ़ 30 minute में (हिंदी) | Excel Tutorials Neeraj Arora VLookup in Excel Part 1 | VLOOKUP सिर्...
31:23 | 472,970
How to use IF, AND, OR functions in Excel (हिंदी में) How to use IF, AND, OR functions in Excel (ह...
12:48 | 77,374
Vlookup in Excel | Excel Vlookup formula in Hindi to become master in excel Vlookup in Excel | Excel Vlookup formula in Hin...
11:21 | 95,113
7 Ways To Use Vlookup in Hindi | Vlookup use करने के 7 तरीके 7 Ways To Use Vlookup in Hindi | Vlookup use ...
18:44 | 490,564
How to Use Vlookup Formula to Find Particular Data in Same/Different Workbooks in Excel – (Hindi)41 How to Use Vlookup Formula to Find Particular D...
11:36 | 220,792


coinpayu