I have an Excel file with a list of 2,000 properties dated January 2009 and have a separate list with 2,200 properties dated September 2009.

How can I use Filemaker to show the properties that are on both lists and the properties that on one list but not the other?

Actually a need to separate the properties into three categories, NoChange, Removed, Added.

The fields are Property Ref (unique), Property Name, Property Size and the list date.

Import both Excel files into separate tables in a FMP file. Create a relationship between the two tables based on the "property identification" field*.

Create portals that display the related records, from which you can deduce the information you need.

*This is probably the trickiest part. The properties need some identifier that is unique to each, and identical for all that are the same.