Excel files matching through codes

Hello! I am pretty novice at Excel, so this question may end up being really dumb. But anyhow.

I am doing a workpaper that compares lobbying sectors through the money invested through each year in the House of Representatives.

But I have an issue. All the lines have a singular code (lets assume 1234-ABCD-6789). But, the three things I want (date, investment and sector, and the house) are in different files, so a single line is basically split in three, and because we purged data from all three files, we need to find a way to match all the codes who show up in both files (and gather them in a single cell) and then purge the ones who don't match.

Any ideas?

Thanks! English is not my native language, so sorry for some crude wording

Hi. As someone who has an interest in money and politics, I would like to help you, but I'm not sure I understand entirely what you need.

All the lines have a singular code (lets assume 1234-ABCD-6789).

Do you mean that there are line items in a spreadsheet, and this code is a unique key that identifies each transaction/lobbyist/etc?

But, the three things I want (date, investment and sector, and the house) are in different files

What kind of files? XLSX files?

we purged data from all three files

What do you mean by this? "To purge data" means that you've permanently erased the contents of all three files, in which case - you have no data whatsoever.

Do you have sample data/workbooks to show what it currently looks like and what you want it to look like?