The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    Excel 2010 help

    Discussion in 'Windows OS and Software' started by krneki, May 19, 2012.

  1. krneki

    krneki Notebook Enthusiast

    Reputations:
    0
    Messages:
    22
    Likes Received:
    1
    Trophy Points:
    6
    I have a document in Excel 2010 which contains 2 columns. Data from 2nd column is constant, does not change and is assigned to data in 1st column. Names and surnames are great example, so I will use this case for explanation.

    Currently there are 200 names in 1st column and of course 200 surnames, attached to them in every row. There won't be any new names ever.

    This is functionality I'd like to have. I often have to copy some of those names from external database (software) in various numbers. Let's say 50 random names to 1st column. But when I do that, I have to manually write down surnames to 2nd column, because they come from another database (software) which is not synchronized with the first one, so I cant just copy/paste them.

    Is there any way to save (connect?) all 200 surnames to all 200 names in Excel, so when I would copy some of names from external database to 1st column, Excel would automatically attach appropriate surname to 2nd row?

    I hope I was clear. Thanks for help in advance!
     
    krneki, May 19, 2012
    #1
  2. au4all

    au4all Notebook Enthusiast

    Reputations:
    3
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    15
    It's an odd problem because you have a database that's missing one relationship which you've decided to store in excel instead of the database.

    If you don't want to do the logical thing and put the relationship in the database then I suggest you have a static worksheet with all possible names and surnames. And then you use the lookup function to load the worksheet that you paste names into.

    It's explained here: How to use the LOOKUP function in Excel

    Is that what you're looking for?
     
    au4all, May 19, 2012
    #2