How to allocate rows from one tab to another based off similar text?

Export.xlsx

Hi,

Curious to know if there's a easier way to automate this process or if the only method is manual

Basically, as seen in my attached sheet, i have tab 1 with a "masterlist" of brand petrol stations and their allocated coordinates. On tab 2, i have a list of special brand stations that i extracted from another source. I want to allocate each of the sites in 2 to 1 so they get their corresponding coordinates attached to them.

Some of the names from 2 are the same as 1 so finding a match via vlookup is fine. However, some names have some differences e.g "Site Andy" in tab 2 is called "Site Andy Unmanned" and im assuming fuzzylookup is needed but unsure on how to allocate tab 1's coordinates to them. Additionally, i'm aware that some names on 2 might not exist on 1 so manual data entry/googling is needed which is fine. I've also been using the site address cells to cross verify the names too

Just looking how to get the quickest way to allocate the corresponding coordinates to same/differently named but same sites and highlight the non-existing ones so i can manually find the coordinates. Thanks!