mounstahman
New Member
- Joined
- Nov 13, 2016
- Messages
- 1
Hi everyone
So basically I have a table with zip codes and which county and state they are in (table A). I've simplified the data so there is only one zip code per county per state.
I have another list of health data by county and state (table B).
So basically what I'd like to do is to have a formula in an empty cell fetch the appropriate zip code corresponding to each of the county names listed in table B, using table A as a reference for which zip refers to which county.
It seems basic enough but I've looked everywhere and can't quite find something to solve this.
Thanks in advance!
So basically I have a table with zip codes and which county and state they are in (table A). I've simplified the data so there is only one zip code per county per state.
I have another list of health data by county and state (table B).
So basically what I'd like to do is to have a formula in an empty cell fetch the appropriate zip code corresponding to each of the county names listed in table B, using table A as a reference for which zip refers to which county.
It seems basic enough but I've looked everywhere and can't quite find something to solve this.
Thanks in advance!