Connecting Excel Data from different spreadsheets

Posted on 2011-10-20
Last Modified: 2013-11-21
I have data in two different sets of data in spreadsheets that I need to connect based on a common id field. How do I do that?
Question by:dlawsmith
    LVL 28

    Assisted Solution

    sounds like what you are doing is more geared towards using an Access database with FK relationships.

    Author Comment

    Possible. Even if I could add the extra fields by lining up with the I'd or username. Is there a way to import the fields into the row based on one field?
    LVL 3

    Accepted Solution

    As strickdd says, Access would do the job best.

    However if you want to stay within Excel, you might try using the VLOOKUP function.
    Both your datasets should then have the common field on the outer left of the data set.

    the vlookup formula would look like this:
    =VLOOKUP (select the common field data set 1,select the entire dataset 2 and press F4,enter the column number of which you want to link the data from, False)

    LVL 11

    Expert Comment

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Lately there has been a variety of news related to U.S. employment.  Stories about worker productivity, automobile and airline unions, low employment and foreign laborers have frequented the news.  Each story has good and bad attributes we might arg…
    Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
    This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now