VLOOKUP IN EXCEL

VLOOKUP stands for Vertical Lookup.
VLOOKUP is used to find things in a table or in a range by row. For example: lookup employee name based on the employee id.

Four things are needed in order to build up a syntax for VLOOKUP :-

1. The value which you want to lookup , also called lookup value.
2. Second, the range or table where the lookup value is located.Remember, the lookup value should always be in the first column in the range. For example:If your lookup value is in C3 your range should start with C.
3. The column number that contains the return value. For example: If you specify the range B2:D4 then B is first column , c is second column and so on.
4. Optionally, you have to specify TRUE for Approximate Match and FALSE for Exact Match. If you don't specify any value by default it will be TRUE or Approximate Match.

Together, combine all of the above:-

=VLOOKUP(lookup_value,table_array,column_index_num,[range_lookup])

Examples of VLOOKUP are:

Result will be as:

Result will be as: