Forum Discussion
Relationship between cells
Hi all, I'm currently analyzing extensive data from Zip codes in many states, such as income, population, and housing units. I'd like to compare the primary zip code to the zip codes of the nearb...
Hello Hans, thank you for your reply
I have a list of zip codes with formulas that calculate the distance between two zip codes, and this is no longer an issue because I can use the filter to find the nearest zip codes by any range I prefer.
Now I'm having difficulty to compare the zip code to other zip codes in each cell to get the result. to save time, I think that a search box would be a better option. Kindly see the picture below. appreciated that
data
What is the formula you're currently using?
- by converting radians to degrees, vlookup
Actually, it has nothing to do with formula, I prefer to link the search box to the first column with is (From (ZIP).In your formulas in column M and N, replace the reference to K10, K11, etc. with $L$4
- thanks a lot Hans I will try it.