Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

joining data from 2 sheets

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

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 26

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

809 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