OK, but if I want to inclue all the records from both files, for example:
I have one file with fields
F1 F2 F3 ....
1 2 31
2 3 32
3 4 33
7 7 37
and I have to update it from another file with fields
F1 F3
1 51
3 53
5 55
where F1 is the key field
as a result I must receive:
F1 F2 F3 ....
1 2 51
2 3 32
3 4 53
5 55
7 7 37

How can I do it?



"Anne Troy" wrote:

You need a vlookup, Raya. Pull both sheets into one file (makes it a little
easier):
http://www.officearticles.com/excel/...ft_excel .htm

Then use Vlookup. I've got absolutely complete instructions he
http://www.officearticles.com/tutori...excel.htm#boss

*******************
~Anne Troy

www.OfficeArticles.com



"Raya" wrote in message
...
I have one file with fields
F1 F2 F3 ....
1 2 31
2 3 32
3 4 33
and I have to update it from another file with fields
F1 F3
1 51
3 53
where F1 is the key field
as a result I must receive:
F1 F2 F3 ....
1 2 51
2 3 32
3 4 53
How can I do it?