Copying/Creating a Zipcode (PostCode) distance checker assistance

Hello all,


I was given a postcode checker for the UK. There is a worksheet on the file for all the post codes along with latitude and longitude and I've managed to duplicate this list for the US with the same format. I found a zip code to latitude and replicated the format for the US section that I want to copy over.

When I attempt to copy over the formulas to calculate the distance and reference the respective locational data, it doesn't work and it presents me with #NA.

I've attached the list of sample zip/post codes with latitude and longitude.

When I try to get 'Lat_2' and 'Long_2' to work in the sheet "Multiple US", it comes up as blank for 'Lat_2' and #NA for 'Long_2.' The UK Sheets are working perfectly and I'm not quite sure what I'm doing wrong!