Hello everyone,
I have an excel sheet that contains a list of zip codes with latitude and longitude. I want to create a UDF in excel taht will calculate the distance between two zip codes.
I have the formula to calculate the distance my problem is I'm not sure how to have a UDF look in another sheet or file for the latitude and longitude of the zip codes specify.
for examply lets say if i call my function distance then i would type something like this on the cell i want to get the distance "=distance(zipcode1,zipcode2)"
I have an excel sheet that contains a list of zip codes with latitude and longitude. I want to create a UDF in excel taht will calculate the distance between two zip codes.
I have the formula to calculate the distance my problem is I'm not sure how to have a UDF look in another sheet or file for the latitude and longitude of the zip codes specify.
for examply lets say if i call my function distance then i would type something like this on the cell i want to get the distance "=distance(zipcode1,zipcode2)"