Column Comparition/Lookup Problem

L

lookout2930

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!
 
M

MyVeryOwnSelf

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
Click to expand...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numbers from first column 6
lookup and multiple criteria 6
Counting unique values in multiple columns 4
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
Text and Numeric lookup 5
League table 3
Compare two cells in two different files and return answer 6
move blank data 10

Top