Comparing two worksheets

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

You can do this with VLOOKUP

e.g.

In WS2, B2 (assuming first Name is in A2), enter

=VLOOKUP(A2,'WS1'!$A:$C,3,FALSE)

copied down after you adjust sheetname and ranges to suit.