Excel Vlookup Function

The VLOOKUP function in Excel is used to search for a value in the leftmost column of a table and then return a value in the same row from a specified column. Its syntax is:

---

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

lookup_value: The value you want to search for. table_array: The range of cells that contains the data. The first column of this range should contain the values you are searching for. col_index_num: The column number in the table_array from which to return the value. range_lookup: Optional.This parameter specifies whether to find an exact match (FALSE) or an approximate match (TRUE or omitted, which is the default).

---

Here's an example:
Suppose you have a table with student names in column A and their corresponding scores in column B. You want to look up the score of a student named "John".

Vlookup Function in Excel

This formula searches for "John" in the first column of the range A2:B4, and then returns the value from the second column of the matching row, which is John's score. The 0 argument indicates an exact match.

Next