You could try using the COUNTIF function for each entry in the two lists
to see which occur in the other list (i.e. having a count of 1). These
could then the sorted to get the common entries into a block. You could
then use a VLOOKUP function to bring together the two sets of data.
Alternatively, if you have absolutely no duplication within each, you
could get away with sorting each list's common entries by username and
then just line up the other two columns.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=568817