Match up Names in Excel or Access [Closed]

Report
-
Posts
47365
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
June 2, 2021
-
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.


1 reply

Posts
47365
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
June 2, 2021
10,522
Behind every answer, to help given on the forum, there are human volunteers who give their time trying to solve users' problems.

Therefore, it is expressly requested from kioskea forums users to show their utmost respect. For this, the use of polite expressions is a minimum.
https://ccm.net/contents/948-terms-of-use-for-ccm-respect-for-others#politesse

* Please, re-write your message accordingly, respecting the politeness charter and repost your message.

Please, thank you, appreciate, greateful are words among those forms

We trust that you understand

Moderator

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!