joining data from 2 sheets
Posted on 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.