Comparing two worksheets

[Mumps]

Hi there,

I need to add a new column to a worksheet, but I have run into a problem with how to populate it.

I have one worksheet which contains roughly 50,000 records, in 3 columns. We can call this WS1
Name, Description, Date

I have another worksheet, which contains roughly 1,000 records. We can call this WS2.

In WS2, I have a Name field, and all of the data in this name field is located in the much larger Name field in WS1. What I need is to match the Name fields from WS1, and WS2, and then add the Date column to WS2. I am not sure if that made any sense, I hope I described it well enough.

Any help would be greatly apreciated! :D