Hi Trish,
Assume that, on Sheet1, the emp ID is in column A, the employment date is in
column B, and column C is empty.
Assume that, on Sheet2, the emp ID is in column A and the training dates are
in column B.
Enter this formula in cell C1 on Sheet1. You'll need to adjust the $B$5
reference to reflect the last row of data on Sheet2. Then copy the formula
down.

=VLOOKUP(A1,Sheet2!$A$1:$B$5,2,FALSE)

HTH
--
Ken Hudson


"Trish Rice" wrote:

I have two worksheets with a common unique identifier for each employee. One
worksheet has the date of employment, and the other worksheet has a list of
training courses that have been completed by each employee. I need to
identify employees hired within a date range and check to see if they have
all completed their courses. This would be fairly easy if I could merge the
spreadsheets and sort by date of employment. I've been told that the best way
to handle this is to do a comparative analysis using vlookup, but I can't
find any info on that process.

PLEASE HELP!