Cross Sheet References within cells

**Connor Dickey** · 2013-05-17, 07:03 PM

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)

**Hercules1946** · 2013-05-18, 09:31 PM

Hello
How is the data in Sheet 2 formatted? If the district codes are a string of characters in one cell adjacent to the County, then a VLOOKUP formula will do it. If the codes are in separate cells in the same row, or multiple county records with one code per each record, then you will need something else. Also you mention district names, but you haven't said where these are (unless you mean the codes).
A sample workbook would be good here, including how you want to present the extra detail on Sheet 1.

HTH