find matching records

[-D-]

I have two spreadsheets with a common column in each spreadsheet where I
need to find the matching records based on this common column.

The first spreadsheet has 139 records (spreadsheetA) and the common column
name is "AccountId"
The second spreadsheet has over 9000 records (spreadsheetB) with the common
column name "AccountId"

I want to find the matching records in the "spreadsheetB" that has records
based on the AccountId in the "spreadsheetA". Once I find the matching
records I want to copy the new information over to the "spreadsheetA" that I
am obtaining from the "spreadsheetB".

How can I accomplish this?

Basically, I want to find records in "spreadsheetB" and merge them into
"spreadsheetA".

Thanks for any help.

 

[Pete_UK]

You would normally use VLOOKUP to do this, but you can also use an
INDEX/MATCH combination. Both of these approaches would return the
first matched item, so if you may have multiple records under one
AccountID then you have to take a slightly different approach (you
don't specify in your description). Give some further details of
columns used etc if you need more assistance.

Hope this helps.

Pete

 

[-D-]

Hi Pete,

Thanks for replying to my post.

If I understand correctly, yes, there are multiple AccountId's in
spreadsheetA. For example, there are 139 records in spreadsheetA, so there
are 139 different AccountId's in that spreadsheet. I need to match each
AccountId in spreadsheetA to a matching record in spreadsheetB. Can I do
this using a Vlookup? Is there an example of how to accomplish this?

Or, if you are asking if there are more than one match for AccountId in
spreadsheetB, then I don't think so. I'm not sure 100% certain though?

Thanks again for the help.


You would normally use VLOOKUP to do this, but you can also use an
INDEX/MATCH combination. Both of these approaches would return the
first matched item, so if you may have multiple records under one
AccountID then you have to take a slightly different approach (you
don't specify in your description). Give some further details of
columns used etc if you need more assistance.

Hope this helps.

Pete

 

[Pete_UK]

Detailed tutorial here at Debra Dalgleish's site:

http://www.contextures.com/xlFunctions02.html

Hope this helps.

Pete

 

[Evgeny Grischenko]

Hi!
You might want to try this simple add-in:
http://www.office-excel.com/excel-addins/compare-spreadsheets.html
Hope it helps!

Eugene