Connor Dickey
New member
- Joined
- May 17, 2013
- Messages
- 2
- Reaction score
- 0
- Points
- 0
I have a list of hospitals in different counties. Based on the county, I want a column to display the appropriate district names within that county. I have a separate sheet that displays all districts within each county. What steps do I need to take to execute make these district numbers display based on the name of the county?
For example:
Name / County / Districts Within County
Ashtabula County Medical Center / Ashtabula / ?
Children's Columbus / Franklin / ?
Akron Children's / Summit / ?
Sheet 2 contains:
County / Districts Within County
Astabula / 64, 99
Franklin / 17, 18, 19, 20, 21,
Summit / 34, 35, 36, 37, 38,
How do I make the first sheet show the districts within?
(They are not all in order, and there are many more counties and district ranges)
For example:
Name / County / Districts Within County
Ashtabula County Medical Center / Ashtabula / ?
Children's Columbus / Franklin / ?
Akron Children's / Summit / ?
Sheet 2 contains:
County / Districts Within County
Astabula / 64, 99
Franklin / 17, 18, 19, 20, 21,
Summit / 34, 35, 36, 37, 38,
How do I make the first sheet show the districts within?
(They are not all in order, and there are many more counties and district ranges)
Last edited: