Arguments for the function - 1) column in data set #1 where the common value is (such as CustomerID), 2) the range of cells in data source #2 that you want to check against (the leftmost column in the range should have the common value [such as CustomerID]), 3) the column that contains the value in data set #2 that you want to look for in data set #1, as counted from the left of the range (3 means it's the third column from the left), 4) FALSE means to look for an exact match, TRUE means....
=VLOOKUP(A2,Sheet2!A:C,3,FALSE)