Solved

joining data from 2 sheets

Posted on 2014-11-18
3
73 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Outlook Free & Paid Tools
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

821 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