Powerful Excel : Vlookup

When you have bulky data in Excel sheets for example we will take columns in excel sheet as
1 Employee Names
2 Contact Number
3 Address
4 Qualification
5 Email-ID
and you need to search a Email-ID of the Employee. Now with small data you can just move your eyes over the Employee Names and you can get the result.
But what if data is large eg. some Lakhs and more date in Excel sheet.

So Solution to search down the required value in less span of time is to use Vlookup in Excel sheet.










Following are the steps,


1.You Need a Data to perform this operation.

2. You Need to made two (or as required ) columns, in our example Employee Name is
    Input and we want to  find out his Email ID. So the column where we want the Result
    we need to write Vlookup Formula in that column in our case it's  C23
    start typing =VLOOKUP(.....

3. Vlookup takes 4 parameters
    a: The input data to formula in our case it's B23

    b: The Entire Table where we want to search the data in our case the range of table is
        B9:F12

   c: The column number where we want to search in our case we want to search Email ID
       and it's column number is 5.

   d: Simply enter the fourth parameter as FALSE.

5: Add the $ sign between the table range i.e. we have B9:F12 make it as $B$9:$F$12

6: There you have your required result i.e. Email ID of the Employee you want

Further you can drag the formula and it gets applicable there too.

It will look some what like this.

Just Enter any Employee Name you want and the formula of VLOOKUP will find the answer i.e. Email Id for you.

Thus easy but very Powerful formula Vlookup in MS Excel can help you to search a particular record from Bulky/Heavy data.

Save Time and give Accuracy your your search.


Thanks,
Sudhir Bhilar