The list on the left has about 1600 names


The list on the right has about 1900 names, which contain all of the list on the left names plus about 300 extra scattered throughout.

Because of this I cant simply sort A-Z and and line up the names and see if the addresses are different.

Im wondering if theres a function that will compare the two last name cells and see if the address for the last name on the left is the same as the address for the last name on the right.

Thank you