Copy Data When a Matching ID # is Found

How do I match ID numbers and then copy corresponding data from one spreadsheet to another, when there may be one or multiple instances of the same ID number, and an ID number may be present in one spreadsheet but not the other? This is because the reports I am receiving from two different sources are based on transactions for the same population of users. Perhaps I need to separate the transaction specific data from the static data associated with each ID number (person). Not sure what the best practice is for prepping the data.

Seems that a VLookup or pivot table may be the right tool but I haven’t been able to figure it out.

I have attached a sample of what the data looks like.

If you can provide any assistance it would be much appreciated.

Paul

PaulStamper,

What is your expected output?

If there are "multiple instances of the same ID number", then they aren't very useful as ID numbers, especially if you need to match them.

If you want values from table 1 returned to table 2, vlookup will work just fine...
=VLOOKUP($E5,$A$5:$C$12,2,FALSE)
this is searching for the value in E5, in the range A5:C12, then returning the value in the 2nd column...the false is making sure its an exact match.
Repeat for the next column, changing the ,2, to ,3, for the 3rd column.

to prevent #NA error messages from showing - this happens when the item isnt there, you can wrap the formula in =iferror()...
=IFERROR(VLOOKUP($E5,$A$5:$C$12,2,FALSE),"Not Found")
change "Not Found" to whatever you want

mltiple ID numbers will throw this off though, so you need to do something with them?

Dont forget that if your ID's are not all unique, the vlookup will only return the very 1st match it finds. If they are not unique, you will need to find some way to make them unique - maybe by combining thee transaction number with the ID?