How can I join 2 spreadsheets if I want both to update the fields of the main
file
by the fielda of the update file and to add the records of the update file
which aren't in the main file (I vannot use VLOOKUP in this case, or I don't
know how):
In my case I have the main file with records:
F1 F2 F3 ....
1 2 31
2 3 32
3 4 33
7 7 37
and I have to update it from the update 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?