Joining two tables on the basis of a Key

Hi is there a way to achive the following in excel without writing anykind of VB or ADO scripts

table1
column1 column2
1 a
2 b
3 c
4 d

table2

column1 column2
1 aa
2 bb
3 cc
5 e

result

column1 column2 column2
1 a aa
2 b bb
3 c cc
4 d
5 e