Copy matching data

[Simon_Wolf13]

I'm trying to figure out the code I need to check a series of data in one spreadsheet and paste the info in the second and third columns of the target sheet to a sheet in a new workbook, where data in the first column of the source and target sheets match.

 

[DonnyF]

Index match array?

 

[Simon_Wolf13]

Index match array?

Thanks I will give that a try