ScanID Match?Y/N Case Date/Time


20002 Match ????? 20001 1/10/2000
8:40 20004 No match 20002
4/16/2000 14:20 20006 No match 20003
11/3/2000 23:00 20007 No match
20043 7/30/2000 22:10 20043 Match ?????
20021 1/2/2000 1:49

One way is to put this in C2 and copy down:
=IF(ISNA(VLOOKUP(A2,D:E,2,FALSE)),"",VLOOKUP(A2,D: E,2,FALSE))