Fastest way to match longitutdes and latitudes, thousands of data points

I have matched the points using =iferror(match(),0) and deleting all rows of zeros, and after a lot of copy/pasting, have got them into the columns shown in my attached example. I wrote a code that successfully matches them into their particular latitudes and longitudes, but it crashes my computer lol. So if there is a simpler solution than I am seeing, please help.