Postcode to postcode distance checker

Hi and welcome to the forum!

Assuming that the Latitude and Longitude for the first of your 40,000 for which you wish to obtain a result are in B2 and C2 respectively, try this array formula**:

=INDEX(PostCode,MATCH(SMALL((SQRT(ABS(B2-Latitude)^2+ABS(C2-Longitude)^2)),1),SQRT(ABS(B2-Latitude)^2+ABS(C2-Longitude)^2),0))

where you should replace PostCode, Latitude and Longitude with the appropriate ranges pertaining to the 22 in your actual set-up (e.g. replace PostCode by $X$2:$X$23, etc.).

Regards


**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).