Compare Two Excel Spreadsheets

We have two excel spreadsheets which we need to have analyzed for matches. If there is a match we need to note it on the first spreadsheet with a new column called "Match" with an "x". In addition, if there is a match we want to pull 3 additional columns from the second list and paste them into our first list. I can explain more about this if it's not clear. List are not the same format. First spreadsheet contains 43,180 records and the second contains 6,460 records. Match should be done with First, Last and potentially address, city or state depending if there are duplicate first and last names between the lists.