How to Use Vlookup Function in Excel With Example

Vlookup function name stands for “vertical lookup” and is a function in Microsoft Excel used to search for specific information in a table or range of cells. It searches for a value in the leftmost column of a table and returns a value in the same row from another column you specify.

Syntax:

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

lookup_value: The value you want to look up.

table_array: The range of cells that contains the data you want to search.

col_index_num: The column number in the table array from which the matching value must be returned.

range_lookup: [optional] A logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match.

Example:

In this example, we have a table of data with student names in the first column and their corresponding grades in the second column. We want to find the grade of the student “John”.

We can use the VLOOKUP function to search for “John” in the first column and return the corresponding grade from the second column.

The formula would be:

=VLOOKUP(“John”, A2:B6, 2, FALSE)

The result is “A”, which is the grade of the student “John”.