Column Comparition/Lookup Problem
 

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!

Column Comparition/Lookup Problem
 

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))