Vlookup between 2 sheets to return value in one

Hello,

I have two worksheets - a master one with 20k rows and a subset one with 2k rows. Both have 5 columns. One of the columns is a name. I would like to compare all 2k against the 20k and return a value (specific date) in a 6th column in the master sheet. All 2k exist in the 20k Master sheet (so there are no extras) but they are scattered all over the 20k (but in the same column - so do not have to look for name in a range in the Master sheet). I thought Vlookup would be the right formula for something like this but after searching on various forums and youtube, I cant figure out how to return a value (a specific date in this case). Any help would be greatly appreciated. Thanks!!!

Thanks for the formula. Is there a way to include the date that I want to return as a value in the 6th column in the formula. So if the name from the 2k sheet exists in the 20k sheet then in the 6th column it will put in 1/22/2015 for all those 2k values? Just to clarify that I am looking to put the Date in the 6th column in the Master Sheet