http://www.excelcampus.com/pivot-tables/compare-lists-with-pivot-table/
Learn how to create a simple report to compare two or more lists of data with a pivot table. This pivot table technique is very fast and easy to implement and does NOT require any complex formulas. Download the workbook to follow along.
http://www.excelcampus.com/newsletter/