Hi,
I assume employee # is in colum A and the date fo hire in column B so in
book 2 enter

=index(book1!$B$1:$B$10000,match(a1,book1!$A$1:$A$ 10000,0))

copy formula down, change range to fit your needs

"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.