Assuming that book1 contain emp# are in col A and date are in col C
and emp# are in col A of Book2

try this in book2 and copy down.

=VLOOKUP(A2,'E:\Documents and Settings\Administrator\My
Documents\NewsGroup\[book1.xls]Sheet1'!$A$1:$C$100,3,0)

Change path and range to suit yours.
take note that both workbook need to be open
--
Hope this help

Please click the Yes button below if this post have helped in your needs

Thank You

cheers, francis





"dpdave" wrote:

I have 2 workbooks. workbook1 contains a list of employees, emp# and date of
hire. Workbook 2 has a differnt list of employees. I need to compare the
emp# in book1 against all emp# in book2. If the emp# from book1 matches the
emp# in book2, I need to copy the date of hire from book1 into the
appropriate cell in book2. I must compare the entire contents of book1
against book2.