Lookup+combine two spreadsheets into third

[Benjamin Chait]

I have two spreadsheets: [spreadsheet 1] and [spreadsheet 2].

[spreadsheet 1] is a master list of people, contact information, etc.

[spreadsheet 2] is a smaller, selected list--everyone in this list
appears in [spreadsheet 1]

I want to open [spreadsheet 2] and go line-by-line and look up in
[spreadsheet 1] "name last" and "name first" (the two common columns
in both spreadsheets) and create a new [spreadsheet 3] that pulls the
data (i.e. contact info, etc.) from [spreadsheet 1] for everyone
listed in [spreadsheet 2].

Thoughts on how to do this?

 

[strapping]

I have two spreadsheets: [spreadsheet 1] and [spreadsheet 2].

[spreadsheet 1] is a master list of people, contact information, etc.

[spreadsheet 2] is a smaller, selected list--everyone in this list
appears in [spreadsheet 1]

I want to open [spreadsheet 2] and go line-by-line and look up in
[spreadsheet 1] "name last" and "name first" (the two common columns
in both spreadsheets) and create a new [spreadsheet 3] that pulls the
data (i.e. contact info, etc.) from [spreadsheet 1] for everyone
listed in [spreadsheet 2].

Thoughts on how to do this?

My favourite method would be to link both sheets into Access, and
write a query which went something like this:

SELECT * FROM spreadsheet1 INNER JOIN spreadsheet2 ON (spreadsheet1.
[name first] = spreadsheet2.[name first] AND spreadsheet1.[name last]
= spreadsheet2.[name last]);

(I've not tested that. It also assumes that the combinations of first
and last names are unique. It would be better if each row had a URN,
ie Unique Reference Number.)

You could even export the result as an Excel spreadsheet.

Of course, this isn't much help if you're not familiar with Access or
even don't have it installed.

Did you mean a solution involving VBA? That would be fairly
straightforward, but not so short & quick to write that I'm going to
do it here. Unless you pay me.

Not straightforward with worksheet functions either.