Solved

joining data from 2 sheets

Posted on 2014-11-18
3
68 Views
Last Modified: 2014-11-18
I have got 2 sheets in an excel document. Both sheets have a column named "fullPath" (for arguments sake it is column B on sheet 1, and column A on sheet 2).

I want to write a formula in column A of sheet 1, that essentially says if fullPath matches on both sheets, populate column A sheet 1 with the values in the column F of sheet 2).

So if for example sheet 1 column B and sheet 2 column A match, then I want the column A on sheet 1 to be populated with the values of column G in sheet 2. So in RDBMS terms the fullPath is essentially the primary key, and I want to join them together so I can bring in data from sheet 2 into sheet 1 where the keys match.
0
Comment
Question by:pma111
  • 2
3 Comments
 
LVL 25

Expert Comment

by:ProfessorJimJam
ID: 40449529
put this in Column A of Sheet1  =IFERROR(INDEX(Sheet2!A:A,MATCH(B2,Sheet2!A:A,0)),"Not Found")
0
 
LVL 3

Author Comment

by:pma111
ID: 40449552
Thanks, can you explain how that formula is copying over data from column G of sheet 2 for cases where there is a match? I will give it a go shortly!
0
 
LVL 25

Accepted Solution

by:
ProfessorJimJam earned 500 total points
ID: 40449559
ok  

try this one put thsi formula in A2 of Sheet1


=IF(ISNUMBER(MATCH(B2,Sheet2!A:A,0)),CONCATENATE(B2,Sheet2!G2),"No Match")
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
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…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

762 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

22 Experts available now in Live!

Get 1:1 Help Now