I have two spreadsheets:
The first contains a large amount of data on research projects. Each project has its own unique ID, listed in the first column of the spreadsheet. However, these IDs are listed multiple times as the spreadsheet contains the details each organisation participating in each project.
The second contains a single column that lists the unique project IDs I am interested in (approximately 400 of them), that I have extracted from a different spreadsheet.
Is anyone able to suggest a formula that would:
- Compare each unique project ID listed in the second spreadsheet to those in the first spreadsheet, and then select (or, even better extract to a new sheet) all the first spreadsheet rows that have a matching unique ID?
I use Excel very little and have no knowledge of Visual Basic, which is what I suspect I may need to use to do what I want. I've been through numerous tutorials on various Excel formulas, conditional formatting and so on, but I cannot find anything close to what I require.
Any help much appreciated.