I have two files containg employee data. File "name" contains two
colons: Name and Cardnumber like this:

Andersen John, 98372839
Angell Berit, 53827384
Bang Jens, 98128493

and my second file contains two colons: Name and username

Angell Berit, angber
Henriksen Christopher, henchr

As you see some of the names appear in both files, some don't. I need
to have a file with Cardnumber (from first file) and username (from
the second file).
Can this be done? Please help

thanks in advance
khers

Let's say the first set of data is in A1:B100 and the second in F1:G80
In C1 enter =VLOOKUP(A1,F1:G80,2,FALSE) to pick up the username
But you say that some people my not have a username?
So change formula to
=IF(ISNA(VLOOKUP(A1,F1:G80,2,FALSE)),"",VLOOKUP(A1 ,F1:G80,2,FALSE))
so that you do not get error values for missing people


If you now a list with just card numbers and usernames:
Select B1:D100; copy
Move to new worksheet, use Edit | Paste Special with Values specified
Sort this data so as to remove the blanks

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"khers" wrote in message
...
I have two files containg employee data. File "name" contains two
colons: Name and Cardnumber like this:

Andersen John, 98372839
Angell Berit, 53827384
Bang Jens, 98128493

and my second file contains two colons: Name and username

Angell Berit, angber
Henriksen Christopher, henchr

As you see some of the names appear in both files, some don't. I need
to have a file with Cardnumber (from first file) and username (from
the second file).
Can this be done? Please help

thanks in advance
khers

Excel 2007 Tables
Consolidate tabs, consolidate rows.
Uses macro.
http://www.mediafire.com/file/qommjogdyla/08_12_09.xlsm