VLOOKUP in Excel with example

 

Here are two Sheets-

1) The Master Sheet (Sheet 1), where the ID and NAME column exists.

2) The Lookup Sheet (Sheet 2), where only the ID column exists. 

Now we have to fill the Sheet 2 NAME column using VLOOKUP.

Just Follow these Steps,--

Lookup_value    = Select the columns of Sheet 2, by which we can look up the Name.

Table_array       = Select the columns of Sheet 1, contains ID and Name.

Col_index_num = Select the column no. of Sheet 1, which column value we need.

Range_lookup    = Use 0/False for Exact match. Or we can use 1/True for Closest match.

Now, the vlookup formula will be  =VLOOKUP(A2:A8,Sheet1!A2:B11,2,FALSE)

Now, add '$' sign and it will be  =VLOOKUP($A$2:$A$8,Sheet1!$A$2:$B$11,2,FALSE)

Now, It's done...