I have 2 worksheets that are setup as follows:

wksht1:
column a = customer number
column b = customer name
column c = sales ytd

wksht2:
column a = customer number


What I need to do is pull the sales ytd from wksht1 and place it in wksheet
2 only if the customer number from wksht2 has a match in column a in wksht1.

I've tried a vlookup, but it doesn't quite do what I need it to. Can anyone
point me in the right direction?