Learn how to a build a cloud-first strategyRegister Now


Connecting Excel Data from different spreadsheets

Posted on 2011-10-20
Medium Priority
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

strickdd earned 1000 total points
ID: 37000541
sounds like what you are doing is more geared towards using an Access database with FK relationships.

Author Comment

ID: 37000813
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?

Accepted Solution

Davy2270 earned 1000 total points
ID: 37000928
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

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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A high-level exploration of how our ever-increasing access to information has changed the way we do our jobs.
When asking a question in a forum or creating documentation, screenshots are vital tools that can convey a lot more information and save you and your reader a lot of time
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

810 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