I wish to compare two columns of thousands of file names, Col A and Col D.
Columns D and E are unique pairs, and I'd like to create a file where I can
link Col A and E. When there is a match in Col A with an identical file name
in Col D I'd like to place the value of Col E adjacent to the matches value
in Col C, where the ????'s are. How can this be done.

Col A Col B Col C Col D Col E
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

Thanks!