Excel 2007 :: Find Duplicates Across Two Different Tables

I'm running Microsoft Office 2007.

I have 2 separate tables.. both a list of contacts of sorts.

In one table I have a list of all my clients (table A), in the other I have a list of "preferred" clients (table B).

The contact details etc that are stored in table A are more comprehensive to those in table B.

Effectively, I want to search for all of my preferred contacts from table B and filter for them in table A.

Then ideally I will sort alphabetically and just cut and paste the details into my preferred client spreadsheet.

I had a look online and there was something about creating a "relationship" but I don't think excel 2007 allowed me to do it. I certainly hadn't heard of powerview or powerpivot that they were using!