Paste two lists and find the overlaps, near-matches and gaps. Unlike VLOOKUP, this matches by the real location — "123 Main St" and "123 Main Street, Unit B" count as the same place.
String matching thinks "123 Main St" and "123 Main Street, Unit B" are different places, and thinks "10 Church Rd" in two different towns are the same. Location matching geocodes both lists first, then compares the actual points — the way a person with two maps would.
In Google Sheets you can do the same thing with formulas: =GEOCODE(A2) both columns, then =CLOSEST_TO(B2, 'List B'!A:A) finds each address's nearest counterpart — live in your sheet, no exports.