Vlookup For Dummies

In Microsoft Excel Vlookup is very popular function. And a dummies is very important for this function. In this dummies I use Excel 2013. Interest thing is all the version of excel is the same syntax.

In vlookup function there is four parameter. The syntax is =vlookup(lookup_value,table_array,col_index,[range_lookup]).

Here it refers =VLOOKUP(Value you want to look up, range where you want to lookup the value, the column number in the range containing the return value, Exact Match or Approximate Match – indicated as 0/FALSE or 1/TRUE).

Actually I give here a dummy with vlookup. The dummy is suppose you have a set of data.And it has two column Item and Value. And in my required section My required header is same item and value. Here I want to know the value of "C".So in this case I will use vlookup function.

You can visit my channel to view this or more tutorial.

 

>>>>>>>>>>>>>>>>>>>>>>>Learn 4 parameter of vlookup function<<<<<<<<<<<<<<<<<<<<<<<<<<



No1>>"lookup_value"
===============
Look up value means the your question in this dummies our lookup_value is "C".


No2>>"table_array"
==============
Table array is your data set. That is the findings value of your question. in here our table date will be A5 to B11. But we must declare it . For data table declaration we can follow the below process..

Process:
'''''''''''''''''
So first I will declare our data table. In the above example my data set start from A5 and end B11. So I can declare it two ways. 

No 1, I can use $ (dollar sign) like $A$5:$B$11 or you can select as per your requirment then press F4 (functional key from keyboard.) and it will automatically take the dollar sign . 
The no 2 process is you can use name formula for this . This is also very easy.

Just select your data then goto the top left side of your excel sheet. You see a name box. and give a name here. It will automatically create a name formula for your data set. You can also change it from formula>>name manager tool.


No3>>"col_index"
=============
Here column index is our answer column of data set. In here we want to see the value of  "C". And the value column number is 2. So col_index is 2.


No3>>"[range_lookup]"
=================
Range lookup have two thing True and False.It is basically a optional part of vlookup function.If you do not use it, it will take true as defult but if you want to the exact match result of this function you use False or 2.

So lets go for write down the function.
=vlookup(C, $A$5:$B$11,2,False) it will show result "57"




===============================================================
>>>>>>>>>>>>>Thank you<<<<<<<<<<<<<<<<<<
======================================