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...
