Compare Data from Two Sheets and Extra the matching data with all the columns

[gatefire08]

Hello,

I want to compare data from two sheets. I want to pull all data from all columns in sheet one: ID, Name, and ***, Donor. but I only want to the return result to match the criterias in sheet 2. Please see the excel sample.

Thanks for your help.

[aydeegee]

Hi gatefire08

Somethin seems to have gone wrong with your file - it is empty !

Regards
Alastair