Hi,

New to the forum. Looking for any insight someone might have on the matter,

I have figured out how to calculate the distance between to coordinate points in excel, but I'm having trouble with the following:

I have two different files. Both files contain a list of Latitude and Longitude coordinates. I'm using list A as the target file (which contains zip codes and Latitude/longitude) and List B is the reference file which contains longitude and latitude coordinates

What I'm specifically looking to do is to return the two closest coordinates from the reference file and place them in the target list with the zip codes. both lists contain about 4000 rows.

Any help is appreciated!