Merging 2 files/tables with common variable

Hi all,



I wonder if it's possible to merge two or more excel files(or access tables or some way with programming involved)
that has a common variable (id). However, the ids from the tables may or may not match.




Here is an illustration of what I want(shown below are TABLE 1, TABLE 2, and the TABLE that I want after merge):

Table 1:

id address office

1 1 1
3 1 2
6 2 2
8 1 4
10 4 3


Table 2:

id postal money

1 1 2
4 2 2
6 1 1
7 1 3
9 4 3


TABLE after the merge:

id address office postal money

1 1 1 1 2
3 1 2 - -
4 - - 2 2
6 2 2 1 1
7 - - 1 3
8 1 4 - -
9 - - 4 3
10 4 3 - -



I hope I am clear!

Any help would be much appreciated!

Please see the attachment. I've used VLOOKUP functions to merge the data sets.

The solution is exactly what I am looking for.
Unfortunately, I can't figure out how the solution in Book1.xls works!
Could you elaborate on the VLOOKUP function?
I am not an IT person but an end-user.
Many thanks.

Suggest looking at help within Excel where there is a good explanation.