I have a list of all ZIP Codes in the US and their approximate latitude and longitude. I have another list of select airports and their ZIP codes. I have a third list of shipments and their originating ZIP Codes. What I'm trying to determine is the closest airport to each shipment.
I'm using the following formula to determine the distance in miles.
I've adapted it into an array formula thus:Please Login or Register to view this content.
Evidently, though, the formula isn't evaluating the way I was expecting. It doesn't even seem to evaluate each member of tblTerms[ZIP] separately.Please Login or Register to view this content.
There's probably a better approach to this entirely, but I sure don't know what it is. Any advice?
I've attached a simplified sample file (missing about half the ZIPs to get under the size limit, but should still work).
Bookmarks