GeoCoding - Find the closest point

Hello All,

As the title states, I have 2 lists with several points, list 1 has ~200k coordinates (Lat/Long), and list 2 has about 2,400 coordinates. The idea is to step through each of the 200k coordinates and find which of the 2,400 coordinates is closest.

Currently I've been trying it in a spreadsheet, but since I'm using 32bit it goes kaput on me.

Any ideas?

The formula for calculating distance between 2 GPS points is as follows:

=131332796.6*(ACOS((COS(lat1)*COS(long1)*COS(lat2)*COS(long2)+COS(lat1)*SIN(long1)*COS(lat2)*SIN(long2)+SIN(lat1)*SIN(lat2)))/360)

Taken from here: http://www.ehow.com/how_7695232_conv...ates-feet.html

Attached is a small sample of how I've been doing it the brute force method.