<div>
put this in Column A of Sheet1 &nbsp;=IFERROR(INDEX(Sheet2!A:A,<wbr />MATCH(B2,S<wbr />heet2!A:A,<wbr />0)),&quot;Not Found&quot;)
</div>


put this in Column A of Sheet1  =IFERROR(INDEX(Sheet2!A:A,MATCH(B2,Sheet2!A:A,0)),"Not Found")

<div>
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!
</div>


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!

<div>
<div class="content wysiwyg-content">
I have got 2 sheets in an excel document. Both sheets have a column named &quot;fullPath&quot; (for arguments sake it is column B on sheet 1, and column A on sheet 2).<br />
<br />
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). <br />
<br />
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.
</div>
</div>


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.

joining data from 2 sheets

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.