[File2.xls]Sheet1!
C D
1 IDnum DateJoined
2 ID001 2/3/1991
3 ID002 3/4/1992
4 ID004 4/5/1993
5 ID005 5/6/1994
6 ID006 6/7/1995
7 ----- --------

[File1.xls]Sheet1!
A B
1 IDnum DateJoined
2 ID006 6/7/1995
3 ID004 4/5/1993
4 ID001 2/3/1991
5 ID005 5/6/1994
6 ID003 #N/A
7 ID002 3/4/1992
8 ----- --------

[File1.xls]Sheet1!B2: =VLOOKUP(A2,[File2.xls]Sheet1!C:D,2,FALSE)


--
Mike


"gloriamar" wrote in message ...