Hi Karen,
You also need to specify a fourth argument, which tells it to do an exact look up:
=VLOOKUP(A2,'Sheet1'!$A$2:$B$141,2,0)
If you omit the fourth argument (it is optional) then VLOOKUP does an approximate match. This can be great when your data is sorted, because the formula calculates more quickly.
|