Search for all the values on a list and copy a value from the same row for each match

[kusacw]

Hi there!

Well I have two databases with people in them, each database has different information, and they don't necessarily have all the same people, but they both have ID numbers.

So what I want to do, is see which ID numbers from Database 1 are in Database 2. This is the first part which should not be too complicated.

The second thing I want to do, is if an ID number from Database 1 is found on Database 2, I want to extract a value from the same person but from a different column.

Explained in other words: Say I have on Database 1 that has Name and Address, and on Database 2 I have Name and Age. What I would like is to see which people from Database 1 are ALSO on Database 2, and I want to know their ages, if possible in a new list/sheet/document that shows Name and Age. So the final document would be the people that are on Database 1 AND Database 2, with their ages.

Thanks in advance!

Kusac