The VLOOKUP is used for a specific value in a vertical column (typically the leftmost column of a table) and then returns a     corresponding value from the same row in another column within the same table.
Syntax:
     =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Arguments or Parameters:
Lookup_value: Lookup_value specifies the value that we want to look up in the first column of a table.
Table_array: The table array is the data array that is to be searched. The VLOOKUP function searches in the left-most column of this array.
Col_index_num: This is an integer, specifying the column number of the supplied table_array, that you want to return a value from.
Range_lookup: This defines what this function should return in the event that it does not find an exact match to the lookup_value.
TRUE – Approximate match, that is, if an exact match is not found, use the closest match below the lookup_value.
FALSE – Exact match, that is, if an exact match is not found, then it will return an error.
  Note: The lookup value Must be the first Column of the Table_array.
  Objective: Search the EmpName in cell K2 using Ecode.
  Step 1:
Type = sign in cell K2.
Type VLOOKUP
Type J2 in lookup_value argument.
Type “,”.
  Step 2:
Select Range A1:H27
Type “,”
 Step 3:
EmpName is the 2nd Column in the EmployeeTable
Type 2 in the col_index_num argument.
Type “,”
  Step 4:
The output should be Exact Match.
Select 0.
Close the Formula with “)”.
Press Enter.
  Conclusion: The output value of The Vlookup is Diane Margheim.