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