Running two lists of addresses to find matches
I'm new to FileMaker and would appreciate any help on this question. Right now I have a database open made from an imported Excel spreadsheet of housing data. One of the Excel columns/FileMaker fields is home address. I have another spreadsheet with a list of home addresses that I'd like FileMaker to compare with the address field in the first data set and find any matches. Basically, I'd like FileMaker to tell me all of the addresses that show up on both lists. Can FileMaker do this, and if so, how?