Excel Vlookup

The VLOOKUP function is a powerful Excel formula used to search for a specific value in the first column of a table and retrieve a corresponding value from a different column within that table. It is commonly used for tasks such as data analysis, data management, and data lookup. The syntax for the VLOOKUP formula is as follows:

```excel

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

```

Now, let's break down the different components of the formula:

- `lookup_value`: This is the value you want to search for in the first column of the table.

- `table_array`: This is the range of cells that represents the table where you want to perform the lookup. The first column of this range is where the lookup_value will be searched.

- `col_index_num`: This is the column number in the table_array from which you want to retrieve the corresponding value. The first column in the table_array is considered as column number 1.

- `range_lookup`: This parameter is optional. It specifies whether you want an exact match (FALSE or 0) or an approximate match (TRUE or 1). If omitted, it is assumed to be TRUE by default.

Here's an example to illustrate the usage of VLOOKUP:

Suppose you have a table with student names in column A and their corresponding scores in column B. You want to find the score of a specific student, "John," using the VLOOKUP formula.

|   A    |   B   |

|--------|-------|

|  Sumit |  85   |

|  Manoj |  92   |

|  Shail  |  78   |

|  Hariom |  90   |

To find John's score, you can use the VLOOKUP formula as follows:

```excel

=VLOOKUP("sumit", A1:B4, 2, FALSE)

```

This formula will search for "John" in the first column (A1:A4) and return the corresponding value from the second column (B1:B4), which is 85 in this case.

Make sure the range you provide in the `table_array` parameter covers the entire table, including both the lookup column and the column from which you want to retrieve the value

More details