How to use VLOOKUP Function (Formula) in Excel

VLOOKUP

Use of VLOOKUP Function (Formula) In Excel

In VLOOKUP "V" stand for "Vertical lookup".

Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify. By default, the table must be sorted in an ascending order.

Syntax/Formula of VLOOKUP Function in Excel

The syntax of VLOOKUP function in Microsoft Excel is below

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

Example of VLOOKUP Function in Excel

In below example we need total marks of all student in cell C2 to C11. 

So in this case we use VLOOKUP function to get all students total marks.

In both table unique value is Student Roll No so its our lookup value,

table_array is Second table location is E1:J11,

col_index_num is no of columns in second table is 6, and

range_lookup is 0 or False for exact match. or you can use 1 or True for approximate match.

I recommend please use 0 or False it give you accurate result.

Step 1: First create below "Table 1" in cell location A1:C11 and "Table 2" in cell location E1:J11

Step 2: Type formula =VLOOKUP(A2,E:J,6,0) in cell C2 and press enter.

Step 3: Copy VLOOKUP formula from cell C2 and pest it in to cell range C3 to C11.

VLOOKUP FUNCTION