Spreadsheet: 107779d1304939124-what-function-should-i-use-to-lookup-the-closest-zip-code-closest-zip
Sheet: Sheet1

Five Digit Zip | 36345 | 36303 | 39823 | 39823 | 39823 | 36321 | 36301 | 36301 | 36312 | 31721 | 32460 | 32447 | 31705 | 39834 | 31730 | 32421 | 32424 | 32353 | 31714 | 32444
36345 |  | 7.6 | 25.5 | 25.5 | 25.5 | 15.5 | 17.4 | 17.4 | 21.2 | 73.1 | 55.6 | 45.3 | 89.1 | 73.1 | 91.8 | 69.4 | 78 | 88.6 | 136 | 87.7
36303 | 7.6 |  | 27 | 27 | 27 | 8.1 | 10 | 10 | 13.9 | 74.6 | 48.2 | 37.9 | 90.6 | 65.7 | 84.5 | 62 | 70.7 | 81.3 | 122 | 80.4
39823 | 25.5 | 27 |  | 0 | 0 | 23.6 | 32.3 | 32.3 | 26 | 49.2 | 43.4 | 47.9 | 65.2 | 56.6 | 64.1 | 73.7 | 79.4 | 72.2 | 96.2 | 106
39823 | 25.5 | 27 | 0 |  | 0 | 23.6 | 32.3 | 32.3 | 26 | 49.2 | 43.4 | 47.9 | 65.2 | 56.6 | 64.1 | 73.7 | 79.4 | 72.2 | 96.2 | 106
39823 | 25.5 | 27 | 0 | 0 |  | 23.6 | 32.3 | 32.3 | 26 | 49.2 | 43.4 | 47.9 | 65.2 | 56.6 | 64.1 | 73.7 | 79.4 | 72.2 | 96.2 | 106
36321 | 15.5 | 8.2 | 32.5 | 32.5 | 32.5 |  | 12.6 | 12.6 | 8.6 | 71.3 | 42.9 | 40.5 | 87.3 | 60.4 | 79.2 | 64.6 | 68.2 | 76 | 118 | 82.9
36301 | 17.4 | 10.1 | 42.3 | 42.3 | 42.3 | 12.7 |  | 0 | 18.4 | 80.5 | 50.1 | 28.5 | 96.5 | 70.3 | 89 | 52.6 | 61.3 | 76.6 | 127 | 70.9
36301 | 17.4 | 10.1 | 42.3 | 42.3 | 42.3 | 12.7 | 0 |  | 18.4 | 80.5 | 50.1 | 28.5 | 96.5 | 70.3 | 89 | 52.6 | 61.3 | 76.6 | 127 | 70.9
36312 | 21.3 | 13.9 | 26.1 | 26.1 | 26.1 | 8.6 | 18.3 | 18.3 |  | 72.7 | 36.5 | 32.1 | 93.2 | 54 | 72.7 | 57.9 | 63.5 | 69.5 | 124 | 88.6
31721 | 73.1 | 74.6 | 50.1 | 50.1 | 50.1 | 71.3 | 79.9 | 79.9 | 72.7 |  | 86.8 | 91.4 | 21.1 | 58.9 | 44.1 | 117 | 123 | 87.3 | 51.2 | 149
32460 | 55.6 | 48.3 | 43.6 | 43.6 | 43.6 | 42.9 | 50.1 | 50.1 | 36.5 | 86.8 |  | 21.3 | 105 | 50.8 | 70.2 | 38.9 | 32.5 | 34.3 | 127 | 78.5
32447 | 45.3 | 38 | 48.2 | 48.2 | 48.2 | 36.7 | 28.5 | 28.5 | 32.1 | 91.4 | 21.3 |  | 101 | 61.7 | 80.5 | 31 | 40.8 | 54.5 | 132 | 63
31705 | 89.1 | 90.6 | 66.1 | 66.1 | 66.1 | 87.3 | 95.9 | 95.9 | 93.2 | 21.1 | 105 | 101 |  | 60.6 | 36.9 | 127 | 125 | 90.3 | 34.9 | 159
39834 | 74 | 66.7 | 57.6 | 57.6 | 57.6 | 61.4 | 71.1 | 71.1 | 54.9 | 50.4 | 50.6 | 62.6 | 61.2 |  | 26.9 | 76.7 | 63.3 | 28.1 | 83.4 | 116
31730 | 91.8 | 84.5 | 65 | 65 | 65 | 79.2 | 88.9 | 88.9 | 72.7 | 35.6 | 70.2 | 80.5 | 37.5 | 26.9 |  | 96.3 | 91.1 | 56 | 59.7 | 136
32421 | 68.9 | 61.6 | 73.5 | 73.5 | 73.5 | 64.2 | 52.2 | 52.2 | 57.4 | 117 | 38.9 | 30.5 | 126 | 76.9 | 96.4 |  | 19.1 | 49.1 | 153 | 43.8
32424 | 78 | 70.7 | 79.6 | 79.6 | 79.6 | 68.2 | 61.2 | 61.2 | 63.5 | 114 | 32.5 | 39.6 | 126 | 71.7 | 91.1 | 19.1 |  | 36.5 | 148 | 48.9
32353 | 88.6 | 81.3 | 72.2 | 72.2 | 72.2 | 76 | 74.6 | 74.6 | 69.5 | 79 | 34.3 | 52.9 | 91 | 36.7 | 56.1 | 49.1 | 36.5 |  | 113 | 78.9
31714 | 127 | 122 | 97.6 | 97.6 | 97.6 | 119 | 127 | 127 | 125 | 48.1 | 128 | 132 | 35.2 | 83.7 | 60 | 154 | 149 | 113 |  | 193
32444 | 90 | 82.7 | 106 | 106 | 106 | 85.3 | 73.3 | 73.3 | 80.1 | 149 | 78.5 | 63 | 159 | 116 | 136 | 43.8 | 48.8 | 78.9 | 193
Shortest Distance | 7.6 | 7.6 | 0 | 0 | 0 | 8.1 | 0 | 0 | 8.6 | 21.1 | 21.3 | 21.3 | 21.1 | 26.9 | 26.9 | 19.1 | 19.1 | 28.1 | 34.9 | 43.8
Nearest ZIP | 36303 | 36345 | 39823 | 39823 | 39823 | 36303 | 36301 | 36301 | 36321 | 31705 | 32447 | 32460 | 31721 | 31730 | 39834 | 32424 | 32421 | 39834 | 31705 | 32421