Forum Discussion
Matching columns in two spreadsheets
I have a larger spreadsheet with email addresses in one column and a lot of other demographic data in the other columns. I have a second, smaller, spreadsheet also with email addresses in one column....
This is a job for Power Query in my opinion. In the attached file you can add data to the blue dynamic tables. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
The data layout in the screenshot and in the attached file is for illustration. You can place the green result table to the right of the blue tables or in another worksheet. Actually it doesn't matter if the tables are in the same sheet or in different sheets.