Hi,

I have two spreadsheets that I'm looking to merge into one. Spreadsheet one has one column with a unique identifying key (example: 0099A). Column 2 has an owner name (Bob Smith). This is how it would look:

0099A | Bob Smith

Spreadsheet two is a list of properties. Column one has an identifying key that corresponds with the keys in spreadsheet one. The second column is a property address. Following the example above, one line of the spreadsheet would be:

0099A | 700 North Avenue

As you can imagine, there are many people who own multiple properties so the number of rows in spreadsheet one and two are not equal. What I'd like to do is have the unique key (column A)| address (column B) | owner name (column C) all on one spreadsheet.

From spreadsheet 2, what formula would I use to run through all of the identifying keys and add the corresponding owner name? I'm assuming I would have to copy paste the data from spreadsheet one into spreadsheet two.

BTW: I have excel 2013 if it matters.

Thanks!