match formulas

A

ACU1

I have 2 spread sheets. I would like to find all matches from both sheets and
put in a new spreadsheet. I've tried help files and cannot understand it. for
example, the source file has first name and last name as well as other
information. The data list I want to match only has first name and last name.
SO after it finds the match, I would like the subsequent data from that match
to be places in a new sheet.

any help would be greatly appreciated
 
Top