Results 1 to 4 of 4

Thread: Cross Sheet References within cells

  1. #1

    Cross Sheet References within cells



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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)
    Last edited by Connor Dickey; 2013-05-17 at 08:09 PM.

  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    780
    Articles
    0
    Excel Version
    2010
    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

  3. #3
    Thank you this was exactly what I needed. Vlookup worked great!

  4. #4
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    780
    Articles
    0
    Excel Version
    2010
    Glad to be of help.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •