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.
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.
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.