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?