Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 85
  • Last Modified:

joining data from 2 sheets

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
pma111
Asked:
pma111
  • 2
1 Solution
 
ProfessorJimJamCommented:
put this in Column A of Sheet1  =IFERROR(INDEX(Sheet2!A:A,MATCH(B2,Sheet2!A:A,0)),"Not Found")
0
 
pma111Author Commented:
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
 
ProfessorJimJamCommented:
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

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now