Match up Names in Excel or Access

Hello,

I have a list in excel of of car types in column A and the owners in column B. A lot of owners have multiple cars of the same type making a list. ex:

A B a1 = car 1
1 a1 c1 c1 = owner 1...
2 a1 c1
3 a1 c1
4 a2 c2
.
.
.

5000 a3500 c2800
5001 a3501 c2
5002 a3501 c2
5003 a3501 c2
5004 ... ...

I then have a second excel worksheet with the owners in column A and their total cost for cars in column B. These 2 worksheets are not in the same order and some owners with bills do not show up in the first excel workbook with addresses.

What i want to do is match up all the owners in workbook 2 that are in work book 1. The eventual result would be a table that has
owner cost cars
|
v

I know this is very basic but I cant figure it out. There are over 13000 owners so I cant do it by hand. Any information will help. I have a basic understanding of access but from what i understand you cant create a relationship between 2 tables unless they are the same size and these 2 tables are not even close to being the same size. I have access 2003 and excel 2007.