Have a look in help at VLOOKUP
Then come back with more questions
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Adam" wrote in message
...
Hi All,

I need you help.

I have 2 Excel files.
In the file X I have a lot of records, each contains an identifier
and a lot of other columns, lets say B, C,..., K
In the file Y there are only some records with the same identifier
as in the file X but with other columns, lets say L,M,N.
The file Y doesn't contain any records with identifiers which are
not in the file X.
What I need is someting like updating file X by data in file Y,
i.e. a new file Z with all records from the file X where records which
identifiers are in the file Y should have also data in the columns
L,M,N from the file Y.
I don't know how to do it "automatically".

I will be very grateful for your help.

Regards,
Adam