join 2 spreadsheets

[Guest]

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?

 

[Anne Troy]

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

Then use Vlookup. I've got absolutely complete instructions here:
http://www.officearticles.com/tutorials/an_extreme_tutorial_in_microsoft_excel.htm#boss

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

www.OfficeArticles.com

 

[Guest]

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?