Hello experts,

How do I link 2 spreadsheets together? I don't know if I used the term "link" correctly. As you can see, I created 2 sheets, there are name that the same and there are name in spreadsheet 2 that aren't in spreadsheet 1.

I know the first step that I need to do is to seperate first and last name in 2 columns then how do I tell the Excel to let me know that Bob Smith is not in Spreadsheet 2?

Thank you for all your help!

Sheet 1:

Name

Alice Jone
Bob Smith
Claire Kennedy
Robert Cane
Amanda Chang

Spreadsheet 2:

Alice Jone
Joe Adam
Claire Kennedy
Robert Cane
Julie Nguyen
Michael Hoang