Each Zip Code listed in row 1 has 4 data elements. I am trying to find the Miles for the Zip listed in row 1 and match it to the zip code 1 column over from it and give me the miles to the right of that. Essentially, I have two cells containing the 1st zip code and another containing the second zip code. I need a formula to find the Miles on the table. The data directly under the zip in row 1 is the format I get when I import that data so I used the 3 columns beside it to extract out the Zip, Miles and City.
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
<tbody>
</tbody>
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> </tbody> | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<tbody>
</tbody>