Create a Google Sheet worksheet comparing two lists

Job ID: 32843928

Budget: €12 – €18 EUR

I am needing a Google Sheet worksheet created where I can copy and paste two lists into it each month and have it compare the lists and highlight the differences. I will need it to be able to compare partial matches, as one list is full names and the other is showing first and last names - therefore I will need it to be able to match the last name even if the entire cell does not match.
Related categories: Data Processing Data Entry Excel Word Web Search