Tuesday, 4 April 2023

VLOOKUP function in Microsoft Excel

VLOOKUP is a built-in function in Microsoft Excel that allows you to search for a specific value in a table of data and returns a corresponding value from a specified column.



The VLOOKUP function has four arguments:

  1. Lookup_value: The value you want to search for in the first column of the table.
  2. Table_array: The range of cells that make up the table you want to search. The first column of the range must contain the lookup_value.
  3. Col_index_num: The column number in the table_array from which you want to return a value. The first column is 1, the second column is 2, and so on.
  4. Range_lookup: This is an optional argument that specifies whether you want an exact match or an approximate match. If you enter TRUE or leave this argument blank, Excel will return an approximate match. If you enter FALSE, Excel will only return an exact match.

Example:

Suppose you have a table of employee information, and you want to look up the salary of a particular employee. The table looks like this:

Employee IDNameSalary
101John50000
102Mary60000
103Bob55000
104Jane65000


You can use the VLOOKUP function to search for the salary of an employee by their ID. For example, to find the salary of employee ID 103, you would use the following formula:

=VLOOKUP(103, A2:C5, 3, FALSE)

In this formula, the lookup_value is 103, the table_array is A2:C5, the col_index_num is 3 (since we want to return the salary column), and the range_lookup is FALSE (since we want an exact match).

The formula will return the value 55000, which is the salary of employee ID 103.

No comments:

Post a Comment

Dr.Surendra Saini ©